Persistent Cells and Worksheets

Some calculations take a long time, and rather than having to repeat them every time you open the spreadsheet you may want to store the results and only redo the calculation if some of your data changes.

This is actually two examples of persisting and reloading data into a worksheet from an external file. It uses the Python marshal library which is capable of serializing (storing) arbitrary Python objects including the basic types like numbers and strings.

The first example stores the data from a single cell, whilst the second example stores all the data in a worksheet.

This spreadsheet was created for the Resolver Hacks website, and not by Resolver Systems.