List all sheets in an excel spreadsheet
List all sheets in an excel spreadsheet
excel_sheets(path)
path |
Path to the xls/xlsx file. |
excel_sheets(readxl_example("datasets.xlsx"))
excel_sheets(readxl_example("datasets.xls"))
# To load all sheets in a workbook, use lapply
path <- readxl_example("datasets.xls")
lapply(excel_sheets(path), read_excel, path = path)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.