read.xlsx.all: Read an entire Excel file workbook (using openxlsx functions)

Description Usage Arguments Value

View source: R/read.xlsx.all.R

Description

Read an entire Excel file workbook (using openxlsx functions)

Usage

1
2
read.xlsx.all(xlsxFile, save2env = FALSE, names = "", startRow = 1,
  detectDates = TRUE)

Arguments

xlsxFile

Path to the xls/xlsx file

save2env

Either TRUE to save each worksheet to the environment or FALSE to return a list of worksheets, which can be saved to the environment

names

A vector of character data representing preferred sheet names

startRow

first row to begin looking for data. Empty rows at the top of a file are always skipped, regardless of the value of startRow.

detectDates

If TRUE, attempt to recognise dates and perform conversion.

Value

If there is more than one worksheet, then a list of data frames that represent each worksheet. If there is only one worksheet, then a data frame.


samuelkaminsky/SKTools documentation built on July 15, 2018, 7:51 p.m.