Posted: 21 Feb 2017 10:51 EST Last activity: 16 Oct 2018 12:03 EDT
How to populate Pagelist Values into Excel sheet template
In reply to:
You can use OOTB activity MSOGenerateExcelFile. Call this activity keeping your pagelist (or data page ) as step page. It takes three parameters, 1. FSFileName - Name of the excel created, 2. TemplateRFB - Template name (format : "excel!TemplateName!xlsx") , 3. DownLoadFile - true/false. Prior to using this activity, create a template excel file and define the column header and property reference for column value. Create a binary file in PRPC and upload this excel. This template excel will have the details of the properties you want to send to the output excel and its name is required for the second parameter.
Let me know if you need any other details.
I have very similar scenario. Except there is another page list in the first page list. Is there a way to display the properties under 2nd page list into the excel sheet?