Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Excel/Opentext method via ActiveX in a service application
Hello,
We have a service application that acts as a scheduled report generator. It reads a schedule from a database and then runs various reports, emailing the results in PDF / EXCEL format. We use a CSV file of the report and export it to excel using the opentext method. Everything works perfectly with the exception of the Excel export. If we setup a report to only export to PDF, the report will run perfectly and multiple runs of the report will take approximately the same amount of time. If we setup a report to use the Excel export, the first run of the report could take 20 seconds, then the second run, 1 minutes, the next run 5 minutes and so on until the service slows down to a crawl. This is fixed as soon as the service is restarted. Is anyone aware of any issue with using calling Excel / Opentext method using activeX through a service application? Any idea what could be causing this slowdown? -- Regards, Salar Madadi - Latest Developments Inc. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Excel/Opentext method via ActiveX in a service application
Excel is not designed to be run like this, aso you need to be very careful
not to end up with any unreleased references to the application. From your description it sounds as though this is what's happening. Post some code if you need more suggestions. Tim -- Tim Williams Palo Alto, CA "Salar Madadi" wrote in message ... Hello, We have a service application that acts as a scheduled report generator. It reads a schedule from a database and then runs various reports, emailing the results in PDF / EXCEL format. We use a CSV file of the report and export it to excel using the opentext method. Everything works perfectly with the exception of the Excel export. If we setup a report to only export to PDF, the report will run perfectly and multiple runs of the report will take approximately the same amount of time. If we setup a report to use the Excel export, the first run of the report could take 20 seconds, then the second run, 1 minutes, the next run 5 minutes and so on until the service slows down to a crawl. This is fixed as soon as the service is restarted. Is anyone aware of any issue with using calling Excel / Opentext method using activeX through a service application? Any idea what could be causing this slowdown? -- Regards, Salar Madadi - Latest Developments Inc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel calling WCF service | Excel Discussion (Misc queries) | |||
migration issue - OpenText method crashes Excel. | Excel Programming | |||
Error calling Web Service from Excel Application | Excel Programming | |||
opentext method of excel workbook object | Excel Programming | |||
calling web service from excel 2000 | Excel Programming |