To use "exportExcel" function, there has tips: OutOfMemoryError?

Hi,
Table has lots of data.
When I want to export data with the function “system.dataset.exportExcel”, there was an error : java heap space.

Yes, that function constructs the entire spreadsheet in memory, then writes to disk. You will have to raise your client memory allowance.

1 Like

What Phil said. Also, we made a change in 8.0.15 that will decrease the amount of memory used if any cells have dates, so it might be worth your while to upgrade as well.