Question

1
Replies
21
Views
Shubham Kamble (Shubham Kamble)
Areteans

Areteans
IN
Shubham Kamble Member since 2017 2 posts
Areteans
Posted: June 2, 2021
Last activity: June 17, 2021
Posted: 2 Jun 2021 4:39 EDT
Last activity: 17 Jun 2021 1:50 EDT

how to export data to multiple excel sheets using pxGenerateExcelFile pega

I am having a requirement to export data into multiple sheets. For now I am using MSOGenerateExcelFile but, this activity has been depricated by Pega. I am not able to achieve the same with pxGenerateExcelFile activity.

while using MSOGenerateExcelFile i am creating new temporary pagelist and in the pagelist I am using pySheets Page Group property to hold data for different sheets

Can anyone let me know how can I use pxGenerateExcelFile activity to export data into multiple sheets.

I am attaching binary file, exported file to have the more idea.

***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Platform 8.4.3 Case Management Data Integration Consumer Services Senior System Architect