Last data update: 2014.03.03
|
R: List all sheets in an excel spreadsheet.
excel_sheets | 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(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)
Results
|