Excel interop problem. Access is denied.

[Alex D.]

Hi .I cant seem to find a way to authorize asp.net user to create an Excel
application using this: Microsoft.Office.Interop.Excel.ApplicationClass
excel = new Microsoft.Office.Interop.Excel.ApplicationClass();

I keep getting this error:
Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed with HRESULT:
0x80070005(Access is denied. (Exception from HRESULT: 0x80070005
(E_ACCESSDENIED))).
I already assigned permissions to asp.net user in Control Panel->Component
Services-> DCOM Config->Microsoft Excel Application, but I am still unable
to create the Excel application.

(Windows XP Pro, Visual Studio.NET 2 Beta 2, Office 2003 Pro)

Please help!

[Steve C. Orr [MVP, MCSD]]

Microsoft (and I) recommend not using COM Interop with Microsoft Office
products from an ASP.NET web page. Excel was not designed to be used in
this way. If you're determined to do it anyway, these articles gives you
the ins and outs along with some better alternatives:

http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx

And here's a good 3rd party component you could use:
http://www.aspose.com/Products/Aspose.Excel

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Alex D." <al********@hotmail.com> wrote in message
news:Os**************@TK2MSFTNGP12.phx.gbl...

Hi .I cant seem to find a way to authorize asp.net user to create an Excel
application using this: Microsoft.Office.Interop.Excel.ApplicationClass
excel = new Microsoft.Office.Interop.Excel.ApplicationClass();

I keep getting this error:
Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed with HRESULT:
0x80070005(Access is denied. (Exception from HRESULT: 0x80070005
(E_ACCESSDENIED))).
I already assigned permissions to asp.net user in Control Panel->Component
Services-> DCOM Config->Microsoft Excel Application, but I am still unable
to create the Excel application.

(Windows XP Pro, Visual Studio.NET 2 Beta 2, Office 2003 Pro)

Please help!

[Alex D.]

Problem is that at the beginning I used the lightweight OWC (Office Web
Components) but for some reason the calculations were wrong!! I just
populated some textboxes with the original content in the sheet cells and
the contents where different, even without changing anything.
Is there any bug in OWC, or am I missing something??

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:Oq**************@TK2MSFTNGP12.phx.gbl...

Microsoft (and I) recommend not using COM Interop with Microsoft Office
products from an ASP.NET web page. Excel was not designed to be used in
this way. If you're determined to do it anyway, these articles gives you
the ins and outs along with some better alternatives:

http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx

And here's a good 3rd party component you could use:
http://www.aspose.com/Products/Aspose.Excel

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Alex D." <al********@hotmail.com> wrote in message
news:Os**************@TK2MSFTNGP12.phx.gbl...

Hi .I cant seem to find a way to authorize asp.net user to create an
Excel application using this:
Microsoft.Office.Interop.Excel.ApplicationClass excel = new
Microsoft.Office.Interop.Excel.ApplicationClass();

I keep getting this error:
Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed with HRESULT:
0x80070005(Access is denied. (Exception from HRESULT: 0x80070005
(E_ACCESSDENIED))).
I already assigned permissions to asp.net user in Control
Panel->Component Services-> DCOM Config->Microsoft Excel Application, but
I am still unable to create the Excel application.

(Windows XP Pro, Visual Studio.NET 2 Beta 2, Office 2003 Pro)

Please help!