community-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thamodharan Balraj <thamodharan...@gmail.com>
Subject Apache POI: Content Issue while processing huge excel file with SXSSF
Date Wed, 22 Nov 2017 15:17:47 GMT
Hi Everyone,

I am trying to generate a excel with SXSSF workbook. The size of excel may
shoot to 200-300MB, whose row count will be 5,00,000 and column count will
be around 150 approximately..! I get content issue while opening such large
excel file.
The version which I am using is APACHE POI 3.9
I had also tried with, 3.15 the same issue exist.

System holds enough ram and disk space as per the requirement.

3.9 performance seems to better than other versions, Is there any way to
rule this issue out in that version.?

Anyone, who has idea on above scenario, kindly help me to proceed further.

Regards
Thamodharan B

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message