CODEWITHSUNDEEP
rxlsxrjava
PMa
PMa

Reputation: 1771

Cannot install library(xlsx) in R and look for an alternative

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?

Upvotes: 6

Views: 76422

Answers (6)

Anurag Gupta
Anurag Gupta

Reputation: 509

install.packages("openxlsx") try to install OPENXLSX instead of XLSX package. Now, the required library will work properly. library(openxlsx)

Upvotes: 0

CarlWithTheSauce
CarlWithTheSauce

Reputation: 1

For MAC OS X follow these steps in order:

  1. Use this command in the Terminal: sudo R CMD javareconf

  2. Restart BaseR and RStudio...

  3. in RStudio console: install.packages("xlConnect")

  4. in RStudio console: library(xlConnect)

  5. in RStudio console: library(xlsx)

Problem solved!

Upvotes: -1

user8632920
user8632920

Reputation: 11

For Windows 10 Pro users 64 bit OS, use

Sys.setenv(JAVA_HOME="C:\\Program Files\\Java\\jre1.8.0_144")

Upvotes: 1

pe-perry
pe-perry

Reputation: 2621

Here are some possible solutions:

  1. Install 64-bit version of Java. Here is the download link of Java.
  2. Re-install rJava.

  3. 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

Upvotes: 10

Ryan Chu
Ryan Chu

Reputation: 1537

For mac user, installing Java for OS X 2014-001 works for me https://support.apple.com/kb/DL1572?locale=en_US

Upvotes: 2

Robert AA Turnage
Robert AA Turnage

Reputation: 91

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. ;-)

Upvotes: 9

Related Questions