Combine Excel files in a directory
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, ...)
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 |
A tibble of concatenated data from multiple Excel files.
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.