poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vishal <vishalmano...@gmail.com>
Subject OutofMemory exception on writing huge XLS using POI
Date Thu, 03 Jul 2008 06:18:10 GMT

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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message