Question

1
Replies
39
Views
Soundane Member since 2019 10 posts
Capgemini
Posted: October 15, 2020
Last activity: October 23, 2020

Export with pzRDExportWrapper: Change worksheet name

In Activity pzRDExportWrapper 1st step we have HTML stream pzRDExportWrapper which contains code as:

com.pega.pegarules.priv.desktop.reporting.export.ReportExportHandler.doExport(pega.getPrimaryPage(), pega);

and as I traced it: 3 rules are triggered because of this above doExport function

pzUpgradeOnOpen

pzResolveCopyFilters

pxRetrieveReportData

I have two questions here:

Where can I see this doExport function? or can anyone explain its role here. Like how it is generating the excel file and what input it is taking.

I have requirement where the worksheet name in excel needs to be changed. Currently we are getting data and info two sheets. one contains data and other metadata. How can I change the worksheet name, Is there a way using pzRDExportWrapper specifically? Is there a binary file which is being used internally which I can alter?

related links for worksheets:

https://community.pega.com/knowledgebase/articles/reporting/85/managing-creation-info-sheet-excel-output

https://community1.pega.com/sites/pdn.pega.com/files/help_v731/reporting/rpt-disabling-excel-info-sheet-tsk.htm

 

***Edited by Moderator: Pooja to update type to product, add platform capability tag***
Pega Platform 8.4 Reporting
Share this page LinkedIn