A1Ref
Represents a reference to a range of cells in A1 notation.
The reference can be created from a string in A1 notation, a range object, or another A1Ref instance. The reference also includes optional workbook and sheet names, which can be provided in the context or parsed from the string.
The reference validates that the range is within the maximum allowed columns and rows.
Constructors
Section titled “Constructors”Constructor
Section titled “Constructor”new A1Ref(range: string | Range | A1Ref, context?: RefContext): A1Ref;Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
range | string | Range | A1Ref |
context | RefContext |
Returns
Section titled “Returns”A1Ref
Properties
Section titled “Properties”| Property | Type |
|---|---|
range | Range |
sheetName | string |
workbookName | string |
Accessors
Section titled “Accessors”bottom
Section titled “bottom”Get Signature
Section titled “Get Signature”get bottom(): number;Returns
Section titled “Returns”number
height
Section titled “height”Get Signature
Section titled “Get Signature”get height(): number;Returns
Section titled “Returns”number
Get Signature
Section titled “Get Signature”get left(): number;Returns
Section titled “Returns”number
Get Signature
Section titled “Get Signature”get right(): number;Returns
Section titled “Returns”number
Get Signature
Section titled “Get Signature”get top(): number;Returns
Section titled “Returns”number
Get Signature
Section titled “Get Signature”get width(): number;Returns
Section titled “Returns”number
Methods
Section titled “Methods”toString()
Section titled “toString()”toString(): string;Returns
Section titled “Returns”string