load_workbook: load_workbook

In xlcharts: Create Native 'Excel' Charts and Work with Microsoft 'Excel' Files

load_workbook

Description

Open the given filename and return the workbook

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

Usage

load_workbook(
  filename,
  read_only = FALSE,
  keep_vba = FALSE,
  data_only = FALSE,
  keep_links = TRUE,
  rich_text = FALSE,
  ...
)

Arguments

filename	filename string or a file-like object open in binary mode c.f., :class:'zipfile.ZipFile' :param read_only: optimised for reading, content cannot be edited
read_only	read_only bool
keep_vba	keep_vba preserve vba content (this does NOT mean you can use it)
data_only	data_only bool
keep_links	keep_links whether links to external workbooks should be preserved. The default is TRUE
rich_text	rich_text bool :rtype: :class:'openpyxl.workbook.Workbook' .. note:: When using lazy load, all worksheets will be :class:'openpyxl.worksheet.iter_worksheet.IterableWorksheet' and the returned workbook will be read-only.
...	Additional arguments, i.e. kwargs.

Value

An openpyxl Python object.

Examples

## Not run: 
tmp <- write_xlsx(list(mysheet = iris))
load_workbook(filename = tmp)

## End(Not run)

xlcharts documentation built on May 29, 2024, 7:58 a.m.