How to install and Load xlsx package in RStudio usind Windows10

Question

[Sanches]

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

[russhh]

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

[GenoMax]

Is Java installed on this machine?

[ATpoint]

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

[Sanches]

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

[GenoMax]

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

Answer 1

[Shicheng Guo]

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")