Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Matheswaran Ravichandran (MatheswaranRavi)
P3Fusion
System Architect
P3Fusion
IN
MatheswaranRavi Member since 2019 37 posts
P3Fusion
Posted: Aug 1, 2019
Last activity: Sep 16, 2019
Posted: 1 Aug 2019 7:01 EDT
Last activity: 16 Sep 2019 23:50 EDT
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****

To see attachments, please log in.
Pega Platform
Dev/Designer Studio
Java and Activities

Posted: 5 years ago
Posted: 16 Sep 2019 23:50 EDT
Srinivas B Y (SrinivasB9086)
Optum

Optum
IN

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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice