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
Equals(Object)
Compares two ranges.
Declaration
public override bool Equals(object obj)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | obj | The range to compare with the current range. |
Returns
| Type | Description |
|---|---|
| System.Boolean |
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. |
GetHashCode()
Gets the hash code of this instance.
Declaration
public override int GetHashCode()Returns
| Type | Description |
|---|---|
| System.Int32 |
GetIntersection(RangeAddress)
Gets the intersection of two ranges. Returns null if the ranges do not intersect.
Declaration
public RangeAddress GetIntersection(RangeAddress range)Parameters
| Type | Name | Description |
|---|---|---|
| RangeAddress | range |
Returns
| Type | Description |
|---|---|
| RangeAddress |
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. |