R语言-循环读取excel内全部sheet

Question

如题所述

Answer 1

excel_path <- c("C:/Users/lvjs9/Desktop/excel.xlsx")
inverse_unf_l<- read_excel(excel_path,1)[0]
for (i in (1:length(excel_sheets(excel_path)))){
inverse_unf_l <- rbind(inverse_unf_l , read_excel(excel_path,i))
}