Question
Saltech Consulting
GB
Last activity: 3 Feb 2022 5:18 EST
Report Browser Export to Excel Modify Template
Is it possible to modify the format or template of the excel file generated by the report browser?
I can see as detailed here
https://collaborate.pega.com/question/export-pzrdexportwrapper-change-worksheet-name
The pzRDExportWrapper is called
Which then calls this HTMLStream and after exits.
Running the tracer we can see other data transforms being run in the background by "com.pega.pegarules.priv.desktop.reporting.export.ReportExportHandler.doExport(pega.getPrimaryPage(), pega);" however these are all final 'pz' rules. Going through these its also not clear how the excel is being generated (its there a binary template?)
Is it possible to modify the format or template of the excel file generated by the report browser?
I can see as detailed here
https://collaborate.pega.com/question/export-pzrdexportwrapper-change-worksheet-name
The pzRDExportWrapper is called
Which then calls this HTMLStream and after exits.
Running the tracer we can see other data transforms being run in the background by "com.pega.pegarules.priv.desktop.reporting.export.ReportExportHandler.doExport(pega.getPrimaryPage(), pega);" however these are all final 'pz' rules. Going through these its also not clear how the excel is being generated (its there a binary template?)
So in short is it possible to modify the excel output when triggered from the report browser? The only available config I can find is pyEnableExcelInfoWorksheet but this is not the change I need.