Question

1
Replies
111
Views
Matheswaran1998 Member since 2019 23 posts
P3Fusion
Posted: 1 year ago
Last activity: 1 year 1 month ago
Closed

Populate pagelist porperty as a excel column header

Hello,

I have a pagelist in the clipboard and the property in the list are updated dynamically, i have to generate a excel using MSOPGenerateExcel method in activity to list the properties as header in row format

I have attached screenshot for refrence

thanks,

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Low-Code App Development Dev/Designer Studio Data Integration Java and Activities
Close popover
Moderation Team has archived post
Posted: 1 year ago

Hi,


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.


Thanks
Share this page LinkedIn
Copied!