Any solution to eliminate out of memory error for large export to excel apart from increasing the heap size.

[Dronamraju, Santosh B (GE Indust, ConsInd)]

Hi everyone,

 

For large excel exports, I get out of memory error. Is there any way to
write directly to physical file record by record instead of using heap
and then writing the whole data to file system at the end?

 

Because increasing heap size is not working even if I use 1024 MB. As in
our application we have large and number of export to excel.

 

Thanks,

Santosh