Cannot install library(xlsx) in R and look for an alternative
Solution 1
This problem is generally caused by x86 vs x64 bit differences between the R session and the install Java edition. By default Java installs the x86 version and you have to search for the x64 version. if you look at the version of Java you have installed and then open your R session to the same if your using R studio you can click on Tools.GlobalOptions
and then select the version you need. ;-)
Solution 2
Here are some possible solutions:
- Install 64-bit version of Java. Here is the download link of Java.
- Re-install
rJava
. -
Manually set the directory of your Java location by setting it before loading the library
Sys.setenv(JAVA_HOME="C:\\Program Files\\Java\\jre7") # for 64-bit version
Sys.setenv(JAVA_HOME="C:\\Program Files (x86)\\Java\\jre7") # for 32-bit version
library(rJava)
Source: here
Solution 3
For mac user, installing Java for OS X 2014-001 works for me https://support.apple.com/kb/DL1572?locale=en_US
Related videos on Youtube
Comments
-
PMa about 4 years
I use R version 3.0.3. I was not able to install library(xlsx). Error message:
Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: inDL(x, as.logical(local), as.logical(now), ...) error: unable to load shared object 'C:/Program Files/R/R-3.0.3/library/rJava/libs/x64/rJava.dll': LoadLibrary failure: The specified module could not be found.
I then tried to install
rjava
on its own. Got the error message below:library("rJava", lib.loc="C:/Program Files/R/R-3.0.3/library") Error : .onLoad failed in loadNamespace() for 'rJava', details: call: inDL(x, as.logical(local), as.logical(now), ...) error: unable to load shared object 'C:/Program Files/R/R-3.0.3/library/rJava/libs/x64/rJava.dll': LoadLibrary failure: The specified module could not be found.
Is there another way to load excel file in R?
Thanks,
-
dickoa about 10 yearsMay be it's time to test the new openxlsx package which doens't rely on Java cran.r-project.org/web/packages/openxlsx/index.html
-
hrbrmstrpossible duplicate of Importing .xlsx file into R
-
-
bob over 4 yearsNothing changed for me after I installed this.