Read an Excel file directly from a R script?

Question

How can I read an Excel file directly into R? Or should I first export the data to a text- or CSV file and import that file into R?

Answer 1

You can use readxl package and do

dat <- read_xlsx("path")