Handling Data Model
From Documentation
Spreadsheet data model is the place where all Spreadsheet cell data stores. Spreadsheet is like a painter which paints its data model in grid-like layout for you. Every action you take on a Spreadsheet (e.g. insertion or deletion) involves a change to its data model. The following sections introduce those APIs to handle a Spreadsheet data model by corresponding user action.
For each cell/row/column operation, you need to get a Range object. The helper class Ranges supports various methods to create a Range object like:
All source code listed in this book is at Github.