I'm trying to load an .xlsx file into R that has one sheet and is about 31 MB in size.
I run the following
options( java.parameters = "-Xmx6g" )
yt = read.xlsx("big_spreadsheet.xlsx",1)
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.OutOfMemoryError: Java heap space
I never got this to work. I've lately been using the
readxl package for reading from Excel spreadsheets, which has no Java dependency and seems to work just fine.