asp.net and excel.application in interop

[Neo]

Hello All,

I would like to ask has anybody successfully used excel interop code
in asp.net?

I am getting following error.

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following
error: 80040154.

Error is given at the point where excel.application object is created.

I tried giving permission in DCOM but no luck.

Any help will be appreciated.

-Thanks
Pravin

 

[Mark Rae]

Any help will be appreciated.

This is one of the many errors that you are likely to encounter when trying
to automate Office apps server-side.

It simply isn't designed to be used like this - Microsoft themselves
strongly advise against it, and won't actually support any solution which
uses it:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

What are you actually trying to do...?

 

[scott]

DCOM config is the way to go, as you knew, but perhaps you didn't get
it set right: http://www.devcity.net/Articles/239/2/article.aspx

Alternatively you have to allow the ASP.NET process to run under a
user context that already has permission to do so...

--scott

 

[Neo]

I changed that setting already still it's giving problem.

 

[Neo]

I am trying to read user uploaded excel file on server in asp.net.

 

[Mark Rae]

I changed that setting already still it's giving problem.

Ignore the previous post. This will almost certainly not work - it's simply
not designed to work like this...

 

[Mark Rae]

I am trying to read user uploaded excel file on server in asp.net.

http://www.google.co.uk/search?sour...s=GGLG,GGLG:2006-28,GGLG:en&q="ADO.NET"+Excel

http://www.aspose.com/Products/Aspose.Cells/Default.aspx

 

[Neo]

http://www.google.co.uk/search?sourceid=navclient&ie=UTF-8&rls=GGLG,G...

http://www.aspose.com/Products/Aspose.Cells/Default.aspx

ADO.net is not of any help since it has problem of reading cell data
more than 255 char.

 

[Mark Rae]

ADO.net is not of any help since it has problem of reading cell data
more than 255 char.

Well-documented issue - easily fixed:
http://support.microsoft.com/kb/189897/EN-US/