locked
Excel.dll RRS feed

  • 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

    Tuesday, January 27, 2009 7:09 PM

Answers

  • User-504499122 posted

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 27, 2009 11:08 PM
  • 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!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 28, 2009 3:20 PM
  • 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/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 28, 2009 4:12 PM

All replies

  • User-504499122 posted

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

    Tuesday, January 27, 2009 9:08 PM
  • 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

    Tuesday, January 27, 2009 9:54 PM
  • 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

     

     

     

    Tuesday, January 27, 2009 10:36 PM
  • User-504499122 posted

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 27, 2009 11:08 PM
  • 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!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 28, 2009 3:20 PM
  • 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/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 28, 2009 4:12 PM