How do I exceed 65536 rows when I am creating an excel file

[ndedhia1]

I am creating an excel file, using the jxl jar, but I get this error when I go over 65536 rows:

Spreadsheet Generation failed in constructor
 
class jxl.write.biff.RowsExceededException
 
The maximum number of rows permitted on a worksheet been exceeded
 
jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
 
        at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:813)
 
        at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:789)
 
        at com.cboe.support.spreadsheetGenerator.writeOutliers(spreadsheetGenerator.java:1077)
 
        at com.cboe.support.spreadsheetGenerator.make(spreadsheetGenerator.java:150)
 
        at com.cboe.support.ReportGenerator.createSpreadsheet(ReportGenerator.java:204)
 
        at com.cboe.support.ReportGenerator.main(ReportGenerator.java:109)
 
The maximum number of rows permitted on a worksheet been exceeded
 
[Ljava.lang.StackTraceElement;@14233d3
 

I know that excel 2007 and newer allow over 1 million rows. Is there a jxl jar that also that also?

Thanks
Nirav

[r035198x]

The older binary HSSF has compatibility problems for more than 65536. You'll probably get the same issue even if you use Apache's POI. Consider restructuring the data, maybe multiple sheets or maybe even something else that is not excel for the storage. I wouldn't advise changing the third party API's code to remove the limit.