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