poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook
Date Tue, 12 Dec 2017 10:21:54 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #12 from Thamodharan <thamodharan247@gmail.com> ---
(In reply to Yegor Kozlov from comment #11)
> try to construct SXSSFWorkbook in a different way:
> 
>   wb = new SXSSFWorkbook(
>     null, /* template workbook. pass null to start with a blank workbook */
>     1000, /* size of the sliding window*/
>     true, /* whether to compress temp files.*/
>     true  /* whether to use shared string table*/
>   );
> 
> 
> 
> not that it may increase the memory footprint, especially if the number of
> distinct strings is large .


Hi Yegor Kozlov,

As you stated, it worked fine, if a same string is written in all the cells
(500 Row X 150 Column). Even it is good if same string written in (750 rows X
150 Column).

Thus by digging more about it,I came to know how shared string table concept
works.

But for more number of distinct string that need to be inserted, i face java
heap space out of memory error, since shared string takes all distinct in into
heap memory.

Help me to improve it further.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message