combine_excels: Combine Excel files in a directory

View source: R/read.R

combine_excelsR Documentation

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.