Skip to content

load_workbook

Source code

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

library("xlcharts")

tmp <- write_xlsx(list(mysheet = iris))
load_workbook(filename = tmp)