The readxl R package makes it very easy and straightforward to read data from Excel files into R:
We start by loading the module into R:
library(readxl)
Reading Excel data with readxl is simple; we just need to call the read_excel function and pass in the file path, as follows:
read_excel("data.xls")
readxl supports both the old XLS and the new XLSX format. It guesses the format from the extension of the file being read:
read_excel("data.xlsx")
Excel files sometimes have multiple sheets. For example, the following Excel file has multiple sheets:
You can easily handle them with the readxl package. ...
