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

--- 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

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

View raw message