Learn R Programming

xlcharts (version 0.0.1)

load_workbook: 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,
  ...
)

Value

An openpyxl Python object.

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.

Examples

Run this code
if (FALSE) {
tmp <- write_xlsx(list(mysheet = iris))
load_workbook(filename = tmp)
}

Run the code above in your browser using DataLab