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]]


