GridRange class

A range on a sheet.

All indexes are zero-based. Indexes are half open, i.e. the start index is inclusive and the end index is exclusive -- [start_index, end_index). Missing indexes indicate the range is unbounded on that side. For example, if "Sheet1" is sheet ID 123456, then: Sheet1!A1:A1 == sheet_id: 123456, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1 Sheet1!A3:B4 == sheet_id: 123456, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_column_index: 2 Sheet1!A:B == sheet_id: 123456, start_column_index: 0, end_column_index: 2 Sheet1!A5:B == sheet_id: 123456, start_row_index: 4, start_column_index: 0, end_column_index: 2 Sheet1 == sheet_id: 123456 The start index must always be less than or equal to the end index. If the start index equals the end index, then the range is empty. Empty ranges are typically not meaningful and are usually rendered in the UI as #REF!.

Constructors

GridRange({int? endColumnIndex, int? endRowIndex, int? sheetId, int? startColumnIndex, int? startRowIndex})
GridRange.fromJson(Map json_)

Properties

endColumnIndex int?
The end column (exclusive) of the range, or not set if unbounded.
getter/setter pair
endRowIndex int?
The end row (exclusive) of the range, or not set if unbounded.
getter/setter pair
hashCode int
The hash code for this object.
no setterinherited
runtimeType Type
A representation of the runtime type of the object.
no setterinherited
sheetId int?
The sheet this range is on.
getter/setter pair
startColumnIndex int?
The start column (inclusive) of the range, or not set if unbounded.
getter/setter pair
startRowIndex int?
The start row (inclusive) of the range, or not set if unbounded.
getter/setter pair

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toJson() Map<String, dynamic>
toString() String
A string representation of this object.
inherited

Operators

operator ==(Object other) bool
The equality operator.
inherited