Import Excel to the database

DataTable dt = new DataTable ();//Global

First step: Upload to the server first
String Strfilenewname =datetime.now.tostring ("YYYYMMDDHHMMSS") + ". xlsx";
Fileupload1.saveas (Server.MapPath (". /excel/upload/"+ strfilenewname));

Step Two: Import the contents of Excel into a DataTable
using (OleDbConnection conn = new OleDbConnection ("Provider = microsoft.ace.oledb.12.0; Data Source = "+ Server.MapPath ("). /excel/upload/"+ strfilenewname) +" Extended properties=excel 8.0″ ")
{
string filepath = Server.MapPath (".. /excel/upload/"+ strfilenewname);
Bind (filepath);
}

Circular table

for (int i = 0; i < dt. Rows.Count; i++)
{To process the value that is taken}

private void Bind (string fileName) {
String strconn = "provider=microsoft.ace.oledb.12.0;" +
"Data source=" + FileName + ";" +
"Extended properties= ' Excel 12.0; Hdr=yes;imex=1 ' ";
OleDbDataAdapter da = new OleDbDataAdapter ("SELECT * from [sheet1$]", strconn);
DataSet ds = new DataSet ();
Try
{
Da. Fill (DS);
DT = ds. Tables[0];
}
catch (Exception err)
{
MessageBox.Show ("The operation failed! "+err. ToString ());
}
}

Import Excel to the database