Skip to Content

Interface: IRange

Range data structure

One of the range types,

e.g., { startRow:0 , startColumn:0, endRow:1, endColumn:1, }

means “A1:B2”

Extends

Properties

PropertyTypeDescriptionInherited from

endAbsoluteRefType?

AbsoluteRefType

endColumn

number

The end column (exclusive) of the range endColumn

IColumnRange.endColumn

endRow

number

The end row (exclusive) of the range endRow

IRowRange.endRow

rangeType?

RANGE_TYPE

sheetId?

string

Id of the Worksheet the range belongs to. When this field is not defined, it should be considered as the range in the currently activated worksheet.

IColumnRange.sheetId

startAbsoluteRefType?

AbsoluteRefType

startColumn

number

The start column (inclusive) of the range startColumn

IColumnRange.startColumn

startRow

number

The start row (inclusive) of the range startRow

IRowRange.startRow

unitId?

string

Id of the Workbook the range belongs to. When this field is not defined, it should be considered as the range in the currently activated worksheet.

IColumnRange.unitId