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