Performance issue in downloading data using EXCEL.APPLICATION

[Former Member]

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.

[Former Member]

Hi Priyanka,

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

Thanks,

AD

[Former Member]

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.