Read Excel File in R (Example) | xlsx, xls, read_excel, readxl, & openxlsx | Multiple Files & Sheets

How to read Excel files in the R programming language. More details: https://statisticsglobe.com/r-read-ex... R code of this video: data(iris) # Load iris data to RStudio head(iris) # Print first 6 rows of iris install.packages("xlsx") # Install xlsx R package library("xlsx") # Load xlsx R package to RStudio setwd("C:/Users/Joach/Desktop/my directory") # Set working directory xlsx::write.xlsx(iris, # Write example Excel xlsx file "iris.xlsx", row.names = FALSE) data1 ＜- xlsx::read.xlsx("iris.xlsx", # Read xlsx file with read.xlsx sheetIndex = 1) install.packages("readxl") # Install readxl R package library("readxl") # Load readxl R package to RStudio data2 ＜- readxl::read_excel("iris.xlsx") # Read xlsx file with read_excel install.packages("openxlsx") # Install openxlsx R package library("openxlsx") # Load openxlsx R package to RStudio data3 ＜- openxlsx::read.xlsx("iris.xlsx") # Read file with read.xlsx of openxlsx data(mtcars) # Load mtcars data to RStudio head(mtcars) # Print first 6 rows of mtcars xlsx::write.xlsx(mtcars, # Write second sheet to Excel file "iris.xlsx", row.names = FALSE, append = TRUE, # Specify that data gets appended sheetName = "mtcars") data_sh2 ＜- xlsx::read.xlsx("iris.xlsx", # Read second sheet of Excel file sheetName = "mtcars") xlsx::write.xlsx(mtcars, # Write mtcars as separate Excel file "mtcars.xlsx", row.names = FALSE) all_file_names ＜- list.files(pattern = "*.xlsx") # Grab list of all xlsx files in directory all_file_names # Print list of xlsx files in directory data_list ＜- lapply(all_file_names, read_excel) # Read multiple excel files data_list # Print list of data.frames xlsx::write.xlsx(iris, # Write xls Excel file "iris.xls", row.names = FALSE) data_xls ＜- xlsx::read.xlsx("iris.xls", # Read xls Excel file sheetIndex = 1) Follow me on Social Media: Facebook – Statistics Globe Page:   / statisticsglobecom   Facebook – Group for Discussions & Questions:   / statisticsglobe   LinkedIn – Statistics Globe Page:   / statisticsglobe   LinkedIn – Group for Discussions & Questions:   / 12555223   Twitter:   / joachimschork   Music by bensound.com