Retrieving the COM class factory for component with clsid...failed due to the following error: 80040154

Question

1.00/5 (1 vote)

See more:

string filepath = Server.MapPath(@"~/MSME_Admin/CMA_Data/Book1.xls");
// To Open existing Excel From Folder
Application ExcelObj = new Excel.Application();
Workbook WBook = ExcelObj.Workbooks.Add(filepath);
Worksheet WSheet = (Excel.Worksheet)WBook.Sheets.get_Item(1);
Range range = null;

What I have tried:

i am getting this error, why are coming this error i din't understand. Please Give some solution.

Posted 13-Jun-18 18:27pm

Pr@mod

Updated 14-Jun-18 5:42am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2018-06-14T05:44:00

Error 80040154 means Office is not installed on the server.

You should also read the following Microsoft knowledgebase article:

Considerations for server-side Automation of Office[^]
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

Since you're trying to read an old-style Excel document (.xls), you'll need to use NPOI:
GitHub - tonyqus/npoi: a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.[^]

For new-style documents (.xlsx), there are several other alternatives:

None of these use Interop, and none of them require you to install and license Office on your server.

F-ES Sitecore · Answer 2 · 2018-06-13T22:40:00

Solution 2

Automating Excel is not supported under asp.net, you'll need to use some other way to manipulate your Excel files such as EPPlus, XML SDK, Aspose, Excel ODBC Driver etc.

Posted 13-Jun-18 22:40pm

F-ES Sitecore

Updated 13-Jun-18 22:41pm

v2

Jochen Arndt · Answer 3 · 2018-06-13T21:31:00

Solution 1

Error 0x80040154 is "Class not registered".

To know which class is not registered, we would have to know the CLSID from your error message.

Because it occurs when trying to use Excel Interop, I guess that Excel is not (properly) installed on your system. Then the solution is to execute the Excel / Office setup to (re-)install / repair.

Posted 13-Jun-18 21:31pm

Jochen Arndt

Comments

Dave Kreskowiak 14-Jun-18 12:23pm

There's a much bigger problem than just installing Office. Office cannot be used via Interop in a non-user-interactive session, i.e. Windows Services and especially not ASP.NET applications.