Building a language for spreadsheet refactoring
|Session Type||Experience Report|
Spreadsheets are code too! You have constants, variable, functions and conditional statements, everything you need to build anything you want. If you really want it, you can even build a Turing machine with Excel. So if spreadsheets are code, can we also analyse, test and refactor them? Felienne thinks so. In this talk, she discusses her latest spreadsheet tool: BumbleBee. BumbleBee allows users to refactor and even metaprogram their spreadsheet. For this, Felienne designed a language in which the transformations can be described and built a pattern matcher in F# to transform spreadsheet formulas.
Felienne Hermans (Delft University of Technology)
Felienne Hermans is a computer scientist. During her PhD project, she researched the applicability of clone and smell detection to spreadsheets, and founded a spin off based on this idea. Now a professor, she continues her mission to improve spreadsheets in the wild using software engineering methods. In her spare time, Felienne volunteers as a referee for the First Lego League, a world wide technology competition for kids.
In its 8th year, Code Generation 2014 is Europe’s leading conference on Domain-Specific Languages, Language Workbenches, Model-Driven Software Development and Code Generation, set in picturesque Cambridge.
If you are interested in sponsoring the event by creating a unique package, or by choosing an off-the-shelf sponsorship package, please contact us for further details.