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?
How to add a static content of a section inside the excel spreadsheet when it is getting exported?
Hello,
What do you mean by static content of a section
What would be that content for instance?
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.
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.
Question Solved
Question
Question Solved
Question Solved
Question
Question
Question Solved
Question Solved
Question
Question
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.