Brussels / 31 January & 1 February 2015


Let's build a spreadsheet app in Python

A tour of the (remarkably simple) code you need to build a fully-functional Pythonic spreadsheet

Building a spreadsheet app with Python is simpler than you think! I'll show you how we can build one with Python, from the ground up, in 15 minutes or less. Fun times with recursion guaranteed.

Have you ever wondered how a spreadsheet works? I was fairly #mindblown when someone first explained it to me on the back of a beermat -- it's simpler than I thought! Let me take you on a tour of the source code for Project Dirigible, an experimental web port of Resolver One, the (sadly defunct) Pythonic spreadsheet. We'll cover formula parsing, identifying dependencies, building the recalculation graph, loop detection, and even some of the mind-bending fun that Dirigible lets you do with user-defined functions.


Photo of Harry Percival Harry Percival