GC overhead error using xlsx

Question

I am trying to read xlsx files in R using the xlsx library. Below is my piece of code.

options(java.parameters = "-Xmx8g")
data <- read.xlsx("data.xlsx",
                  header = FALSE, sheetName="Sheet1")

It throws the following error

Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: GC overhead limit exceeded

I have tried different method to increase java heap memory, but could not succeed. I am using java8 at ubuntu. The file size is 4MB only. I have followed different instructions at similar questions on different forums but could not succeed.

Any suggestions will be appreciated.

Yes. `install.packages("openxlsx")`. It does not rely on Java, which may be useful in this case. — lmo, Feb 23 '17 at 19:33
Then download an older version which is supported in R 3.2.2 and compile from source. — Roman Luštrik, Feb 25 '17 at 12:27

score 1 · Accepted Answer · answered Feb 23 '17 at 21:37

1

Try readxl, which AFAIK is one of the most efficient ways to read Excel files in R.

answered Feb 23 '17 at 21:37

salient

2,316
6
28
43

hi, is there similar for writing as well? – mc29 Feb 24 '17 at 09:54
You'll have to use `openxlsx` or something of the likes for writing unfortunately: https://github.com/tidyverse/readxl/issues/231 – salient Feb 24 '17 at 21:33

GC overhead error using xlsx

1 Answers1