Question
ING Bank
NL
Last activity: 9 Feb 2018 2:47 EST
How can I export Page list contents to Excel
Hi,
I have a page list which stores some custom warning details. I need to display a button clicking on which entire page list content should be exported to excel. Is there an OOTB activity to get this done.
I have tried using Activity MSOGenerateExcelFile by creating a xslm template with the appropriate columns (not sure if I'm doing anything incorrect here), created a binary file rule, uploaded it and checked Download checkbox. But nothing is getting downloaded.
Followed this doc https://pdn.pega.com/system/files/Sending%20data%20from%20pega%20to%20excel%20sheet.docx, But I'm confused how xlsx file is uploaded into Binary file rule created for extension xlsm. (step 3 & 4).
Also, I've tried exportToExcel function and passed my pagelist in pageName Parameter. But didn't help.
Thanks,
Vamsi.
Accepted Solution
ING Bank
NL
I have initially configured the button to "Run activity" upon click. It didn't work. Activity was getting invoked but download was not happening. Then I used "Refresh section" and in that I've used the same activity. Now, excel file is getting downloaded.
Thanks,
Vamsi.
Pegasystems Inc.
US
Hi Vamsi,
You can have a look into the use case which is attached over here, that might help you.
Regards
Mahesh
ING Bank
NL
Surprisingly, when I manually run the wrapper activity (which invokes MSOGenerateExcelFile activity) on the case thread, export and download is happening properly. Not sure why download is not happening upon clicking a button (embedded into table header) which runs the same activity upon click event.
Any thoughts?
Pegasystems Inc.
US
Can you share the configuration screenshots so that i can have a look and let you know if i find anything wrong.
Accepted Solution
ING Bank
NL
I have initially configured the button to "Run activity" upon click. It didn't work. Activity was getting invoked but download was not happening. Then I used "Refresh section" and in that I've used the same activity. Now, excel file is getting downloaded.
Thanks,
Vamsi.
Pegasystems Inc.
US
Actually if you use Open URL in Window properly then it should download the excel file properly, for example which i tried in my use case. You should be used Use Page option properly. Anyhow good to see that your issue got resolved after refresh of the section.