Y
y2ksmith
Hi,
I've got an app that can either run with a GUI or in a console. The
app retrieves a report from Reporting Services and then merges it with
a Excel template. The code that processes the reports it's exactly
the same, whether you run with GUI or without. The problem is the
Excel automation code runs about 10 times slower in console mode. For
instance, the Workbook.SaveAs() method takes about a minute in console
mode and a few seconds in GUI mode. Again, the only difference
between the two modes is one shows a form the other displays a
console.
Any ideas would be much appreciated.
Thanks
I've got an app that can either run with a GUI or in a console. The
app retrieves a report from Reporting Services and then merges it with
a Excel template. The code that processes the reports it's exactly
the same, whether you run with GUI or without. The problem is the
Excel automation code runs about 10 times slower in console mode. For
instance, the Workbook.SaveAs() method takes about a minute in console
mode and a few seconds in GUI mode. Again, the only difference
between the two modes is one shows a form the other displays a
console.
Any ideas would be much appreciated.
Thanks