Question

C#向Excel中导入数据时报错 ： 其他信息: 异常来自 HRESULT:0x800A03EC？

object Nothing = System.Reflection.Missing.Value;
var app = new Excel.Application(); //这里报出HRESULT:0x800A03EC错误
app.Visible = false;
Excel.Workbook mybook = app.Workbooks.Open(excelName, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);
Excel.Worksheet mysheet = (Excel.Worksheet)mybook.Worksheets[1];
mysheet.Activate();
//获取激活工作表最大行数
int maxrow = mysheet.UsedRange.Rows.Count + 1;
mysheet.Cells[maxrow, 1] = filename;
mysheet.Cells[maxrow, 2] = findString;
mysheet.Cells[maxrow, 3] = replaceString;
mybook.Save();
mybook.Close(false, Type.Missing, Type.Missing);
mybook = null;
//quit excel app
app.Quit();

Answer 1

用 EPPlus 插件吧，导出excel很简单的。
using (ExcelPackage package = new ExcelPackage())
{
ExcelWorksheet sheet = package.Workbook.Worksheets.Add("Summary");
sheet.Cells[1, 1].Value = "1";
sheet.Cells[1, 2].Value = "2";
sheet.Cells[1, 3].Value = "3";
sheet.Cells[1, 4].Value = "4";
sheet.Cells[1, 5].Value = "5";
sheet.Cells[1, 6].Value = "6";

using (Stream stream = new FileStream(AppDomain.CurrentDomain.BaseDirectory + "\\Test.xlsx", FileMode.Create))
{
package.SaveAs(stream);
}
}
MessageBox.Show("搞定！");

Answer 2

有可能是dll与excel版本不匹配？
光上述错误看不出什么具体原因
一般除非你非常确定最终目标机器的excel版本，否则写excel数据不应该使用interop，用纯C#的开源库最好