I'm attempting to read a 15mb xlsx file for a program I'm writing using SmartXLS.
I have been getting errors and I have been attempting to figure out the cut-off for when I will be allowed to read the sheet.
At 15 mb, I was receiving a SmartXLS error.
At 14 mb, I was receiving the java.lang.OutOfMemoryError: Java heap space
At 10 mb, I am still receiving the OutOfMemoryError
At 5 mb, it allowed me to read the xlsx.
I assume this means I need to get Java to allocate more memory. Is anyone able to explain to me how?