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

**URL:** <https://forum.inductiveautomation.com/t/to-use-exportexcel-function-there-has-tips-outofmemoryerror/37578>\
**Category:** General Discussion\
**Created:** [August 11, 2020, 3:57am UTC](https://forum.inductiveautomation.com/t/to-use-exportexcel-function-there-has-tips-outofmemoryerror/37578 "2020-08-11T03:57:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![616958939](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/616958939/32/16900_2.png) [@616958939](https://forum.inductiveautomation.com/u/616958939)\
**Post date:** [August 11, 2020, 3:57am UTC](https://forum.inductiveautomation.com/t/to-use-exportexcel-function-there-has-tips-outofmemoryerror/37578/1 "2020-08-11T03:57:37Z")

</div>

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.

 ![heap](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/1/3118451a2afd095113ccf7faa9660188ceafa823.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 11, 2020, 12:03pm UTC](https://forum.inductiveautomation.com/t/to-use-exportexcel-function-there-has-tips-outofmemoryerror/37578/2 "2020-08-11T12:03:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [August 11, 2020, 2:27pm UTC](https://forum.inductiveautomation.com/t/to-use-exportexcel-function-there-has-tips-outofmemoryerror/37578/3 "2020-08-11T14:27:35Z")

</div>

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.