Skip to content

ExcelReader

Source code

Description

Read an Excel package and dispatch the contents to the relevant modules

https://openpyxl.readthedocs.io/en/stable/api/openpyxl.reader.excel.html

Usage

ExcelReader(
  fn,
  read_only = FALSE,
  keep_vba = FALSE,
  data_only = FALSE,
  keep_links = TRUE,
  rich_text = FALSE,
  ...
)

Arguments

fn fn
read_only read_only
keep_vba keep_vba
data_only data_only
keep_links keep_links
rich_text rich_text
Additional arguments, i.e. kwargs.

Value

An openpyxl Python object.

Examples

library("xlcharts")

tmp <- write_xlsx(list(mysheet = iris))
ExcelReader(fn = tmp)