load_workbook {xlcharts}

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)