topic Performance issue in downloading data using EXCEL.APPLICATION in Application Development and Automation Discussions

Performance issue in downloading data using EXCEL.APPLICATION

Former Member — Mon, 23 Mar 2009 13:23:35 GMT

hi,

i am downloading around 1000 records to an excel sheet using EXCEL.APPLICATION.

however it is taking a long time to download.is there any parameter which could be checked

or used in EXCEL.APPLICATION which can increase the performance.

i am using EXCEL.APPLICATION becoz i have to integrate 2-3 excel sheets into one excel workbook.

Is there any other way which can be used for this and there by have a good performance tunning.

Re: Performance issue in downloading data using EXCEL.APPLICATION

Former Member — Tue, 28 Apr 2009 09:26:39 GMT

Hi Priyanka,

Try download using FM GUI_DOWNLOAD.I think it will help.

Thanks,

Re: Performance issue in downloading data using EXCEL.APPLICATION

Former Member — Wed, 29 Apr 2009 07:02:42 GMT

Hi,

Using OLE objects many a times pose a performance probelm. If a simple excel can do your task then use GUI_DOWNLOAD and give the file name as <xxx>.xls

It will download the whole data in the form of an internal table in a single step.