Class ExcelAddress

Namespace

OfficeOpenXml

Assembly

EPPlus.dll

Range address with the address property readonly

public class ExcelAddress : ExcelAddressBase

Inheritance

object

ExcelCellBase

ExcelAddressBase

ExcelAddress

Derived

ExcelDatavalidationAddress

ExcelRangeBase

Inherited Members

ExcelAddressBase.SetAddress(string, ExcelWorkbook, string)

ExcelAddressBase.BeforeChangeAddress()

ExcelAddressBase.ChangeAddress()

ExcelAddressBase.ToString()

ExcelAddressBase.GetHashCode()

ExcelAddressBase.Validate()

ExcelAddressBase.Equals(object)

ExcelAddressBase.Start

ExcelAddressBase.End

ExcelAddressBase.ExternalReferenceIndex

ExcelAddressBase.Table

ExcelAddressBase.AddressAbsolute

ExcelAddressBase.FullAddress

ExcelAddressBase.IsName

ExcelAddressBase.Rows

ExcelAddressBase.Columns

ExcelAddressBase.IsFullRow

ExcelAddressBase.IsFullColumn

ExcelAddressBase.LocalAddress

ExcelAddressBase.IsExternal

ExcelCellBase.TranslateFromR1C1(string, int, int)

ExcelCellBase.TranslateToR1C1(string, int, int)

ExcelCellBase.GetColumnLetter(int)

ExcelCellBase.GetColumnLetter(int, bool)

ExcelCellBase.GetAddressRow(int, bool)

ExcelCellBase.GetAddressCol(int, bool)

ExcelCellBase.GetAddress(int, int)

ExcelCellBase.GetAddress(int, bool, int, bool)

ExcelCellBase.GetAddress(int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int)

ExcelCellBase.GetAddress(int, int, int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int, bool, bool, bool, bool)

ExcelCellBase.GetFullAddress(string, string)

ExcelCellBase.GetFullAddress(string, string, string)

ExcelCellBase.IsSimpleAddress(string)

ExcelCellBase.IsValidAddress(string)

ExcelCellBase.IsValidTableAddress(string)

ExcelCellBase.IsValidRangeAddress(string)

ExcelCellBase.IsValidCellAddress(string)

object.GetType()

object.MemberwiseClone()

object.Equals(object, object)

object.ReferenceEquals(object, object)

Constructors

ExcelAddress(int, int, int, int)

Constructor

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

Parameters

fromRow int

From row

fromCol int

From column

toRow int

To row

toColumn int

To column

ExcelAddress(string)

Constructor

public ExcelAddress(string address)

Parameters

address string

The Excel address

ExcelAddress(string, ExcelPackage, ExcelAddressBase)

Creates an Address object

public ExcelAddress(string Address, ExcelPackage package, ExcelAddressBase referenceAddress)

Parameters

Address string

The Excel Address

package ExcelPackage

Reference to the package to find information about tables and names

referenceAddress ExcelAddressBase

The address

Remarks

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

ExcelAddress(string, int, int, int, int)

Constructor

public ExcelAddress(string ws, int fromRow, int fromCol, int toRow, int toColumn)

Parameters

ws string

Worksheet name

fromRow int

From row

fromCol int

From column

toRow int

To row

toColumn int

To column

Properties

Address

The address for the range

public string Address { get; set; }

Property Value

string

Remarks

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