Error in read_excel

#Load Data
data <- read_excel('USRetailSales.xls')
Error in read_excel("USRetailSales.xls")

Please tell me how to fix it.
Thank you~

Have you installed the readxl package and loaded the readxl library?

install.packages("readxl")
library(readxl)

And is your Excel file in the R working directory? You may want to explicitly state the file path, as in read_excel("C"/Users/Jerry/R_files/USRetailSales.xls")

1 Like

Thank you. I used this:
install.packages('readxl')
library('readxl')
Cannot work.

Then I use yours:
install.packages("readxl")
library(readxl)

Fixed it.

Thank you very much~

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.