EXCEL AUTOMATION IN .NET ( COM Error )

Question

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154.

i don't have ms-office in my system. I added the reference 'Microsoft.Office.Interop.Excel.dll' in my .net project(C# code behind). i get the above error FROM the BELOW line

Application excel = new Application();

when i have ms-office installed it works fine. i should work it out without installing ms-office. only by adding dll. help needed. Thanks in adv.

Andreas Paulsson · Accepted Answer · 2010-09-23 10:24:53Z

4

This is the problem: "i should work it out without installing ms-office"

You cannot start Excel if not Excel is not installed (duh). What are you trying to do?

answered Sep 23, 2010 at 10:24

Andreas Paulsson

7,8333 gold badges27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andreas Paulsson Over a year ago

The dll is only an interop assembly that works as a proxy between Excel and .NET. It does not include excel itself. Use Open XML SDK to read or write Excel (xlsx) files without having Excel installed.

Remy · Accepted Answer · 2010-09-23 10:27:52Z

1

Assuming you want to create or edit Excel Files, I recommend using the new Open XML SDK from Microsoft. Works better and is easier than Excel Interop.

http://blogs.msdn.com/b/excel/archive/2008/11/25/using-the-open-xml-sdk-to-work-with-excel-files.aspx

answered Sep 23, 2010 at 10:27

Remy

12.8k14 gold badges66 silver badges106 bronze badges

Collectives™ on Stack Overflow

EXCEL AUTOMATION IN .NET ( COM Error )

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related