Question

5
Replies
4025
Views
Vamsi.Thatavarthi Member since 2014 35 posts
Hcl Technologies
Posted: February 8, 2018
Last activity: February 9, 2018
Closed
Solved

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.

Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn