How to build a spreadsheet with Python
summary
Claims a working Python spreadsheet engine based on the open‑sourced Dirigible, starting from a 2×2 grid and building cell objects with a formula/value split, rewriting Excel‑style references into Python (AST/recursive rewriting), constructing a bidirectional dependency graph with cycle detection, and letting users exec pre/post custom code. Live demos mostly work; repo omits the production eval sandboxing used for safety. Practical takeaway: it’s doable, but for data analysis prefer IPython/pandas.
AI-written summary · about
chapters (9)
- 0:00Introduction to project
- 1:03Setting up the data model
- 2:51Implementing basic formulas
- 5:51Parsing cell references
- 8:31Building dependency graphs
- 12:24Custom Python functions
- 14:25Advanced execution context
- 16:55The final pythonic approach
- 19:43Q&A session
related talks
01h 50mSpreadsheet-Driven Meta-Programming for Python
39mPython & Spreadsheets: 2017 Edition
34mHomoiconic spreadsheets: What, How & Why
02h 52mFrom Spreadsheets to DataFrames
37mPowering Energy Storage Beyond Excel
45mEdit Excel and Google Spreadsheets with Python: An Introduction
11mThink Inside the Box(es) Excel-Hosted Dashboards With Python Graphics
49mUntitled13.ipynb