read_excel_allsheets {fabR} | R Documentation |
readxl::read_excel()
recursivelyThe 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.
read_excel_allsheets(filename, sheets = "")
filename |
A character string of the path of the Excel file. |
sheets |
A vector containing only the sheets to be read. |
A list of tibbles corresponding to the sheets read, or a single tibble if the number of sheets is one.
{
try(read_excel_allsheets(filename = tempfile()), silent = TRUE)
}