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

 Shubham Kamble (Shubham Kamble)
Eviden

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

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***
To see attachments, please log in.
Pega Platform 8.4.3
Case Management
Data Integration
Consumer Services
Senior System Architect

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