excel-grapher
Build and analyze dependency graphs from Excel workbooks, evaluate formulas with Excel semantics, and export standalone Python code.
Documentation: https://teal-insights.github.io/excel-grapher/
Why this exists
- Transpilation support: trace formula dependencies to enable Excel → Python translation.
- Interpretability: visualize and sanity-check spreadsheet logic (GraphViz, Mermaid, NetworkX).
- Performance-minded: focuses on targeted dependency closure from specific output cells/ranges.
- Excel semantics in Python: run workbook logic in-process with a full Excel-like evaluator.
- Exportable: emit standalone Python packages that embed only the runtime surface you need.
Library layout
The unified distribution is excel-grapher and exposes a single import package, excel_grapher, with five main subpackages:
excel_grapher/core/— shared semantic types, coercions, and scalar operators.excel_grapher/runtime/— Excel-equivalent function implementations and runtime semantics.excel_grapher/grapher/— workbook loading, graph extraction, Excel write-back, and visualization logic.excel_grapher/evaluator/—FormulaEvaluator: an Excel emulator for recomputing formulas in the extracted graph in Python.excel_grapher/exporter/—CodeGenerator: an transpiler for exporting the extracted graph as a standalone Python library.
Typical imports:
from excel_grapher.grapher import create_dependency_graph, DependencyGraph
from excel_grapher.evaluator import FormulaEvaluator
from excel_grapher.exporter import CodeGenerator
from excel_grapher.core import XlError # and other shared types, if needed
Installation
Released under the MIT license. Install from GitHub:
Using uv (recommended):
# Basic install (NumPy-free)
uv add git+https://github.com/Teal-Insights/excel-grapher
# With vectorized operator / SUMPRODUCT acceleration
uv add "excel-grapher[fast] @ git+https://github.com/Teal-Insights/excel-grapher"
# With NetworkX support
uv add "excel-grapher[networkx] @ git+https://github.com/Teal-Insights/excel-grapher"
# With all optional dependencies (includes `fast`)
uv add "excel-grapher[all] @ git+https://github.com/Teal-Insights/excel-grapher"
Using pip:
pip install git+https://github.com/Teal-Insights/excel-grapher
# With extras:
pip install "excel-grapher[fast] @ git+https://github.com/Teal-Insights/excel-grapher"
pip install "excel-grapher[networkx] @ git+https://github.com/Teal-Insights/excel-grapher"
pip install "excel-grapher[all] @ git+https://github.com/Teal-Insights/excel-grapher"
The default install is correct without NumPy. Install the fast extra when
evaluating large workbooks and you want vectorized operator / SUMPRODUCT
acceleration. Exported standalone code stays NumPy-free either way.
High-level usage
The library supports a three-stage pipeline, plus Excel write-back of the same graph views used for Python export:
- Build a dependency graph from an Excel workbook (
excel_grapher.grapher). - Evaluate formulas with Excel semantics over that graph (
excel_grapher.evaluator.FormulaEvaluator). - Export standalone Python (
excel_grapher.exporter.CodeGenerator) and/or a new.xlsxfrom the sameGraphReadView(excel_grapher.grapher.write_workbook).
A minimal end‑to‑end example:
from pathlib import Path
from excel_grapher.grapher import create_dependency_graph, write_workbook
from excel_grapher.evaluator import FormulaEvaluator
from excel_grapher.exporter import CodeGenerator
workbook_path = Path("model.xlsx")
targets = ["Sheet1!A10"]
# 1) Build a dependency graph
graph = create_dependency_graph(workbook_path, targets, load_values=True)
print(len(graph)) # number of visited nodes
# 2) Evaluate with Excel semantics
with FormulaEvaluator(graph) as ev:
results = ev.evaluate(targets)
# 3a) Export standalone Python code
code = CodeGenerator(graph).generate(targets)
# 3b) Write a new workbook from the graph (or a ProjectionResult)
write_workbook(graph, Path("edited.xlsx"))
Series bindings
Optional sidecar manifests (.bindings.yaml) declare structured input/output APIs for exported
code — set_* and compute_* functions over Records. Validate sidecars from the shell with
excel-grapher bindings validate. See the
Series bindings guide
and Code export guide.
User guide
Detailed documentation lives in the User Guide:
| Topic | Page |
|---|---|
| Dependency graphs | Read guide |
| Visualization | Read guide |
| Formula evaluation | Read guide |
| End-to-end demo | Read guide |
| Series bindings | Read guide |
| Code export | Read guide |
| Parity testing | Read guide |
| Contributing | Read guide |
Examples
Hands-on walkthroughs (Markdown on GitHub):
| Topic | Walkthrough |
|---|---|
| Graph extraction | extraction_basics.md |
| Code generation | codegen_basics.md |
| Series bindings | series_bindings.md |
| Induced graph | induced_graph.md |
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file excel_grapher-13.7.1.tar.gz.
File metadata
- Download URL: excel_grapher-13.7.1.tar.gz
- Upload date:
- Size: 6.1 MB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
85c6784ec89de11f89feb38fe2a8da57f44f20e17e0b088351cd8f2f310cba4e
|
|
| MD5 |
1b56cbe87396f946334bfb1b65e1554b
|
|
| BLAKE2b-256 |
6df0338f552f882c5bde7b930d6e6820852bc64937099c1a1b063a2c2a7452a4
|
Provenance
The following attestation bundles were made for excel_grapher-13.7.1.tar.gz:
Publisher:
publish.yml on Teal-Insights/excel-grapher
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
excel_grapher-13.7.1.tar.gz -
Subject digest:
85c6784ec89de11f89feb38fe2a8da57f44f20e17e0b088351cd8f2f310cba4e - Sigstore transparency entry: 2731522812
- Sigstore integration time:
-
Permalink:
Teal-Insights/excel-grapher@94b39618e44659e839e7288414466774485efe14 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/Teal-Insights
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@94b39618e44659e839e7288414466774485efe14 -
Trigger Event:
push
-
Statement type:
File details
Details for the file excel_grapher-13.7.1-py3-none-any.whl.
File metadata
- Download URL: excel_grapher-13.7.1-py3-none-any.whl
- Upload date:
- Size: 527.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
8ec2a9811ce2f2bc0983d96f00e2ece07381e799ae8d33bdf66f34a3acd94a2d
|
|
| MD5 |
8a65cd10fefc8d5979c84666b9ff4caa
|
|
| BLAKE2b-256 |
8d320f678c95bc08df38198d5f2a7dbacfd4881a37657b293a23b01784c7ecc5
|
Provenance
The following attestation bundles were made for excel_grapher-13.7.1-py3-none-any.whl:
Publisher:
publish.yml on Teal-Insights/excel-grapher
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
excel_grapher-13.7.1-py3-none-any.whl -
Subject digest:
8ec2a9811ce2f2bc0983d96f00e2ece07381e799ae8d33bdf66f34a3acd94a2d - Sigstore transparency entry: 2731524122
- Sigstore integration time:
-
Permalink:
Teal-Insights/excel-grapher@94b39618e44659e839e7288414466774485efe14 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/Teal-Insights
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@94b39618e44659e839e7288414466774485efe14 -
Trigger Event:
push
-
Statement type:
