SXSSF approach to resolve Out of memory Exception for large tables

[Sudheer Jonna]

Dear Community,

                        I need to export large table(3000rows,8-10 columns)
into xlsx format using Apache POI API.Initially export excel for all tables
in the application acheived with the help of XSSF format(Including this
large table).But when we are trying to export large tables it is throwing
out of memory exceptions.

I found below two options as solutions

 1.SXSSF format:XSSFWorkbook and XSSFSheet replaced with SXSSFWorkbook and
SXSSFSheet respectively.But still the out of memory exception is not
resolved.Is it a right approach to solve this issue?

2.SpreadSheetML(SpreadSheetWriter or BigGridDemo concept): Able to export
to large table.But it is very difficult to do customizations with this
approach.And this approach is entirely different compared to other
apporaches.

               Which will be the better approach to resolve Out of memory
exceptions with large tables.

Thanks in advance

Regards,
Sudheer