Calling Excel/Opentext method via ActiveX in a service application

[Salar Madadi]

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.

 

[Tim Williams]

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