By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,645 Members | 1,328 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,645 IT Pros & Developers. It's quick & easy.

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

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

Expand|Select|Wrap|Line Numbers
  1. Spreadsheet Generation failed in constructor
  2.  
  3. class jxl.write.biff.RowsExceededException
  4.  
  5. The maximum number of rows permitted on a worksheet been exceeded
  6.  
  7. jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
  8.  
  9.         at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:813)
  10.  
  11.         at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:789)
  12.  
  13.         at com.cboe.support.spreadsheetGenerator.writeOutliers(spreadsheetGenerator.java:1077)
  14.  
  15.         at com.cboe.support.spreadsheetGenerator.make(spreadsheetGenerator.java:150)
  16.  
  17.         at com.cboe.support.ReportGenerator.createSpreadsheet(ReportGenerator.java:204)
  18.  
  19.         at com.cboe.support.ReportGenerator.main(ReportGenerator.java:109)
  20.  
  21. The maximum number of rows permitted on a worksheet been exceeded
  22.  
  23. [Ljava.lang.StackTraceElement;@14233d3
  24.  
I know that excel 2007 and newer allow over 1 million rows. Is there a jxl jar that also that also?

Thanks
Nirav
Apr 15 '13 #1
Share this Question
Share on Google+
1 Reply


10K+
P: 13,264
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.
Apr 16 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.