Excel.dll

Question

User-714036019 posted

Hi, 

 

I wrote an application and used the Microsoft.Office.Interop.Excel.dll in the reference. However, when I put it in the server, it can't work.

 

Do I need to install the Microsoft Office in the Server? if no, what to do in the server to make the application?

 

 

Thanks,

workhard

Answer 1

User-504499122 posted

 You need to install the Office Interop libraries on the server. Make sure you install the right version of the libraries

Answer 2

User-714036019 posted

 Hi,

Yes, I did install the Microsoft Interop PIA into the Server. However, I got a error when run the application

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

Answer 3

User-504499122 posted

 http://www.technoblogy.net/post/Retrieving-the-COM-class-factory-for-component-with-CLSID-7b00024500-0000-0000-C000-0000000000467d-failed-due-to-the-following-error-80040154.aspx

Answer 4

User-714036019 posted

 Hi,

 

I followed the step. However, I could not find Microsoft Excel Application in the DCOM fig. 

 

 I did install the PIA (Primary Interop Assemblies) in the server. I could find them in the .NEt configuration -> Assembly Cache

 

 

 

Answer 5

User-504499122 posted

 I guess you would have to install excel to get it in the dcom config.. I am not 100% sure

Answer 6

User-714036019 posted

Hi,

 

I guess that's the only way to make the excel work. How great it is? Microsoft encourage you to use the fancy toys. Buts, they did not tell you the hidden cost. I did not have another Microsoft Office license for my server.

 

I think I need to use another method!

Answer 7

User-504499122 posted

 Yah. I think it seems like it..

I dont want to defend microsoft.. But there is another thread with similar problem.. And a guy from VSTO says the following, which makes lot of sense

The interop assemblies are just managed wrappers around COM interfaces.  They don't provide any implementation; they are just pass-throughs to the COM server itself--which in this case is Outlook.  In order for your code to run, Outlook 2003 or greater must be installed on the machine.

http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/a10c3c13-4c92-4584-97e2-43d1b29b5c4f/