The __file__ variable provides a convenient way to access files stored relative to the directory your spreadsheet is in. This snippet shows you how to use it.

Apparently, when you have a grid of data, wanting to color alternate rows differently is common. It makes it easier to read, or something like that. As always this is easy to do in Resolver One.

CellRanges are enormously handy when it comes to using or presenting blocks of data. Here are a couple of functions that make creating and adding borders to them even easier.

The best way to use code shared between several spreadsheets is to develop it as a Python module. This function reloads modules every time a spreadsheet is recalculated, so that you can pick up the latest version of your code whilst you are testing it inside a spreadsheet.

Keeping spreadsheet modules in the same directory as your spreadsheets can be a nuisance. Using the IRONPYTHONPATH environment variable you can keep all your modules in a single directory and still import them in your spreadsheets.

Placing buttons on the grid is a useful way of building functionality into your spreadsheets. This snippet shows how to do it, using a recalculate button as an example.

A hack showing you how to access the main spreadsheet namespace (and objects) from inside module code.

Virtual worksheets are worksheets that only exist in code, and are not shown in the grid. This technique allows you to create 'scratchpad' worksheets, for storing intermediate values, without exposing them to the user. Once created we can use a CellRange and the CopyRange function to copy interesting data back to a visible worksheet.