Support Article
Export to Excel fails with Maximum cell styles exceeded error
SA-91084
Summary
Error occurs when exporting large data to Excel using the pxGenerateFile activity. However, this works when using the MSOGenerateExcelFile activity.
Error Messages
The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook
Steps to Reproduce
Export large data to Excel using the pxGenerateFile activity.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
This feature is implemented in Pega Platform 8.2.5.
Published December 9, 2019 - 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.