错误代码:Exception from HRESULT: 0x800A03EC我的代码是:
object missing = Missing.Value;
Excel.Application myExcel = new Excel.Application(); //show Excel
myExcel.Visible = true; //open excel file
Excel.Workbook xbook = myExcel.Application.Workbooks.Open(excelfile, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); xbook = myExcel.Application.Workbooks.Add(missing);//new file
Excel.Worksheet xSheet = (Excel.Worksheet)xbook.Sheets[1];
//Excel.Worksheet xSheet=(Excel.Worksheet)xApp.ActiveSheet;
//write txt file into excel
StreamReader sreader = new StreamReader(slog_filename);
string sline = "";
int row = 0;
//int col = 0;
while ((sline = sreader.ReadLine()) != null)
{
if (sline == "") sline = "test";
xSheet.Cells[row, 1] = sline;
row++;
}
object missing = Missing.Value;
Excel.Application myExcel = new Excel.Application(); //show Excel
myExcel.Visible = true; //open excel file
Excel.Workbook xbook = myExcel.Application.Workbooks.Open(excelfile, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); xbook = myExcel.Application.Workbooks.Add(missing);//new file
Excel.Worksheet xSheet = (Excel.Worksheet)xbook.Sheets[1];
//Excel.Worksheet xSheet=(Excel.Worksheet)xApp.ActiveSheet;
//write txt file into excel
StreamReader sreader = new StreamReader(slog_filename);
string sline = "";
int row = 0;
//int col = 0;
while ((sline = sreader.ReadLine()) != null)
{
if (sline == "") sline = "test";
xSheet.Cells[row, 1] = sline;
row++;
}
参考:http://topic.csdn.net/u/20090903/09/a59f6b78-c419-4d9c-9be1-00720862e40c.html