library(xlsx)
sheet_1 <- read_excel("Name.xlsx", sheet = "sheet_you_want_cloning")
# imports the sheet you want to clone from Name.xlsx
write.xlsx(sheet_1, file = "Excel_File_you_want_to_add_the_sheet_to.xlsx", sheetName=nameofnewsheet, append=TRUE, row.names = FALSE)
# writes sheet_1 as a sheet called "nameofnewsheet" in the excel file called Excel_File_you_want_to_add_the_sheet_to.xlsx
1条答案
按热度按时间e0bqpujr1#
很容易做到。