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
3
4
5
6
7
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 Jan. 2, 2021, 4:06 a.m.