Python Quickstart

1) Install

pip install formualizer

2) Evaluate a formula

import formualizer as fz

wb = fz.Workbook()
wb.add_sheet("Sheet1")

wb.set_value("Sheet1", 1, 1, 100)
wb.set_value("Sheet1", 2, 1, 20)
wb.set_formula("Sheet1", 1, 2, "=A1-A2")

result = wb.evaluate_cell("Sheet1", 1, 2)
print(result)  # 80.0

3) Try the binding example in this repo

python bindings/python/examples/custom_function_registration.py

Running in the browser (Pyodide)

Formualizer also ships a Pyodide-tagged wheel — await micropip.install("formualizer") works inside a Pyodide runtime with the same API shown above. See the Pyodide Quickstart for install, UDF, and XLSX-byte examples, plus the handful of platform-specific defaults.

Next

• Formula Parser
• Evaluate Excel formulas in Python — capability tour, comparison table, and write-back recipe for the Python bindings
• First Workbook in 5 Minutes
• Pyodide Quickstart
• Custom Functions (Rust, Python, JS)
• Deterministic Testing
• openpyxl can't calculate formulas — the full recipe — authoring with openpyxl, calculating with formualizer, and writing cached values back into the xlsx