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 Thu, 11 Jan 2018 13:17:11 GMT

--- Comment #19 from Thamodharan <thamodharan247@gmail.com> ---
My machine specs,

Jboss server
Heap size allocated to jboss 28 GB
Harddisk 1 TB

I am good to go with generating excel file upto a limit of 0.3 million X 200
rows with enabling shared string. Ahead such row, i face corrupt file issue
when opening the generated excel. The reason for this error as stated by greg
woolsey is, the data's are stored as inline string in the disk, thus excel
couldn't tolerate putting such large number of inline string, thus repairing
it, turning inline to single shared string.

As suggested by greg woolsey, its better to go by enabling shared string, which
holds unique data in heap space instead of disk space. This idea may aid the
application to generate a single excel file in my machine with the above spec,
but generating 2 or more excel at same time, will lead to memory out.

I guess, writing a patch to store data in disk, rather in heap, will again lead
to inline string and same error may occur.

Can anyone from apache dev team or other followers, ignite a vice idea to rule
this error out ?

Waiting a good response

Thamodharan B

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