bindExcels: Combine Excel Files

Description Usage Arguments Value Author(s) See Also Examples

Description

Combine excel files into one.

Usage

1
bindExcels(sheet.num = 1, files = NULL, output.format = "xlsx")

Arguments

sheet.num

Sheet number where data is stored. If null, then dplyr::bind_rows all the sheets.

files

Designate the files yourself, or manually select them.

output.format

xls or xlsx. Default xlsx.

Value

A list containing a data frame listing the files and sheets combined.

Author(s)

Yiying Wang, wangy@aetna.com

See Also

bind_rows in package dplyr.

Examples

1
2
3
4
## Not run: 
bindExcels()

## End(Not run)

madlogos/aseshms documentation built on May 21, 2019, 11:03 a.m.