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

D

6

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?

Deicide answered 22/4, 2014 at 2:5 Comment(8)

possible duplicate of Importing .xlsx file into R – Abernon 22/4, 2014 at 2:7

Have a look at this blog post on rJava r-statistics.com/2012/08/… Make sure you have the right version of java. – Endoergic 22/4, 2014 at 2:8

May 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 – Itching 22/4, 2014 at 2:34

@Itching Nice find Didn't know this existed. +1 – Endoergic 22/4, 2014 at 3:10

@Itching package ‘openxlsx’ is not available (for R version 3.0.3) :( :( :( – Deicide 22/4, 2014 at 3:13

You should only have gotten that message if your repository were incomplete ( or you were on a Mac), So please provide more details about he code you are using and your setup. – Heliotropism 22/4, 2014 at 5:44

@TylerRinker I think this package is new, I'm really happy to have a decent cpp based solution to xlsx IO. – Itching 25/4, 2014 at 15:38

This will not solve this specific issue, but perhaps you might want to use readxl: github.com/hadley/readxl . It has no external dependencies. – Camouflage 12/11, 2015 at 15:59

H

10

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

Handicraftsman answered 6/11, 2015 at 8:30 Comment(0)

T

9

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

Tamathatamaulipas answered 4/12, 2014 at 23:8 Comment(0)

E

2

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

Eiten answered 13/7, 2015 at 2:37 Comment(1)

Nothing changed for me after I installed this. – Copperhead 31/10, 2019 at 23:37

G

1

For Windows 10 Pro users 64 bit OS, use

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

Gas answered 19/9, 2017 at 10:35 Comment(0)

S

0

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

Scrutable answered 9/12, 2022 at 22:5 Comment(0)

I

-1

For MAC OS X follow these steps in order:

Use this command in the Terminal: sudo R CMD javareconf
Restart BaseR and RStudio...
in RStudio console: install.packages("xlConnect")
in RStudio console: library(xlConnect)
in RStudio console: library(xlsx)

Problem solved!

Intoxication answered 1/5, 2019 at 17:15 Comment(0)

Recommended topics

Hot tags