load_excel_sheets: Load all sheets from an excel file into R

In al-obrien/farrago: A random collection of helpful code baubles

Load all sheets from an excel file into R

Description

load_excel_sheets will load all sheets from an excel file.

Usage

load_excel_sheets(filename, tibble = FALSE, ...)

Arguments

filename	A character string for the file path where the excel file is located.
tibble	A logical value, if TRUE will export all sheets as a tibble object.
...	Additional parameters passed to read_excel.

Value

Datasets for all sheets within excel file.

Note

Requires the readxl package to operate.

Source

Adapted from Jeromy Anglim's stackoverflow contribution: https://stackoverflow.com/questions/12945687/read-all-worksheets-in-an-excel-workbook-into-an-r-list-with-data-frames

Examples

## Not run: 
loaded_sheets <- load_excel_sheets("myexcelfile.xls")

## End(Not run)

al-obrien/farrago documentation built on April 14, 2023, 6:20 p.m.