Hello!
I have a problem. I need to generate a excel sheet in a web exportation agent from a application.
The Excel is already installed at the server and everytime I call this agent by a menu on the ie I got this error. Then I see the line in the code and I realize that is when I use the API “CreateObject(“Excel.Application”)”.
Could you help me to solve this puzzle?
Thanks in advance.
Subject: Excel
On the agent use :Print |Content-Type:application/vnd.ms-excel; charset=utf-8|
Then print a table with TR and TD’s.
This will open the excel on the client.
Regards
Tamir Ben Shoshan
SharePoint & Lotus plugins & Notes CAPI
Subject: Doesn’t work
I tried do this and the error still apears. Any other suggestion?
Subject: It does work.
I been using that technique myself. Forget about trying to automate Excel on the server, that is very unreliable (according to Stephan Wissel, we had a discussion about this at Lotusphere 3 years ago).
Instead, build a HTML table using Print statements, and use the content type Tamir posted previously to get the browser to pass it to the locally installed Excel.
Subject: Excel.Application.9
Might want to try “Excel.Application.9”, some version of excel installed the object with a different name instead of “Excel.Application”.
Though the option that Tamir and Karl mention might be a better idea.
Another way is to include the a java library of creating excel files (into your nsf) and write a java agent to create the excel file. [Remove the need to have excel installed on the server]