read_excel_flex: Flexible Excel reader

In evanverse: Utility Functions for Data Analysis and Visualization

Flexible Excel reader

Description

Read an Excel sheet via readxl::read_excel() with optional column-name cleaning (janitor::clean_names()), basic type control, and CLI messages.

Usage

read_excel_flex(
  file_path,
  sheet = 1,
  skip = 0,
  header = TRUE,
  range = NULL,
  col_types = NULL,
  clean_names = TRUE,
  guess_max = 1000,
  trim_ws = TRUE,
  na = "",
  verbose = TRUE
)

Arguments

file_path	Path to the Excel file (.xlsx or .xls).
sheet	Sheet name or index to read (default: 1).
skip	Number of lines to skip before reading data (default: 0).
header	Logical. Whether the first row contains column names (default: TRUE).
range	Optional cell range (e.g., "B2:D100"). Default: NULL.
col_types	Optional vector specifying column types; passed to readxl.
clean_names	Logical. Clean column names with janitor::clean_names() (default: TRUE).
guess_max	Max rows to guess column types (default: 1000).
trim_ws	Logical. Trim surrounding whitespace in text fields (default: TRUE).
na	Values to interpret as NA (default: "").
verbose	Logical. Show CLI output (default: TRUE).

Value

A tibble (or data.frame) read from the Excel sheet.

evanverse documentation built on March 10, 2026, 5:07 p.m.