Java Programming

Hi all,

This is related to using poi.jar i.e., HSSF API.
I am trying to write a very large no of records into an Excel file. The max no of rows technically allowed is around 64000 per sheet, after which i want to create a new sheet in the same xls file.

But the data in a single row is so huge i.e., around 12 columns, it is not allowing to write more than 20K rows containing 12 cols. It keeps giving memoryOutOfException.

Could you please suggest a possible solution for this.

One way what i feel would serve the purpose is smth like this: normally we create a workbook and write the whole data into it by creating required rows/cols. Instead of writing this workbook to the file at the end, can this be done in middle....smth like writing chunks of data into the file which might not probably throw the memoryexception.

Any help in this regard is highly appreciated.

Thanks,
ksk