read.simple.xlsx: Read a multi-sheet XLSX easily

In vertesy/ReadWriter: ReadWriter

Read a multi-sheet XLSX easily

Description

Reads specified sheets from an XLSX file into a list of data frames. It allows customization of column names, row names, and trimming of white spaces.

Usage

read.simple.xlsx(
  pfn = Stringendo::kollapse(...),
  which_sheets,
  col_names = TRUE,
  row_names = FALSE,
  trim_ws = TRUE,
  ...
)

Arguments

pfn	Path and filename of the XLSX file. Default: Constructed using Stringendo::kollapse(...).
which_sheets	Indices or names of sheets to read from the XLSX file. Default: All sheets.
col_names	Logical, whether to use the first row as column names. Default: TRUE.
row_names	Numeric, whether to convert a column to row names. Default: 1. Use 0 for no conversion. Default: FALSE.
trim_ws	Logical, whether to trim white spaces from column names.
...	Pass arguments to read.xlsx().

Value

A list of data frames, each representing a sheet from the XLSX file.

See Also

read.xlsx

vertesy/ReadWriter documentation built on Nov. 24, 2024, 10:40 p.m.