How to Fix the java.lang.OutOfMemoryError while Loading Large Spreadsheets

There is a fair chance that the Workbook constructor may throw java.lang.OutOfMemoryError while loading large spreadsheets. This exception suggests that the available memory is insufficient to completely load the spreadsheet into memory; therefore, the spreadsheet must be loaded while enabling the Memory Preferences.

How to Fix the java.lang.OutOfMemoryError While Loading Large Spreadsheets

Aspose.Cells APIs provide Memory Preferences to optimize memory consumption while loading and processing spreadsheets. These options are also helpful in efficiently loading large spreadsheets containing huge data sets into a Workbook object, as demonstrated below.

Java

 // Specify the LoadOptions
LoadOptions options = new LoadOptions();

// Set the memory preferences
options.setMemorySetting(MemorySetting.MEMORY_PREFERENCE);

// Instantiate the Workbook and load the large Excel file containing a large data set
Workbook book = new Workbook("sample.xlsx", options);