Posted: 19 Jun 2020 8:29 EDT Last activity: 17 Jul 2020 0:10 EDT
pxGenerateExcelFile taking lot of time to download
im using pxGenerateExcelFile to download data in excel sheet. records are around 1500. pxGenerateExcelFileactivity is taking around 2 to 3 minutes to generate excel file while MSOGenerateExcelFile downloading it in a seconds. Attached is the configuration of both. MSOGenerateExcelFile is a depreceated activity so i had to use pxGenerateExcelFile. Can anyone help me on how to improve the performance. Thanks in advance.
***Edited by Moderator: Pallavi to update platform capability tags***
Usually when we use pxGenerateExcelFile activity for excel template , it wont supports multiple rows same as MSOGenerateExcelFile. Even though if we provide some filter condition in the excel template , the data wont be filtered based upon it. It displays the data in the excel but data wont be filtered.