This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to install and Load xlsx package in RStudio usind Windows10

Hi there,

I have tried to install and load xlsx package but I could not do that. Could anyone help me?

I got the following error:

library(xlsx)
Carregando pacotes exigidos: rJava
Error: package or namespace load failed for ‘rJava’:
 .onLoad falhou em loadNamespace() para 'rJava', detalhes:
  chamada: fun(libname, pkgname)
  erro: JAVA_HOME cannot be determined from the Registry
Error: package ‘rJava’ could not be loaded

Thanks in advance

r
• 18,445 views • link
updated by Shicheng Guo Shicheng Guo • written by Sanches • Sanches

Is Java installed on this machine?

• 0 views • link
written by GenoMax GenoMax

And if it is, check if it is the 32 or 64 bit, and then check if R is also 32 or 64.

• 0 views • link
written by ATpoint ATpoint

Yes, it is......................................................................................

• 0 views • link
written by Sanches • Sanches

So you have not actually installed xlsx? install.packages("xlsx")

• 0 views • link
written by GenoMax GenoMax

I know it doesn't help with this enquiry, but I've found the readxl package is more portable between platforms

• 0 views • link
written by russhh russhh

1 answer

It is caused you didn't tell where Java is to R. Try the following command to tell the system where Java is:

Sys.setenv(JAVA_HOME='C:\\Program Files\\Java\\jre1.8.0_201')
library("rJava")
library("Deducer")
• 0 views • link
written by Shicheng Guo Shicheng Guo

Log in to answer this question.

More posts like this