vimsheet.io.xlsx_adapter

Excel .xlsx import/export via openpyxl.

class vimsheet.io.xlsx_adapter.XLSXAdapter

Bases: FormatAdapter

Read and write Excel .xlsx files.

supported_extensions: list[str] = ['.xlsx', '.xlsm']

can_read_formulas: bool = True

can_write_formulas: bool = True

multi_sheet: bool = True

read(path, **opts)

Read path and return a populated Workbook.

Parameters:

• path (Path)

• opts (object)

Return type:

Workbook

write(workbook, path, **opts)

Serialise workbook to path.

Parameters:

• workbook (Workbook)

• path (Path)

• opts (object)

Return type:

None