https://bz.apache.org/bugzilla/show_bug.cgi?id=61832
Bug ID: 61832
Summary: Unable to create a excel of 500,000 rows and 150
column using SXSSF workbook
Product: POI
Version: unspecified
Hardware: PC
OS: All
Status: NEW
Severity: major
Priority: P2
Component: SXSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 35565
--> https://bz.apache.org/bugzilla/attachment.cgi?id=35565&action=edit
"GenerateExcelFile.txt" contains the java code.
I am trying to generate a excel with SXSSF workbook. The size of excel may
shoot to 200-300MB, whose row count will be 500,000 (i.e 0.5 million) 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.
FYI, I hadn't applied any styles or format for the cells, just inserted a data
of 25 character length. I hadn't violated/crossed any excel
specification/limits.
Please find the sample code as below.
The alert message which I receive on opening the excel file is,
"We found a problem with some content in 'filename'. Do you want us to try to
recover as much as we can? If you trust the source of this workbook"
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
