Hi, I am using POI 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 OutOfMemory error.
On 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 POI 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
