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:
system.net.openURL(“file://”+filePath)
"
Any help resolving this error would be appreciative 