How to read excel from asp.net,c#. - Programmers Heaven

Howdy, Stranger!

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

Categories

How to read excel from asp.net,c#.

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

Osda.Fill(ds);
return ds.Tables[0];

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



Sign In or Register to comment.