Class RangeAddress

Class that represents address of the range.

Inheritance
System.Object
RangeAddress
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

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

true if the specified cell falls within this RangeAddress

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.