Question

4
Replies
2033
Views
Close popover
prathima kothagundla (prathimak7858)
CVS

CVS
US
prathimak7858 Member since 2017 1 post
CVS
Posted: February 21, 2017
Last activity: October 16, 2018
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 Experience
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.