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: dev@poi.apache.org Reporter: thamodharan...@gmail.com 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: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org