combine_excels: Combine Excel files in a directory

In upstartr: Utilities Powering the Globe and Mail's Data Journalism Template

Combine Excel files in a directory

Description

Given a directory (and, optionally, a pattern to search against), concatenate all Excel files into a single tibble.

Usage

combine_excels(dir, pattern = "*.xls[x]?", all_sheets = FALSE, ...)

Arguments

dir	Path to the directory to look at for files.
pattern	Pattern to use for detecting files. (Default: '*.xls[x]?')
all_sheets	Should this function also concatenate all sheets within each Excel file into one long tibble? (Default: FALSE)
...	Parameters to pass to readxl::read_excel.

Value

A tibble of concatenated data from multiple Excel files.

upstartr documentation built on May 29, 2024, 9:08 a.m.