Support Article
Error on exporting a report definition to Excel
Summary
Error on exporting a report definition with a huge number of rows to Excel.
Error Messages
906 [ttp-nio-8200-exec-18] [TABTHREAD2] [] [CRM:127.0.0.1] (e_Obj_Report_Definition.Stream) ERROR Server |127.0.0.1 U083205 - 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
Export a report definition with a huge number of rows to Excel.
Root Cause
Auto generated format creates cell style for each row.
Resolution
This issue is reported as a bug to be remediated in Pega 8.3.2.
Alternatively, perform the following local-change:
Remove the auto generated formats for numerical fields.
Published January 28, 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.