Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Unable to export data using Export to Excel functionality

SA-105355

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

  1. Create a report definition which retrieves a large number of rows (30-50k) with a column containing an autogenerated numeric control
  2. 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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community 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.

Close Deprecation Notice
Contact us