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
– V4Vendetta, Commented Apr 16, 2012 at 8: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
– Edison, Commented Apr 16, 2012 at 8:44
If your column is mixtype . maybe you need add "MaxScanRows=0;IMEX=1;" in your strcon . — shenhengbin
– shenhengbin, Commented Apr 16, 2012 at 9: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
– NaveenBhat, Commented Apr 16, 2012 at 9:56

mishak · Accepted Answer · 2013-03-20 04:40:40Z

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, 2013 at 4:40

answered Jan 29, 2013 at 12:15

mishak

437 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# read excel cannot get the value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related