using (OleDbConnection objConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath1 + ";Extended Properties='Excel 12.0;HDR=YES;READONLY=FALSE';")) { objConn.Open(); int totalSheet = 0; DataTable dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string sheetName = string.Empty; if (dt != null) { var tempDataTable = (from dataRow in dt.AsEnumerable() where !dataRow["TABLE_NAME"].ToString().Contains("FilterDatabase") select dataRow).CopyToDataTable(); dt = tempDataTable; totalSheet = dt.Rows.Count; sheetName = dt.Rows[0]["TABLE_NAME"].ToString(); } OleDbCommand cmd = new OleDbCommand(); cmd.Connection = objConn; cmd.CommandType = CommandType.Text; string SqlCommand = "INSERT INTO [" + sheetName + "] (F2,F3) VALUES(3036,'Sweet')"; cmd.CommandText = SqlCommand; cmd.ExecuteNonQuery(); }
using (OleDbConnection objConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath1 + ";Extended Properties='Excel 12.0;HDR=YES;READONLY=FALSE';")) { objConn.Open(); int totalSheet = 0; DataTable dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string sheetName = string.Empty; if (dt != null) { var tempDataTable = (from dataRow in dt.AsEnumerable() where !dataRow["TABLE_NAME"].ToString().Contains("FilterDatabase") select dataRow).CopyToDataTable(); dt = tempDataTable; totalSheet = dt.Rows.Count; sheetName = dt.Rows[0]["TABLE_NAME"].ToString(); } OleDbCommand cmd = new OleDbCommand(); cmd.Connection = objConn; cmd.CommandType = CommandType.Text; string SqlCommand = "INSERT INTO [" + sheetName + "] (F2,F3) VALUES(3036,'Sweet')"; cmd.CommandText = SqlCommand; var result= cmd.ExecuteNonQuery(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)