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

Lately i got this error while using apache poi version 3.2 but it's still exists in 3.7:

"the poi 3.2 or 3.7 version support till 65535 max rows not more"

Actually, excel 2003 maximum rows in a sheet is 65535, but since than in version like in excel 2007 and excel 2010

the maximum rows per sheet is around 1m. But apache poi still doesn't support this amount of rows.

Meaning, that you need to split into several sheets

Something like this:

if (i>65535){ // or some other number or condirion

    // create a new sheet

    sheet = workBook.createSheet();

   i = 1;

}

Hoped that it helps,

Dor

bad major version at offset=6

Hi,
Mainly happens or appears when you have a different java versions installed in your IDE / Server.
Try to be consist with the versions you are working with or compiling with or working in the server you have.
Bye,
Dor

This application is out of date, please click the refresh button on your browser. ( Expecting version 5 from client, got 6. )

Common issue after upgrading to GWT 2.1 from previous versions.
If you got this exception, probably you application has gwt-servlet.jar which belongs to the previous version.
Replace it or remove and let you environment to create it instead of the old one.
Worked for me.
Hoping it helps,
Dor