Dear all,
I have a problem reading xlsx files in R.
Could anybody help me how to resolve the problem?
install.packages("xlsx", dependencies=TRUE)
library(xlsx)
library(rJava)
data <- read.xlsx("3.1.xlsx", sheetIndex = 3.1)
data <- read.xlsx("3.1.xlsx", sheetName=
"a",as.data.frame=TRUE, header=TRUE)
data <- read.xlsx("3.1.xlsx", 1)
the error message is :
Error in .jcall("RJavaTools", "Ljava/lang/Object;",
"invokeMethod", cl, :
java.lang.OutOfMemoryError: GC overhead limit exceeded
I also have problem in reading Rmpi library.
I installed it correctly however when I read it by library(Rmpi) I received an
error message:
Error : .onLoad failed in loadNamespace() for 'Rmpi', details:
call: inDL(x, as.logical(local), as.logical(now), ...)
error: unable to load shared object
'C:/Users/Amir/Documents/R/win-library/3.0/Rmpi/libs/x64/Rmpi.dll':
LoadLibrary failure: The specified module could not be found.
Error: package or namespace load failed for ‘Rmpi’
My many many thanks your help in advance.
Best,
Amir
[[alternative HTML version deleted]]