Convert EXCEL to DataTable in the asp.net c#
Step 1:- Get the
absolute path for the Excel sheet .I used “Sample.xlsx”
string data = MapPath("sample.xlsx").ToString();
Step2:- Create the
connection string for the OLEDB connection
String strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data
Source=" + data + ";"
+
...