CrabXL for Python

InstallCopy Anchor Link

python -m pip install --pre crabxl

Wheels are available for CPython 3.11–3.15 on Linux, Windows and macOS.

UseCopy Anchor Link

Import crabxl in place of openpyxl. The calls are the same.

import crabxl as openpyxl

book = openpyxl.load_workbook("input.xlsx")
book.active["A1"] = "Updated"
book.save("output.xlsx")
book.close()

LimitsCopy Anchor Link

• An unsupported call raises NotImplementedError. CrabXL does not fall back to openpyxl.
• load_workbook and save accept a path only. File-like objects are not supported.
• To open an .xlsm or .xltm file, set keep_vba=True.
• CrabXL does not calculate formulas. With data_only=True, a formula cell contains the cached result from the file.