Bug 49238 - Unable to generate xlsx files to accomodate 66k+ records
Summary: Unable to generate xlsx files to accomodate 66k+ records
Alias: None
Product: POI
Classification: Unclassified
Component: XWPF (show other bugs)
Version: 3.6-FINAL
Hardware: PC Solaris
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2010-04-30 16:16 UTC by Raghavendra Rao
Modified: 2010-04-30 18:18 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Raghavendra Rao 2010-04-30 16:16:31 UTC
Hello All,
I was using POI 2.5.1 to generate an XLS report. All was fine until the problem cropped up when the Report generation in Production crossed the 65k+ limit set by Excel 2003. Since anyway we open the reports in Excel 2007, my immediate instinct was to change the filename of my report from .xls to .xlsx. Obviously this didn't work since I was using POI 2.5.1.

Then I downloaded the latest POI 3.6 and tried to open the generated .xlsx file. Even now I get the same error as I used to get with POI 2.5.1 as follows:
"Excel cannot open the file '<filename.xlsx>' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Moment I revert the file extension to .xls, it allows me to open the file. But it still cannot support more than 65k+ records. 

Based on 3.6' documentaton I have compiled my sources in JDK 1.5. Please let me know your thoughts.

Comment 1 David Fisher 2010-04-30 18:18:35 UTC
Please see http://poi.apache.org/spreadsheet/converting.html for information about how to convert from using HSSF to the SS model so that you can support both xls and xlsx from your program.

Join the poi-user list and ask any questions there.