Export Multiple Data Frames to Different Excel Worksheets in R (2 Examples) | write.xlsx2 & for-Loop

How to write several data tables to the same Excel worksheets in the R programming language. More details: https://statisticsglobe.com/export-da...
R code of this video:

data1 ＜- data.frame(x = 1:5, # Create three data frames
y = 1:5)
data2 ＜- data.frame(x1 = 5:1,
x2 = 9:5,
x3 = 7)
data3 ＜- data.frame(x = letters[1:5],
y = letters[1:5])

install.packages("xlsx") # Install & load xlsx
library("xlsx")

my_path ＜- "C:/Users/Joach/Desktop/my_directory/" # Store directory path

write.xlsx2(data1, paste0(my_path, "data_all.xlsx"), row.names = FALSE, sheetName = "data1") # Write xlsx file
write.xlsx2(data2, paste0(my_path, "data_all.xlsx"), row.names = FALSE, sheetName = "data2", append = TRUE) # Append to second sheet
write.xlsx2(data3, paste0(my_path, "data_all.xlsx"), row.names = FALSE, sheetName = "data3", append = TRUE) # Append to third sheet

data_names ＜- c("data1", "data2", "data3") # Vector of data names

write.xlsx2(get(data_names[1]), paste0(my_path, "data_all.xlsx"), row.names = FALSE, sheetName = data_names[1]) # Write xlsx file

for(i in 2:length(data_names)) {
write.xlsx2(get(data_names[i]), paste0(my_path, "data_all.xlsx"), row.names = FALSE, sheetName = data_names[i], append = TRUE) # Append other data frames
}

Follow me on Social Media:
Facebook:   / statisticsglobecom  
LinkedIn:   / statisticsglobe  
Patreon:   / statisticsglobe  
Pinterest: https://www.pinterest.de/JoachimSchork
Reddit:   / joachimschork  
Twitter:   / joachimschork