setup_XLSXIngest: Set up an 'XLSXIngestConfig'

View source: R/047_IngestConfig.R

setup_XLSXIngestR Documentation

Set up an XLSXIngestConfig

Description

Reading a spreadsheet. A workbook holds several tables, so which one is the only thing that must be said.

Usage

setup_XLSXIngest(
  columns = NULL,
  character2factor = TRUE,
  clean_colnames = TRUE,
  remove_duplicates = FALSE,
  sheet = 1L,
  na_strings = ""
)

Arguments

columns

Optional Named vector: Declared column types, keyed by column name, in the profile/r/v1 vocabulary – c(Age = "integer"). A column named here is converted to that type after reading, so a known type takes precedence over the reader's inference.

character2factor

Logical: If TRUE, read character columns as factors.

clean_colnames

Logical: If TRUE, normalize column names.

remove_duplicates

Logical: If TRUE, drop rows repeating an earlier row.

sheet

Integer [1, Inf): Sheet number to read.

na_strings

Character vector: Strings to read as missing.

Value

XLSXIngestConfig object.

Author(s)

EDG

Examples

setup_XLSXIngest(sheet = 2L)

rtemis documentation built on Oct. 20, 2026, 1:06 a.m.