read.xlsx.multi: Read Multiple Excel workbooks

Description Usage Arguments Value

View source: R/read.xslx.multi.R

Description

Read all the xlsx files in a folder that have filenames matching a given pattern and return a single data.frame

Usage

1
2
3
4
5
6
7
8
9
read.xlsx.multi(
  folder,
  sheet = 1,
  pattern = NULL,
  dupVar = NULL,
  orderBy = NULL,
  decreasing = T,
  messageLevel = 0
)

Arguments

folder

character of length 1 with the address of a folder

sheet

integer or character of length 1 indicating the worksheet to use

pattern

character string containing a regular expression to be matched in the given character vector. Coerced by as.character to a character string if possible. If a character vector of length 2 or more is supplied, the first element is used with a warning.

dupVar

character of length 1 with the name of a variable for which duplicates should be dropped

orderBy

character of length 1 with the name of a variable by which to sort the result

decreasing

logical, should ordering be done by decreasing values?

messageLevel

integer, the level of messages that should be printed to the console

Value

data.frame


debarros/dbTools documentation built on Sept. 18, 2020, 10:51 a.m.