1

I am trying to read an excel file into R, the size is 14MB, I got the error below:

Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,  : 
     java.lang.OutOfMemoryError: Java heap space

I know it has to do with memory but I have no programming background and don't know how to go about solving this issue :(

mnel
  • 110,110
  • 27
  • 254
  • 248
PMa
  • 1,671
  • 6
  • 21
  • 28
  • Here is the code I used to read the Excel file `Hire – PMa Oct 01 '14 at 03:31
  • I installed the package `xlsx`, what is the other package? – PMa Oct 01 '14 at 03:34
  • installed openxlsx, still no luck, got the same error msg, I think it has something to do with memory leak? There are other similar posts re this error but not in R. But I cannot figure out how to fix it :( – PMa Oct 01 '14 at 03:41
  • You can use "openxlsx" package: install.packages("openxlsx") require(openxlsx) read.xlsx("....xlsx", sheet = 1, startRow = 1, colNames=TRUE) – Reza Rahimi Jun 11 '18 at 20:21

0 Answers0