Last data update: 2014.03.03

R: List all sheets in an excel spreadsheet.
excel_sheetsR 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