OutofMemory exception on writing huge XLS using POI

Hi,

I am using PI HSSF to generate XLS files from serialized data. This works
well for small sets of data but for huge data sets (10 MB XLS size or >
100k rows), I get an Memory error.

analyzing heap memory, it was found that all the HSSFRow and HSSFCell
objects are retained in the memory. So, for a huge result set, the memory
usage is also huge.

Is it possible to configure PI to flush data into the XLS file and clean up
the memory every once-in-a-while?

Please let know if there is any solution.

Thanks in advance.
Vishal