Class RangeAddress
Class that represents address of the range.
Inheritance
Namespace: IronXL
Assembly: IronXL.dll
Syntax
public class RangeAddress : ObjectProperties
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. |