Question

4
Replies
1937
Views
prathimak7858 Member since 2017 1 post
CVS
Posted: 3 years ago
Last activity: 2 years 2 months ago
Closed

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

***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.

Data Integration User Interface
Moderation Team has archived post
Share this page LinkedIn