Support Article
Unable to export data using Export to Excel functionality
Summary
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.
Error Messages
Screen error
FAIL
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
Root Cause
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.
Resolution
Apply HFix-61238.
Published June 3, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.