Dear All, I have been trying to install Xlsx package in R but i have been getting this error after the installation. Please can anyone help?> any(grepl("xlsx",installed.packages()))[1] TRUE> library("xlsx")Loading required package: rJava Error: package or namespace load failed for ?rJava?: .onLoad failed in loadNamespace() for 'rJava', details: call: fun(libname, pkgname) error: JAVA_HOME cannot be determined from the Registry Error: package ?rJava? could not be loaded In addition: Warning messages: 1: package ?xlsx? was built under R version 3.4.3 2: package ?rJava? was built under R version 3.4.3 Thank you -- Onyeuwaoma Nnaemeka Dom PhD. Scientific Officer. Center for Basic Space Science (CBSS) National Space Research and Development Agency (NASRDA) Federal Ministry of Science and Technology University of Nigeria, Nsukka P. M. B. 2022, Nsukka, Enugu State, Nigeria. +2348032686377, +2347052835685 email:onyeuwaoma.emeka at cbss.nasrda.gov.ng [[alternative HTML version deleted]]
You need to make sure that the rJava package is working. Consider using the readxl package instead of xlsx. Best regards, ir. Thierry Onkelinx Statisticus / Statistician Vlaamse Overheid / Government of Flanders INSTITUUT VOOR NATUUR- EN BOSONDERZOEK / RESEARCH INSTITUTE FOR NATURE AND FOREST Team Biometrie & Kwaliteitszorg / Team Biometrics & Quality Assurance thierry.onkelinx at inbo.be Havenlaan 88 bus 73, 1000 Brussel www.inbo.be /////////////////////////////////////////////////////////////////////////////////////////// To call in the statistician after the experiment is done may be no more than asking him to perform a post-mortem examination: he may be able to say what the experiment died of. ~ Sir Ronald Aylmer Fisher The plural of anecdote is not data. ~ Roger Brinner The combination of some data and an aching desire for an answer does not ensure that a reasonable answer can be extracted from a given body of data. ~ John Tukey /////////////////////////////////////////////////////////////////////////////////////////// 2018-01-16 13:08 GMT+01:00 Emeka Don <emekadonn at gmail.com>:> Dear All, > I have been trying to install Xlsx package in R but i have been getting > this error after the installation. Please can anyone help? > >> any(grepl("xlsx",installed.packages())) > [1] TRUE >> library("xlsx") > Loading required package: rJava > Error: package or namespace load failed for ?rJava?: > .onLoad failed in loadNamespace() for 'rJava', details: > call: fun(libname, pkgname) > error: JAVA_HOME cannot be determined from the Registry > Error: package ?rJava? could not be loaded > In addition: Warning messages: > 1: package ?xlsx? was built under R version 3.4.3 > 2: package ?rJava? was built under R version 3.4.3 > > Thank you > > -- > Onyeuwaoma Nnaemeka Dom PhD. > Scientific Officer. > Center for Basic Space Science (CBSS) > National Space Research and Development Agency (NASRDA) > Federal Ministry of Science and Technology > University of Nigeria, Nsukka > P. M. B. 2022, Nsukka, Enugu State, Nigeria. > +2348032686377, +2347052835685 > email:onyeuwaoma.emeka at cbss.nasrda.gov.ng > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.
Or the openxlsx package, which does not require Java, and is similar to the xlsx
package in functionality (both reads and writes, for example).
--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
Lab cell 925-724-7509
?On 1/16/18, 4:42 AM, "R-help on behalf of Thierry Onkelinx"
<r-help-bounces at r-project.org on behalf of thierry.onkelinx at inbo.be>
wrote:
You need to make sure that the rJava package is working.
Consider using the readxl package instead of xlsx.
Best regards,
ir. Thierry Onkelinx
Statisticus / Statistician
Vlaamse Overheid / Government of Flanders
INSTITUUT VOOR NATUUR- EN BOSONDERZOEK / RESEARCH INSTITUTE FOR NATURE
AND FOREST
Team Biometrie & Kwaliteitszorg / Team Biometrics & Quality
Assurance
thierry.onkelinx at inbo.be
Havenlaan 88 bus 73, 1000 Brussel
www.inbo.be
///////////////////////////////////////////////////////////////////////////////////////////
To call in the statistician after the experiment is done may be no
more than asking him to perform a post-mortem examination: he may be
able to say what the experiment died of. ~ Sir Ronald Aylmer Fisher
The plural of anecdote is not data. ~ Roger Brinner
The combination of some data and an aching desire for an answer does
not ensure that a reasonable answer can be extracted from a given body
of data. ~ John Tukey
///////////////////////////////////////////////////////////////////////////////////////////
2018-01-16 13:08 GMT+01:00 Emeka Don <emekadonn at gmail.com>:
> Dear All,
> I have been trying to install Xlsx package in R but i have been
getting
> this error after the installation. Please can anyone help?
>
>> any(grepl("xlsx",installed.packages()))
> [1] TRUE
>> library("xlsx")
> Loading required package: rJava
> Error: package or namespace load failed for ?rJava?:
> .onLoad failed in loadNamespace() for 'rJava', details:
> call: fun(libname, pkgname)
> error: JAVA_HOME cannot be determined from the Registry
> Error: package ?rJava? could not be loaded
> In addition: Warning messages:
> 1: package ?xlsx? was built under R version 3.4.3
> 2: package ?rJava? was built under R version 3.4.3
>
> Thank you
>
> --
> Onyeuwaoma Nnaemeka Dom PhD.
> Scientific Officer.
> Center for Basic Space Science (CBSS)
> National Space Research and Development Agency (NASRDA)
> Federal Ministry of Science and Technology
> University of Nigeria, Nsukka
> P. M. B. 2022, Nsukka, Enugu State, Nigeria.
> +2348032686377, +2347052835685
> email:onyeuwaoma.emeka at cbss.nasrda.gov.ng
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.