how to read xls file in R code example

Example 1: how to read excel file in r

library("readxl")
# xls files
my_data <- read_excel("my_file.xls")
# xlsx files
my_data <- read_excel("my_file.xlsx")

Example 2: read xlsx in r

require(gdata)
df = read.xls ("myfile.xlsx"), sheet = 1, header = TRUE)