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.