Excel Generation in C#

0
votes

I have Error for Excel Generation.

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

It works fine on my local machine.

3
c#asp.netexcel
Did you check Resolving HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG) – Shubh

3 Answers

0
votes

The error "The Class not registered" is because the COM object is missing on the computer.
The PIA just are the assemblies that allow you to call the Office COM object model from .NET.
You need to install the Office on your server to fix.

2
votes

It seems that you use excel for excel file generation. And may be you have no excel on your server? I recommend you to pay attention to OpenXML sdk to generate office 2007+ documents. It don't need excel on computer to generate excel file.

0
votes

We had a lot of problems with Excel and Interop and one day found EPPlus. Unlike Excel Interop it works standalone and has a pretty decent API to read and write Excel files.

I know it is not the answer to your question, but probably the solution to your problem!