请高人看下这段代码 c# 在创建excel sheet时为什么会失败?
bool exist = System.IO.File.Exists(@"C:\ConfigRecord.xls");
if(exist)
{
System.IO.File.Delete(@"C:\ConfigRecord.xls");
}
object missing = System.Reflection.Missing.Value;
Excel.ApplicationClass myExcel = new Excel.ApplicationClass();
Excel._Workbook xBk ; //工作薄
xBk = myExcel.Workbooks.Add(true);
xBk.SaveAs(@"C:\ConfigRecord.xls",missing,missing,
missing,missing,missing,Excel.XlSaveAsAccessMode.xlShared,
missing,missing,missing,missing,missing);
myExcel.Quit();
OleDbConnection excelConn = new OleDbConnection();
excelConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\ConfigRecord.xls; Extended Properties=Excel 8.0;";
excelConn.Open();
OleDbCommand oleExcelCommand=new OleDbCommand ();
oleExcelCommand.Connection =excelConn;
string basicInfotableName;
basicInfotableName="deviceInfo_BaseInfo";
sql="drop table " + basicInfotableName + ";";
oleExcelCommand.CommandText=sql;
try
{
oleExcelCommand.ExecuteNonQuery();
}
catch(System.Data.OleDb.OleDbException ex)
{
}
sql="create table "+basicInfotableName+" (DeviceType char, WholeDeviceCode char primary key";
sql=sql+");";
oleExcelCommand.CommandText=sql;
try
{
oleExcelCommand.ExecuteNonQuery();
}
catch(System.Data.OleDb.OleDbException ex)
{
MessageBox.Show(this,"创建数据库失败","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
总是提示“创建数据库失败”
说未找到表deviceInfo_BaseInfo