How to solve this error:Row number must be between 0 and 65535, was <65536>

[Balmu]

Hi,

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,
Balmu

[masher]

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.