Question
CVS
US
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.Thanks
Sumit
Hi Sumit-
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?
If I give in the below format, it is not working:
{.Testpl().ExportAttributeVGP() input}
-Thank you so much in advance
Prathima
Original Thread for Reference: https://pdn.pega.com/community/product-support/question/how-populate-pagelist-values-excel-sheet-templateusing
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.Thanks
Sumit
Hi Sumit-
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?
If I give in the below format, it is not working:
{.Testpl().ExportAttributeVGP() input}
-Thank you so much in advance
Prathima
Original Thread for Reference: https://pdn.pega.com/community/product-support/question/how-populate-pagelist-values-excel-sheet-templateusing
***Moderator Edit: Vidyaranjan | Branched comment to create new thread & updated categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.