locked
Com Component access denied RRS feed

  • Question

  • User-315289288 posted

    Hi, 

    i am facing a problem in connecting my ASP.net application to MS Excel. I am trying to write some data to an excel file and then the file is downloaded to the user.

    I made this using namespace -'using Excel'[with INTROP.EXCEL.DLL].

    Its working fine my PC. When i publish the site in Server in which MS office is not installed, i was unable to find the INTROP.EXCEL.DLL in COM. So manually i added the dll from my system to server and used 'using Excel' namespace and its classes like Excel.Application,Workbook etc...

    But when i build the application.I am not facing any error.But when i run the applcation , i got an errr -"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."

    So please help me on that??? Suggest me is there any other way to use the dll?

    Friday, February 27, 2009 5:34 AM

Answers

  • User-315289288 posted

    Thanks for the response..But it doesn't suits me........

     In my server MS-Office is not installed.....So no DCOM exists for excel application...

    I need to format cells in serverside in which NO MS-Office is installed.SO please suggest me if any thrid party component exists to automate excel in server-side....

    Thanks for the response...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, March 10, 2009 1:40 PM

All replies

  • User-1659704165 posted

    Hi,

    Just Go Through Link

    http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

     Hope it helps,

    Friday, February 27, 2009 8:07 AM
  • User-315289288 posted

    Thanks for the response..But it doesn't suits me........

     In my server MS-Office is not installed.....So no DCOM exists for excel application...

    I need to format cells in serverside in which NO MS-Office is installed.SO please suggest me if any thrid party component exists to automate excel in server-side....

    Thanks for the response...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, March 10, 2009 1:40 PM
  • User-319574463 posted

     Part of Microsoft Office 2007 is a component for running Excel on the server.

    Wednesday, March 11, 2009 8:02 AM