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***