read xlsx files r code example

Example 1: read xlsx in r

require(xlsx)
read.xlsx("myfile.xlsx", sheetName = "Sheet1")
read.xlsx2("myfile.xlsx", sheetName = "Sheet1")

Example 2: read xlsx in r

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