Hello to all,
I have a problem with system.dataset.dataSetToExcel. I need to export big data from a table. In my vision application I have some table where I can see the data and I have create a button to export all the table. But the table with few data don’t have problem when I export the table with many data after a lug I get the error “java.lang.OutOfMemoryError: java.lang.OutOfMemoryError: Java heap space”.
I tried to export using dataSetToCSV the same data and it work very well and very fast but if is possible exporting to excel would be more convenient. Anyone have same problem o some ideas?
This i my code:
spreadsheet = system.dataset.toExcel(True, [ctbgrezzi.data])
filePath = system.file.saveFile(“grezzi.csv”)
#spreadsheet = system.dataset.toCSV(ctbgrezzi.data)
#filePath = system.file.saveFile(“grezzi.csv”,“csv”,“Comma separated values”)
if filePath != None:
Traceback (most recent call last):
File “event:mouseClicked”, line 19, in
java.lang.OutOfMemoryError: java.lang.OutOfMemoryError: Java heap space
caused by OutOfMemoryError: Java heap space
Ignition v8.0.16 (b2020082513)
Java: Azul Systems, Inc. 11.0.7