Asp.net import EXCEL to datatable

Asp.net import EXCEL to datatable

1 front-end code:

 <Asp: fileupload runat = "server" id = "fupfiles" width = "300px"/>
Excel table name <asp: textbox id = "txtsheet" runat = "server"> sheet1 </ASP: textbox>

// The table name is in the lower-left corner of Excel. The default table name is sheet1, sheet2 ,...

 

2 Background:

String excelpath = fupfiles. postedfile. filename;
String strconn;
Strconn = "provider = Microsoft. Jet. oledb.4.0; Data Source =" + filepath + "; extended properties = Excel 8.0 ;";
Oledbconnection conn = new oledbconnection (strconn );
Oledbdataadapter oada = new oledbdataadapter ("select * from [" + sheetname + "$]", strconn );
Datatable dt = new datatable ();
Try {
Oada. Fill (DT); // get the datatable
}
Catch (exception ex ){}