Include a pega section inside excel sheet when exported
How to add a static content of a section inside the excel spreadsheet when it is getting exported?
Capgemini
FR
Hello,
What do you mean by static content of a section
What would be that content for instance?
Publicis Sapient
IN
Hi @RajaP4318
I think Pega doesn’t support embedding sections directly in Excel, but you could try moving the static content into properties and include them in the export. Alternatively, use an Excel template with pxGenerateExcelFile to manually add the content. Not exact, but might help replicate the section.
HCA Healthcare
US
To include a Pega section’s static content (like headings or labels) in an Excel export, first map the static content (such as a heading or description) to a property on the clipboard, like .HeaderText. Then use a predefined Excel template where the first row has a placeholder like <<HeaderText>>. You can then use the MSOGenerateExcelFile activity to export the data using this template. Make sure your actual data is in a page list like .pxResults, and your template includes placeholders like <<.pxResults().CaseID>> in the rows below the header. When the export runs, the header from the section and the data will both appear in the Excel file. This method ensures your static section content is also visible in the final Excel.