How to solve this error:Row number must be between 0 and 65535, was <65536>
Iam generating an excel report which retrieves the data from SQL database and displays in the excel sheet.
FYI, Iam using WSAD and the framework is a Struts framework.
Likewise, an excel sheet is generated, which results in an error:
java.lang.IndexOutOfBoundsException: Row number must be between 0 and 65535, was <65536>
Can anyone please help me solve this exception?
Is there any relation to the POI jar which Iam using?
Iam using the jar poi-3.0.2-FINAL-20080204.jar
Thanks & Regards,
Looks like you can only have 65535 rows in your excel spreadsheet.
You'll need to organise things so you get less than that, or to start importing into a new sheet when you fill one up.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center