combine_excels {upstartr}

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.