API reference / Common / Engine types / GridCellRange

Interface: GridCellRange

A rectangular block of cells, inclusive on every edge, named by the ids of its corner rows and columns.

The parsed form of an A1-style range reference ("A1:F10") — from <mergeCell @ref>, an array formula's @ref, and the like. Its corners are ids, so the block follows its rows and columns: an insert between its first and last row grows it, one outside it moves it. A whole-column / whole-row / whole-sheet block runs from the first track of an axis to its last, exactly as Excel's C:C means C1:C1048576.

Properties

Property	Description
firstRow string	The topmost row.
firstCol string	The leftmost column.
lastRow string	The bottommost row.
lastCol string	The rightmost column.