You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2010/04/30 22:16:35 UTC

DO NOT REPLY [Bug 49238] New: Unable to generate xlsx files to accomodate 66k+ records

https://issues.apache.org/bugzilla/show_bug.cgi?id=49238

           Summary: Unable to generate xlsx files to accomodate 66k+
                    records
           Product: POI
           Version: 3.6
          Platform: PC
        OS/Version: Solaris
            Status: NEW
          Severity: major
          Priority: P2
         Component: XWPF
        AssignedTo: dev@poi.apache.org
        ReportedBy: k.raghavendra.rao@oracle.com


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.

Regards,
Raghu

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

DO NOT REPLY [Bug 49238] Unable to generate xlsx files to accomodate 66k+ records

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49238

David Fisher <df...@jmlafferty.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID

--- Comment #1 from David Fisher <df...@jmlafferty.com> 2010-04-30 18:18:35 EDT ---
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.

Thanks,
Dave

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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