xlsx2list: Read all sheets of an XLSX file into a list
In egenn/rtemis: Machine Learning and Visualization

xlsx2list

R Documentation

Read all sheets of an XLSX file into a list

Description

Read all sheets of an XLSX file into a list

Usage

xlsx2list(
  x,
  sheet = NULL,
  startRow = 1,
  colNames = TRUE,
  na.strings = "NA",
  detectDates = TRUE,
  skipEmptyRows = TRUE,
  skipEmptyCols = TRUE
)

Arguments

`x`	Character: path or URL to XLSX file
`sheet`	Integer, vector: Sheet(s) to read. If NULL, will read all sheets in `x`
`startRow`	Integer, vector: First row to start reading. Will be recycled as needed for all sheets
`colNames`	Logical: If TRUE, use the first row of data
`na.strings`	Character vector: stringd to be interpreted as NA
`detectDates`	Logical: If TRUE, try to automatically detect dates
`skipEmptyRows`	Logical: If TRUE, skip empty rows
`skipEmptyCols`	Logical: If TRUE, skip empty columns