Hi, As the XSSF implementation is fundamentally based on having all elements in memory, there will always be a file size which exceeds that available memory. How big are your files? I.e. are you just a bit over the available memory or a lot?
Maybe you can do a heapdump using the Java flags as explained at http://stackoverflow.com/a/543037/411846. Then using a tool like Eclipse MAT you can analyze the resulting hprof-dump to find out which parts use up most of the memory, this might at least tell us if it is feasible to try to reduce memory usage. Don't know about Pivot table functionality, so cannot say how much effort it would be to add it to the SXSSF implementation. Thanks... Dominik. On Thu, Mar 19, 2015 at 8:16 PM, Carlos Arroyo <[email protected]> wrote: > Hi, I would like to subscribe on this page to share knowledge and ask > questions about POI. I'm a developer and I'm using POI to create a very > large Excel file. The problem is that I'm having memory issues because I'm > using XSSFWorkbook and this uses a lot of memory. I could do it with > SXSSFWorkbook to solve the memory issue but I have to create pivot tables > and these tables are only available within XSSFWorkbook sheets, so I want > to know if there's a way to solve this problem.1- Maybe implement pivot > tables in SXSSFWorkbooks 2- Fix the memory issue with XSSFWorkbooks. Thanks > for your help. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
