Com Component access denied

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?

Answer 1

User-1659704165 posted

Hi,

Just Go Through Link

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

 Hope it helps,

Answer 2

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...

Answer 3

User-319574463 posted

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