2 sheets tagged with "worksheets":

Header rows and columns make it easier to access data in both worksheets and cellranges; using header names rather than row / column references. This makes your spreadsheets easier to understand and easier to maintain.

This spreadsheet demonstrates using headers, along with named ranges as an easy way of creating cell ranges from the user interface.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

The Resolver One object model uses an API that allow spreadsheet objects to be treated as ordinary Python objects as much as possible - making them natural to work with from user code and even formulae.

Worksheets can be sliced as if they were collections. You can use numbers and the names of header rows and cols in slices. You cannot use negative numbers as either the start or end of a slice (they don't make sense since worksheets are infinite). In formulae, the colons are replaced by arrows, because colons are already used to specify cell ranges, eg. '=lst[1 -> 4]'. Worksheet slicing is right-exclusive. It may seem little counter-intuitive, especially when you use names from headers, but it's consistent with Python slicing.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.