read_excel_allsheets {fabR}R Documentation

Read all Excel sheets using readxl::read_excel() recursively

Description

The Excel file is read and the values are placed in a list of tibbles, with each sheet in a separate element in the list. If the Excel file has only one sheet, the output is a single tibble.

Usage

read_excel_allsheets(filename, sheets = "")

Arguments

filename

A character string of the path of the Excel file.

sheets

A vector containing only the sheets to be read.

Value

A list of tibbles corresponding to the sheets read, or a single tibble if the number of sheets is one.

See Also

readxl::read_excel()

Examples

{

try(read_excel_allsheets(filename = tempfile()), silent = TRUE)

}


[Package fabR version 1.1.1 Index]