Recently I had to read in a folder full of large Excel (.xlsx) files. I did as I usually did and use the xlsx library. However, reading in the largest files produced an error:
“Error in .jcall(“RJavaTools”, “Ljava/lang/Object;”, “invokeMethod”, cl, : java.lang.OutOfMemoryError: Java heap space”
I don’t know what cause the issues, but solving this problem was rather easy. I switched to the openxlsx library. This package completely removes the dependency on Java.
Its read and write times are more or less the same and the read.xlsx() function offers the same functionalities as the xlsx library.
Openxlsx is my newest friend for interacting with Excel files.