# Excel Output

**URL:** <https://forum.cloverdx.com/t/excel-output/1190>\
**Category:** CloverDX Platform\
**Created:** [March 19, 2013, 12:00am UTC](https://forum.cloverdx.com/t/excel-output/1190 "2013-03-19T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![praveen](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/praveen/32/137_2.png) [@praveen](https://forum.cloverdx.com/u/praveen)\
**Post date:** [March 19, 2013, 12:00am UTC](https://forum.cloverdx.com/t/excel-output/1190/1 "2013-03-19T00:00:00Z")

</div>

Hi

I have a graph that writes multiple tabs (around 8) into Excel. The output excel size is around 3mb. But I keep hitting JVM heap space issue when using spreadsheetwriter or XLSdatawriter. I was able to run this now by increase the jvm size from 256mb to 1gb. My question - Is there any better way to do this to use as minimum space as possible. 1gb sounds like a lot of memory to write into a 3mb excel file.

Below is the part of execution summary

INFO [WatchDog] - -----------------------\*\* Summary of Phases execution \*\*---------------------  
INFO [WatchDog] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)  
INFO [WatchDog] - 0 FINISHED\_OK 3 96958  
INFO [WatchDog] - 1 FINISHED\_OK 2 129966  
INFO [WatchDog] - 2 FINISHED\_OK 2 170021  
INFO [WatchDog] - 3 FINISHED\_OK 2 209959  
INFO [WatchDog] - 4 FINISHED\_OK 2 248970  
INFO [WatchDog] - 5 FINISHED\_OK 2 288984  
INFO [WatchDog] - 6 FINISHED\_OK 2 328735  
INFO [WatchDog] - 7 FINISHED\_OK 14 439756  
INFO [WatchDog] - 8 FINISHED\_OK 2 400166  
INFO [WatchDog] - 9 FINISHED\_OK 7 402445

500Mb seems to work now, but I am not convinced this would take so much space. Each node has an input that reads from datasource and writes into a tab.

Thanks,  
Praveen Boddu

---

<div class="post-metadata">

**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\
**Post date:** [March 20, 2013, 8:20am UTC](https://forum.cloverdx.com/t/excel-output/1190/2 "2013-03-20T08:20:56Z")

</div>

Hi Praveen,

XLSdatawriter handles excel files by DOM method which is adding huge overhead to data size. This explains high memory usage.

In commercial version of CloverETL since version 3.3 is available new component [http://doc.cloveretl.com/documentation/ … riter.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/spreadsheetwriter.html) which under some constraints is able to do streamed writing. Therefore uses minimum amount of memory.