COM error when accessing Excel thru InfoPath forms services

[ugk]

Hi,
I am using Microsoft InterOp Excel (12.0.0.0) for Office 2007 in InfoPath
forms services (web enabled) and when creating an instance (see secong
statement) of the Excel application (Application excel = null; excel = new
Application()), getting the following error: "Retrieving the COM class
factory for component with CLSID {00024500-0000-0000-C000-000000000046}
failed due to the following error: 80070005.."..
The InfoPath application is running in domain. Tried with setting Dcomcnfg
giving access permissions with different users(Users, Domain Users, w3wp.exe
user account under which the process runs, and even ROOT superuser of domain
in Identity foe dcomcnfg), but could not resolve the issue. Appreciate if any
could help in resolving this error.
Thanks..

 

[David Dean]

A couple of things:
- First of all, running automation of the Excel client application on the
server is not a best practice. You will likely run into all sorts of
concurrency and/or performance issues, as Excel was designed as a desktop app
and Microsoft doesn't support it for server-based usage. You should look into
the use of Excel Services on the SharePoint 2007 Enterprise platform if you
need to do server-side processing of spreadsheets.
- That said, you might consider encapsulating your Excel automation code in
a web service and then execute the web service from an InfoPath data
connection. This will isolate the Excel code from the InfoPath code and allow
you to test it independently.