excel_sheets {readxl} | R Documentation |
List all sheets in an excel spreadsheet.
excel_sheets(path)
path |
Path to the xls/xlsx file |
excel_sheets(system.file("extdata/datasets.xlsx", package = "readxl")) excel_sheets(system.file("extdata/datasets.xls", package = "readxl")) # To load all sheets in a workbook, use lapply path <- system.file("extdata/datasets.xls", package = "readxl") lapply(excel_sheets(path), read_excel, path = path)