C# System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC Microsoft.Office.Interop.Excel._Workbook.SaveAs()

2
votes

I'm having issues with saving an excel spreadsheet when running on the Windows server 2008 and 2012 but this project its working on local pc (Windows 7,8 or 10)

C# source code

Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook excelWorkBook = excelApp.Workbooks.Add();
Microsoft.Office.Interop.Excel.Worksheet excelWorkSheet = excelWorkBook.Worksheets.Add();
excelWorkSheet.Name = "blablabla";
//added cells data
excelWorkBook.SaveAs(excelPath.ToString());
excelWorkBook.Close();
excelApp.Quit();

error message

Exception from HRESULT: 0x800A03EC System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC at Microsoft.Office.Interop.Excel._Workbook.SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Object AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local)

4
c#excelwindows
What is the application, a desktop app, a service, a website? - Equalsk
Opps! sory, this is a windows service application. - mesutpiskin
5 cents here. Please note that MS does not recommend nor support Windows Server Excel automation. Sooner or later you might hit a wall especially when dealing with security and need of interactive user session. Looks like its still early and you might have some room to consider other options. - Janis S.
@mesutpiskin there is a section in the link about alternatives. Though those will not give a good options if you are dependent on Excel engine, e.g., if you need to make formula calculations, graphs. In this case you might consider solutions where you have control of data types and use Excel as one of outputs generated using OpenXML with calculations done up in the data stream. - Janis S.
@jenis S. thanks for answer. - mesutpiskin

4 Answers

1
votes

Installing MS office in servers to run office.interop assemblies in u r project is the best option..

Again if u don't want to install MS office at all on server machine, Then u can install PIA (primary interop assemblies)

http://msdn.microsoft.com/en-us/library/kh3965hw.aspx

download link for PIA for office

http://www.microsoft.com/downloads/details.aspx?FamilyID=59daebaa-bed4-4282-a28c-b864d8bfa513&DisplayLang=en

1
votes

This error is due to the fact that the local pc and the server have different office versions.I used the office 2012 references (microsoft office interop excel 14) but the server has a different version (microsoft office interop excel 12)

Step 1) I installed the same office versions. (v.12)

Step 2) Select "The interactive user" option in "Microsoft Excell Application Properties" window. https://msdn.microsoft.com/en-us/library/windows/desktop/ms686587(v=vs.85).aspx enter image description here

1
votes

This issue isn't caused by your code. My computer had both Office 2016 and 2010 on it, and after uninstalling 2010 and rebooting, the issue was fixed. Make sure to change the Application Reference to MS Office 14.0 Object Library (for Office 2010).

0
votes

Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(pathExcel, null,false);

need open readonly = false