Module zut.excel

Manipulate Excel tables.

Functions

is_excel_path(path, *[, accept_table_suffix])

Return True if path is a str or Path object ending with .xlsx (case-insensitive), or, if accept_table_suffix is set to True, return true if path ends with .xlsx:Table where Table is the name of a table.

split_excel_path(path, *[, default_table_name])

Return tuple (workbook_path, table_name) from an Excel path (using default_table_name if the Excel path does not end with :Table).

Classes

ExcelRow(table, index, *[, readonly])

ExcelTable(pyxl_table, pyxl_worksheet, workbook)

ExcelWorkbook(path, *[, formula])