Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |