C# read excel cannot get the value

Question

I can read all of the value except 'one'.

This is my code:

OleDbConnection oledb_con = new OleDbConnection(strCon);

oledb_con.Open();

OleDbCommand oledb_com = new OleDbCommand("SELECT * FROM [sheet1$]", oledb_con);

OleDbDataReader oledb_dr = oledb_com.ExecuteReader();

while (oledb_dr.Read())
{                
       ActionList.Add(oledb_dr[0].ToString().Trim());
       ValueList.Add(oledb_dr[1].ToString().Trim());
}

oledb_dr.Close();
oledb_con.Close();

the ValueList[0] always show nothing,but other ValueList's member can read.

And theActionList[0] can read.

why cannot the first value be read.

And how can I solve it?

Well do you have any values available (maybe the row is blank or its header row so ignored) — V4Vendetta, Apr 16 '12 at 08:42
yes i can edit excel by myself. if header row ignored another column's header row should not be worked but only one column has problem. =( — Edison, Apr 16 '12 at 08:44
If your column is mixtype . maybe you need add "MaxScanRows=0;IMEX=1;" in your strcon . — shenhengbin, Apr 16 '12 at 09:02
if you have `HDR=Yes` in your connectionstring, try by specifying the column names on your select statement instead of `*`. Ex: `SELECT MyColumn1, MyColumn2 FROM [sheet1$]` — NaveenBhat, Apr 16 '12 at 09:56

mishak · Answer 1 · 2013-03-20T04:40:40.643

1

Have you checked if the value is not null? On null reading value as string fails.

oledb_dr.IsDbNull(1) ? "" : oledb_dr[1].ToString().Trim()

edited Mar 20 '13 at 04:40

answered Jan 29 '13 at 12:15

mishak

33
6

C# read excel cannot get the value

1 Answers1