Cannot read .xlsx file in R

user_13129718 0
Viewed 1796

How do I read excel files with .xlsx extension in r programming language? I have tried installing package xlsx but after I run library(xlsx) I get -

Error: package or namespace load failed for ‘xlsx’: .onLoad failed in loadNamespace() for 'rJava', details: call: fun(libname, pkgname) error: JAVA_HOME cannot be determined from the Registry In addition: Warning message: package ‘xlsx’ was built under R version 3.5.3 ".

Further, how can I convert .xlsx file to .csv file?

data-import xlsx csv r excel
2 Answers

try readxl package:

library(readxl)
read_excel("your_file.xlsx", sheet = yourSheet_number)

You can convert .xlsx to .csv by reading .xlsx and then saving with readr package:

library(readr)
write_csv(yourFile, "yourDirectory")
user_129175630

This code should help:

library(readxl)
dataset <- read_xlsx("myfile.xlsx")
write.csv(dataset,"mycsv.csv")
user_128004050
Related