Where does RangeAddress live in the IronXL API?

RangeAddress is a class in the IronXL namespace, shipped in IronXL.dll, and derives from Object. A Range exposes its own bounds through the RangeAddress property.

How do you get the size of a range in C#?

Read RowsCount and ColumnsCount on the Range.RangeAddress. FirstRow, FirstColumn, LastRow, and LastColumn give the four corners of the block as numbers.

How do you find where two ranges overlap with IronXL?

Call GetIntersection on one RangeAddress, passing another, to get the overlapping region as a new RangeAddress. Includes checks whether a single row and column fall inside, and IsEqual tests whether two addresses match.

Class RangeAddress

Class that represents address of the range.

Inheritance

System.Object

RangeAddress

Namespace: IronXL

Assembly: IronXL.dll

Syntax

public class RangeAddress : Object

The location and size of a cell block in C#, the bounds behind a selection like A1:C10, are what RangeAddress describes. It captures the first and last rows and columns of a range as a structured value, so code can ask where a range sits, how big it is, and whether two ranges overlap without re-parsing address strings. A developer reaches for it when a range's position matters as data, not just its cells.

Every Range exposes its bounds through the RangeAddress property, which is the usual way to obtain one. From there FirstRow, FirstColumn, LastRow, and LastColumn give the four corners as numbers, and RowsCount and ColumnsCount report the dimensions. Location returns the address in a string form, and ToString does the same for display or logging.

The comparison members answer the geometry questions that come up when ranges interact. Includes tests whether a given row and column fall inside the address, IsEqual checks whether two addresses cover the same cells, and GetIntersection returns the overlapping region of two ranges as a new RangeAddress. Extend grows an address to also cover another one, which is useful when merging adjacent selections. Reading these bounds does not change the underlying cells, since a RangeAddress describes a region rather than holding the data inside it, so it pairs with the Range it came from rather than replacing it.

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.GetWorkSheet("Sheet1");
RangeAddress address = workSheet["A1:C10"].RangeAddress;
Console.WriteLine(address.RowsCount);
Console.WriteLine(address.ColumnsCount);

The select range how-to covers building ranges, the combine ranges example joins selections, and the trim cell range how-to narrows one.

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.