How to read excel from,c#.

Giving errors while trieng wththe code as folows.
main codes as below:
OleDbConnection cnEx = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\ExcelTest.xls;Extended Properties=Excel 8.0");

OleDbDataAdapter Osda = new OleDbDataAdapter("SELECT * from [Sheet1$]",cnEx);

return ds.Tables[0];

-----------------------------Now the errorr is Jet ole can't find the object Sheet1.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!