Question
Synechron
US
Last activity: 7 Sep 2016 2:13 EDT
Export to excel in batch
Hi Team,
I have huge amount of data which is being sourced from Store Procedure. Trying to print the these records consumes the memory and server goes down. I have a idea to break the Page list that have been built from SP into multipe Page-lists with dynamic name and print it into excel sheet. Please suggest if we have any OOTB feature to achieve the same.
Regards,
Satish
***Updated by Moderator: Marissa to update categories***
Pegasystems Inc.
IN
Hi Satish,
For excel generation you can use the activity MSOGenerateExcelFile .Data pages could be used to store the data.
Synechron
US
Hi Sahu,
I am using the activity "MSOGenerateExcelFile" only. The issue here is when I am trying to print large volume of data, it goes timeout. That's the reason I came with a idea to split the available data into small volume and print it in a batch one by one so that I should not reach threshold time and all volume of data can be printed easily. Please suggest if you have any other idea or how to implement the same.
Regards,
Satish
Synechron
US
Hi Sahu,
I am using the activity "MSOGenerateExcelFile" only. The issue here is when I am trying to print large volume of data, it goes timeout. That's the reason I came with a idea to split the available data into small volume and print it in a batch one by one so that I should not reach threshold time and all volume of data can be printed easily. Please suggest if you have any other idea or how to implement the same.
Regards,
Satish