The maximum number of Cell Styles was exceeded

We converted Ignition from 7.9.12 to 8.0.11. In our project, we display a dataset that returns data based on date range. There is a script that is triggered based on mouseReleased that exports the dataset to a excel spreadsheet using the system.dataset.exportExcel.

This function works if we are within a 24hr date range. But if we select a date range longer than 48 hours (typically exporting about 2 weeks of data) we get the following error:

Traceback (most recent call last):
File “event:mouseReleased”, line 7, in
java.lang.IllegalStateException: java.lang.IllegalStateException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook

caused by IllegalStateException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook

Ignition v8.0.11 (b2020041411)
Java: Azul Systems, Inc. 11.0.6

This script worked perfectly in 7.9.12 no issues. Here is the script that is used to export:
table = event.source.parent.getComponent(“Line Table”).data
table2 = event.source.parent.getComponent(“Unit Table”).data
table3 = event.source.parent.getComponent(“Raw Tank Table 1”).data
table4 = event.source.parent.getComponent(“Pasteurized Tank Table 1”).data
table5 = event.source.parent.getComponent(“MReceiving”).data
table6 = event.source.parent.getComponent(“CReceiving”).data
filePath = system.dataset.exportExcel(“Hourly Info by Minute.xls”, 1, [table, table2, table3, table4, table5, table6])
if filePath != None:“file://”+filePath)
Any help resolving this error would be appreciative :slightly_smiling_face:

The code backing Excel exports changed in 8.0, and we’re still shaking out a few bugs - this is one of the only known remaining ones. It was reported pretty recently, but has a high priority, so will likely be fixed within the next few 8.0.x releases. Unfortunately, there’s no workaround at present.

Has this issue been fixed? I’m on 8.0.11 the same as the OP but I don’t want to update if this still exists.
Sorry for reviving an old thread but it’s the only one that comes up in a search.

Yes, this was fixed in 8.0.15:

1 Like