Free Support Forum - aspose.com

Java Memory issue using Apache.POI to read write Excel. Can i use Aspose?


#1

I got a OutOfMemoryError: GC overhead exceed in Apache.POI to huge file read write Excel on time. Can i use Aspose for read and write excel. i need to read and write in excel #big files


#2

@Raj1995Java,

Aspose.Cells can handle (read/write) bigger files.

Well, MEMORY_PREFERENCE load option would be useful when you are reading a huge file, see the document for your reference. If you are not using a big file or does not add long list of data/contents, you may skip it. See the document for your reference:
https://docs.aspose.com/display/cellsjava/Optimizing+Memory+Usage+while+Working+with+Big+Files+having+Large+Datasets

The other option Aspose.Cells provides is to use Light Cells API to improve performance and efficiency, as described in the next article.
Using LightCells API

If you still find the issue, kindly provide us sample code (runnable) and template file (you may zip the file(s) prior attaching) to show the issue, we will check it soon.