Share:|

If you run very large reports and export them to excel you may see an error similar to this one.

 

ERROR (XlsExporter:A) - java.lang.IllegalArgumentException: Invalid row number (65536) outside allowable range (0..65535) java.lang.IllegalArgumentException:

Invalid row number (65536) outside allowable range (0..65535)

 

This simply means that your report is hitting excel's row limit of 65,536 rows. This limit applies to .xls files.

 

To handle this you can export to .csv or use .xlsx (XML spreadsheet file format) which supports up to 1,048,576 rows. Version 9.1 SP3 an upwards integrate natively with .xlsx.