Support Article
Exporting to Excel fails with maximum cell styles exceeded error
SA-37853
Summary
The user is having trouble exporting a large decision table to Excel fails with the below error in the logs.
Error Messages
The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook
Steps to Reproduce
- Try to export a large (multiple thousand rows) Decision Table to Excel.
Root Cause
A defect in Pegasystems’ code or rules. The Pega engine is creating too many cell styles in the Excel file and running in to the Excel limit.
Resolution
Apply HFix-34370.
Published May 16, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.