Question

C# excel 新建工作表出现异常来自 HRESULT:0x800A03EC。请教各位大神啊。

Application app = new Application();
Workbook wbook = app.Workbooks.Open(System.Web.HttpContext.Current.Server.MapPath("excel\\1\\报表.xlsx"), Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

wbook.Worksheets.Add(Missing.Value, "工作表名", Missing.Value, Missing.Value);
代码最后一行报错
操作excel别的都没问题啊

Answer 1

这样用：

Microsoft.Office.Interop.Excel.Worksheet s = 
(Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets.Add(Type.Missing,
 Type.Missing, Type.Missing, Type.Missing);
 s.Name = SheetName;