zut.excel.ExcelWorkbook

class zut.excel.ExcelWorkbook(path: str | PathLike, *, formula=<object object>, save_as: str | PathLike | None = None)

Bases: object

__init__(path: str | PathLike, *, formula=<object object>, save_as: str | PathLike | None = None)

• formula: value to return if a cell is a formula. If not set, return the formula itself (starting with ‘=’).

• save_as: save at this path instead of the original path.

Methods

__init__(path, *[, formula])
close()
close_all()
create_table(name[, no_headers])
get_global_named_value(name)
get_global_named_values(name)
get_instance(path, *[, formula])
get_or_create_table(name[, no_headers])	Return (table, created).
get_table(-> ~zut.excel.ExcelTable)
save(*[, save_as])

Attributes

pyxl_workbook

get_or_create_table(name: str, no_headers: bool = False) → tuple[ExcelTable, bool]

Return (table, created).