excel_sheets {readxl}R Documentation

List all sheets in an excel spreadsheet

Description

List all sheets in an excel spreadsheet

Usage

excel_sheets(path)

Arguments

path

Path to the xls/xlsx file.

Examples

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)

[Package readxl version 1.1.0 Index]