Unable to export data using Export to Excel functionality
Unable to export report data using the out-of-the-box Export To Excel functionality on the Report Definition rule. An error screen displays and a Java exception occurs in the log.
This occurs post upgrading Pega 7.3.1 to Pega 8.3.1. The users were able to export large amount of data (50k rows and more) before the upgrade.
Exception in log
Section 'pzRDExportWrapper' execution error on page 'pegaInternalReportTempPage' of class 'Rule-Obj-Report-Definition'.
java.lang.IllegalStateException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook
Steps to Reproduce
- Create a report definition which retrieves a large number of rows (30-50k) with a column containing an autogenerated numeric control
- Export the result set to Excel using the out-of-the-box Export to Excel feature enabled on the report definition
A defect in Pegasystems’ code or rules. If a column is formatted with an autogenerated numeric control, a new cell style generates for every row during the Export to Excel process. Since, there is a limit on the amount of cell styles, an error generates when the number of rows in the file is greater than 64000.
0% found this useful