read_excel_allsheets: Load all excel sheets

Description Usage Arguments Value Examples

View source: R/read_excel_allsheets.R

Description

Loads all of the sheets of the excel file filepath, and returns them as a list of tibbles or data.frames.

Usage

1
read_excel_allsheets(filepath, cnames = TRUE, tibble = FALSE)

Arguments

filepath

Path to an excel file.

cnames

Logical value determining if column names should be included. Defaults to TRUE.

tibble

Logical value determining if the data should be loaded as tibbles or data.frames. Defaults to FALSE.

Value

List of tibbles or data.frames, each corresponding to one sheet.

Examples

1
2
3
file = system.file('extdata', 'human_viruses.xls', package = 'myPackage')
read_excel_allsheets(file, cnames = TRUE, tibble = TRUE)
read_excel_allsheets(file)

ryanmcnamara4/myPackage documentation built on Dec. 22, 2021, 8:18 p.m.