Howdy, Stranger!

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


How to read excel from,c#.

JosephmathaiKJosephmathaiK Member Posts: 1
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.