110,533
社区成员
发帖
与我相关
我的任务
分享
string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=false; Data Source=E:\work\CreatExcel\CreatExcel\bin\Debug\测试表格1.xlsx; Extended Properties=Excel 12.0 ;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
System.Data.DataTable dt = null;
strExcel = "select * from [sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
dt = new System.Data.DataTable();
myCommand.Fill(dt); OleDbCommand cmd = new OleDbCommand();
string sheetName = "是否执行完毕";
string sqlDelete = @"DROP TABLE " + sheetName + ";";
cmd = new OleDbCommand(sqlDelete, conn);
cmd.CommandText = @"INSERT INTO " + sheetName + " VALUES (?????不知道这里是什么);";
cmd.ExecuteNonQuery(); [/quote][/quote]
string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=false; Data Source=D:\Book1.xlsx; Extended Properties=Excel 12.0 ;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
System.Data.DataTable dt = null;
strExcel = "select * from [sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
dt = new System.Data.DataTable();
myCommand.Fill(dt); OleDbCommand cmd = new OleDbCommand();
cmd = new OleDbCommand(@"INSERT INTO [sheet1$] (是否执行完毕) VALUES ('是')", conn);
cmd.ExecuteNonQuery();
cmd.CommandText = @"INSERT INTO [Sheet1$](Age) VALUES (100);";
几乎和sqlserver的语法一致。