setup_XLSXIngest: Set up an XLSXIngestConfig
Description
Creates the settings ingest() uses to read a spreadsheet.
Usage
setup_XLSXIngest(
columns = NULL,
character2factor = TRUE,
clean_colnames = TRUE,
remove_duplicates = FALSE,
sheet = 1L,
na_strings = ""
)
Value
XLSXIngestConfig object.
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 the declared type after reading, replacing the type the
reader assigned.
- 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.