3 sheets tagged with "cellranges":

This sample spreadsheet takes a worksheet of transaction data, and summarises and formats it using cell ranges. The user code in this example makes use of several of the features of cell ranges.

The idea of the spreadsheet is that we have a long list of individual transactions (the 'Transactions' worksheet). Each transaction is a trade of shares (either a buy or a sell) for a particular customer. We want to be able to summarise this, so that we can see the total trades for each customer and for each stock.

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

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.

Cell ranges can be sliced as if they were collections. You can use numbers and the names of header rows and cols in slices. Unlike worksheets, you can use negative numbers as either the start or end of a slice. Cell range 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.