asp.net 操作excel时报0x800A03EC总结

一、系统运行环境：window server 2008 R2+IIS 7+MS SQL Server 2008 R2

二、系统运行结果：Exception from HRESULT: 0x800A03EC，

报错异常点： xSheet.SaveAs(str,Missing.Value, Missing.Value, Missing.Value, Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

三、解决方法：

 xSheet.SaveAs(str,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);改成

 xBook.SaveCopyAs(str);//xBook-Microsoft.Office.Interop.Excel.Workbook对象变量