Class ExcelAddressBase

A range address

Inheritance

System.Object

ExcelCellBase

ExcelAddressBase

ExcelAddress

Inherited Members

ExcelCellBase.GetAddress(Int32, Int32)

ExcelCellBase.GetAddress(Int32, Boolean, Int32, Boolean)

ExcelCellBase.GetAddress(Int32, Int32, Boolean)

ExcelCellBase.GetAddress(Int32, Int32, Int32, Int32)

ExcelCellBase.GetAddress(Int32, Int32, Int32, Int32, Boolean)

ExcelCellBase.GetFullAddress(String, String)

ExcelCellBase.IsValidCellAddress(String)

ExcelCellBase.TranslateFromR1C1(String, Int32, Int32)

ExcelCellBase.TranslateToR1C1(String, Int32, Int32)

ExcelCellBase.GetColumnLetter(Int32)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Experior.Core.Data.OfficeOpenXml

Assembly: Experior.Core.dll

Syntax

public class ExcelAddressBase : ExcelCellBase

Remarks

Examples of addresses are "A1" "B1:C2" "A:A" "1:1" "A1:E2,G3:G5"

Constructors

ExcelAddressBase(Int32, Int32, Int32, Int32)

Creates an Address object

Declaration

public ExcelAddressBase(int fromRow, int fromCol, int toRow, int toColumn)

Parameters

Type	Name	Description
System.Int32	fromRow	start row
System.Int32	fromCol	start column
System.Int32	toRow	End row
System.Int32	toColumn	End column

ExcelAddressBase(String)

Creates an Address object

Declaration

public ExcelAddressBase(string address)

Parameters

Type	Name	Description
System.String	address	The Excel Address

Remarks

Examples of addresses are "A1" "B1:C2" "A:A" "1:1" "A1:E2,G3:G5"

Fields

_address

Declaration

protected string _address

Field Value

Type	Description
System.String

_fromCol

Declaration

protected int _fromCol

Field Value

Type	Description
System.Int32

_fromRow

Declaration

protected int _fromRow

Field Value

Type	Description
System.Int32

_toCol

Declaration

protected int _toCol

Field Value

Type	Description
System.Int32

_toRow

Declaration

protected int _toRow

Field Value

Type	Description
System.Int32

_wb

Declaration

protected string _wb

Field Value

Type	Description
System.String

_ws

Declaration

protected string _ws

Field Value

Type	Description
System.String

Properties

Address

The address for the range

Declaration

public virtual string Address { get; }

Property Value

Type	Description
System.String

End

Gets the row and column of the bottom right cell.

Declaration

public ExcelCellAddress End { get; }

Property Value

Type	Description
ExcelCellAddress	The end row column.

IsName

If the address is a defined name

Declaration

public bool IsName { get; }

Property Value

Type	Description
System.Boolean

Start

Gets the row and column of the top left cell.

Declaration

public ExcelCellAddress Start { get; }

Property Value

Type	Description
ExcelCellAddress	The start row column.

Methods

GetAddress(String, String, String)

Declaration

protected string GetAddress(string wb, string ws, string address)

Parameters

Type	Name	Description
System.String	wb
System.String	ws
System.String	address

Returns

Type	Description
System.String

SetAddress(String)

Declaration

protected void SetAddress(string address)

Parameters

Type	Name	Description
System.String	address

ToString()

Declaration

public override string ToString()

Returns

Type	Description
System.String

Overrides

System.Object.ToString()

Validate()

Validate the address

Declaration

protected void Validate()

Events

AddressChange

Declaration

protected event EventHandler AddressChange

Event Type

Type	Description
System.EventHandler