How to Export Data to Excel with Multiple Sheets in Pega using pxGenerateExcelFile

[Kamil_Janeczek]

Thanks for sharing. Couple of related links (Constellation):

Import Excel data to case (and show them in Constellation UI)

This knowledge sharing article shows step-by-step configurations of how to upload an Excel file, parse the Excel data, and display them in a table using Constellation UI. Pega platform version used: 24.2.2 Configurations Step 1 - Create a data model. We created an Employee data object and the related fields. [10.png] Step 2 - Create an Excel template file (.xlsx) and the corresponding Binary File rule. Notice the .pxResults() notation to import more than one record and the keyword “input”…

Streamlining Data Entry in Pega Constellation Applications with pxParseExcel

In Pega Constellation and Traditional UI applications, the pxParseExcel feature provides an efficient solution, enabling users to import Excel spreadsheets and automatically convert the data into Embedded Data. This article demonstrates how to leverage pxParseExcel, complete with step-by-step instructions and screenshots, to simplify the process and enhance user experience. Step-by-Step Guide Step 1: Prepare and Import the Excel Template Create an Excel file containing all the required Custom…