Could not create excel instance.( System.Runtime.InteropServices.COMException (0x80080005))

Question

Could not create excel instance.( System.Runtime.InteropServices.COMException (0x80080005))

milky007 6

[Win10/Office2016/C#(WPF)]
I am making an Excel automation program using Microsoft.Office.Interop.Excel.
In general, it works normally, but intermittently a problem occurs when generating Excel.

The excel generat code is as follows.
Microsoft.Office.Interop.Excel.Application App = new Microsoft.Office.Interop.Excel.Application();

Sometimes it takes time to generate Excel (generated after 2-3 seconds / But when there are no problems, it runs almost immediately.)
After not responding for a long time, the following exception occurs.

System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80080005.
System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)
at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)
at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType serverType, Object[] props, Boolean bNewObj)
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)

I've already tried reinstalling Office and checking the registry above, but it doesn't work.

Why does it take so long to create Excel?
Under what circumstances does the 0x80080005 exception usually occur?
Is there any workaround?

Hui Liu-MSFT 48,681 Reputation points Microsoft External Staff

2022-05-12T03:24:49.847+00:00

Hi,@milky007 . You could try to see if the solution here can explain the long time to create excel.
For COMException (0x80080005) exception, you could check the documentation Error when you start many COM+ applications: Error code 80080005 -- server execution failed.
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2022-05-12T09:21:09.857+00:00

I recommend moving from COM based code to using Open XML SDK if working with .xlsx format, it's faster and does not have the same issues as COM and Excel need not be installed. There are a handful of free third party libraries out there.
Mounira Ben Ali 1 Reputation point

2022-05-24T17:44:45.333+00:00

Yes that s ok

Karen Payne MVP 35,586 Volunteer Moderator

Using SpreadSheetLight (free NuGet package), see my GitHub repository for more.

public bool CreateNewFile(string pFileName, string pSheetName)
{
    using SLDocument document = new();
    document.RenameWorksheet("Sheet1", pSheetName);
    document.SaveAs(pFileName);
    return true;
}

Mounira Ben Ali 1 Reputation point

2022-05-25T07:25:48.133+00:00

Thank you

4 answers

Your answer

Hui Liu-MSFT 48,681 Reputation points Microsoft External Staff

2022-05-12T03:24:49.847+00:00

Hi,@milky007 . You could try to see if the solution here can explain the long time to create excel.
For COMException (0x80080005) exception, you could check the documentation Error when you start many COM+ applications: Error code 80080005 -- server execution failed.
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2022-05-12T09:21:09.857+00:00

I recommend moving from COM based code to using Open XML SDK if working with .xlsx format, it's faster and does not have the same issues as COM and Excel need not be installed. There are a handful of free third party libraries out there.
Mounira Ben Ali 1 Reputation point

2022-05-24T17:44:45.333+00:00

Yes that s ok
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2022-05-24T20:45:56.783+00:00

Using SpreadSheetLight (free NuGet package), see my GitHub repository for more.

public bool CreateNewFile(string pFileName, string pSheetName) { using SLDocument document = new(); document.RenameWorksheet("Sheet1", pSheetName); document.SaveAs(pFileName); return true; }
Mounira Ben Ali 1 Reputation point

2022-05-25T07:25:48.133+00:00

Thank you

Answer 1

Sana'a Ma'rouf Al-Hussien (Al Sabaiba'a) 161

There are a handful of free third party libraries out there.

Mounira Ben Ali 1 Reputation point

2022-05-24T17:45:46.347+00:00

Yes there s one
Mounira Ben Ali 1 Reputation point

2022-06-07T06:25:11.25+00:00

You can review

Answer 2

Abdelnaser Ahmedelhady Mohamed Mahmoud 21

There are a few free third-party libraries.

Answer 3

Karen Payne MVP 35,586 Volunteer Moderator

Take a look at EPPlus to read a sheet into a DataTable, convert to a pivot table then import the pivot table into a new sheet followed by removing the original.

Here are starter methods excluding pivot table where there is a article here.

Edit Pivot tables in EPPlus

Abdelnaser Ahmedelhady Mohamed Mahmoud 21 Reputation points

2022-05-25T19:07:52.67+00:00
Great karenpayneoregon.

Answer 4

Mounira Ben Ali 1

Ok good luck

Share via

Could not create excel instance.( System.Runtime.InteropServices.COMException (0x80080005))

4 answers

Your answer