Hello,
I am getting serious problem while using Excel library in to asp.net application.
I am excel document from asp.net application.
i have added .net interop 12.0 excel library reference into application.
on local everything is working fine. but when i publish the application on server(server 2003) getting following problem.
"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005."
- added network service
- added aspnet user
I have done all dcomcnfg setting as per suggested by google docs after serched the error in google.
but still i am getting above error. trying to solve this problem from last 3-4 days. but not found any correct solution.
following is my code.
app = new Excel.Application();
app.Visible = false;
workbook = app.Workbooks.Add(1);
worksheet = (Excel.Worksheet)workbook.Sheets[1];
on server we have MS Office 2007.
IIS 6.0
Please help me.
Software Developer