Given a directory (and, optionally, a pattern to search against), concatenate all Excel files into a single tibble.
combine_excels(dir, pattern = "*.xls[x]?", all_sheets = FALSE, ...)Path to the directory to look at for files.
Pattern to use for detecting files. (Default: '*.xls[x]?')
Should this function also concatenate all sheets within each Excel file into one long tibble? (Default: FALSE)
Parameters to pass to readxl::read_excel.
A tibble of concatenated data from multiple Excel files.