xlsx2list: Read all sheets of an XLSX file into a list

In egenn/rtemis: Machine Learning and Visualization

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

Author(s)

E.D. Gennatas

egenn/rtemis documentation built on May 4, 2024, 7:40 p.m.