R语言读取xlsx文件read.xlsx()报错

Question

library(xlsx)
cars <- read.xlsx(file = "mtcars.xlsx",sheetIndex = 1,header = T)

Error in loadWorkbook(file, password = password) :
java.lang.InstantiationException: org.apache.poi.ss.usermodel.WorkbookFactory
请问这个错误是出于什么原因，有人遇到过么

Answer 1

xlsx包需要配置好Java环境，建议使用openxlsx包，cars <- read.xlsx(file = "mtcars.xlsx",sheet = 1)