Class RangeAddress
Class that represents address of the range.
Inheritance
Namespace: IronXL
Assembly: IronXL.dll
Syntax
public class RangeAddress : Object
Properties
ColumnsCount
Amount of columns within this address.
Declaration
public int ColumnsCount { get; }
Property Value
Type | Description |
---|---|
System.Int32 |
FirstColumn
Index of the first column within this address.
Declaration
public int FirstColumn { get; }
Property Value
Type | Description |
---|---|
System.Int32 |
FirstRow
Index of the first row within this address.
Declaration
public int FirstRow { get; }
Property Value
Type | Description |
---|---|
System.Int32 |
LastColumn
Index of the last column within this address.
Declaration
public int LastColumn { get; }
Property Value
Type | Description |
---|---|
System.Int32 |
LastRow
Index of the last row within this address.
Declaration
public int LastRow { get; }
Property Value
Type | Description |
---|---|
System.Int32 |
Location
Gets the Range / Cells location in Excel Address selector notation. E.G. "A1:B16"
Declaration
public string Location { get; }
Property Value
Type | Description |
---|---|
System.String | The Range's location expressed as an Excel Address selector string. |
RowsCount
Amount of rows within this address.
Declaration
public int RowsCount { get; }
Property Value
Type | Description |
---|---|
System.Int32 |
Methods
Extend(RangeAddress)
Combines two range addresses. The result is range address where the last column and the last row have maximum values among two combined addresses.
Declaration
public RangeAddress Extend(RangeAddress rangeAddress)
Parameters
Type | Name | Description |
---|---|---|
RangeAddress | rangeAddress | The range address. |
Returns
Type | Description |
---|---|
RangeAddress | The result range address. |
Includes(Int32, Int32)
Check whether this range address contains target cell.
Declaration
public bool Includes(int row, int col)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | row | The row of the cell. zero based. |
System.Int32 | col | The column of the cell. zero based. E.g. column A is 0 |
Returns
Type | Description |
---|---|
System.Boolean |
|
IsEqual(RangeAddress)
Checks whether two ranges are equal.
Declaration
public bool IsEqual(RangeAddress range)
Parameters
Type | Name | Description |
---|---|---|
RangeAddress | range |
Returns
Type | Description |
---|---|
System.Boolean |
ToString()
Converts to string of the location of the range in Excel Address selector notation. E.G. "A4:D87"
Declaration
public override string ToString()
Returns
Type | Description |
---|---|
System.String | A System.String that represents this instance. |