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.Address
ExcelAddressBase.AddressAbsolute
ExcelAddressBase.BeforeChangeAddress(string)
ExcelAddressBase.ChangeAddress(string)
ExcelAddressBase.Columns
ExcelAddressBase.End
ExcelAddressBase.Equals(object)
ExcelAddressBase.ExternalReferenceIndex
ExcelAddressBase.FullAddress
ExcelAddressBase.GetHashCode()
ExcelAddressBase.IsExternal
ExcelAddressBase.IsFullColumn
ExcelAddressBase.IsFullRow
ExcelAddressBase.IsName
ExcelAddressBase.LocalAddress
ExcelAddressBase.Rows
ExcelAddressBase.SetAddress(string, ExcelWorkbook, string)
ExcelAddressBase.Start
ExcelAddressBase.Table
ExcelAddressBase.ToString()
ExcelAddressBase.Validate()
ExcelCellBase.GetAddress(int, bool, int, bool)
ExcelCellBase.GetAddress(int, int, bool)
ExcelCellBase.GetAddress(int, int, int, int, bool, bool, bool, bool)
ExcelCellBase.GetAddress(int, int, int, int, bool)
ExcelCellBase.GetAddress(int, int, int, int)
ExcelCellBase.GetAddress(int, int)
ExcelCellBase.GetAddressCol(int, bool)
ExcelCellBase.GetAddressRow(int, bool)
ExcelCellBase.GetColumnLetter(int, bool)
ExcelCellBase.GetColumnLetter(int)
ExcelCellBase.GetFullAddress(string, string, string)
ExcelCellBase.GetFullAddress(string, string)
ExcelCellBase.IsSimpleAddress(string)
ExcelCellBase.IsValidAddress(string)
ExcelCellBase.IsValidCellAddress(string)
ExcelCellBase.IsValidRangeAddress(string)
ExcelCellBase.IsValidTableAddress(string)
ExcelCellBase.TranslateFromR1C1(string, int, int)
ExcelCellBase.TranslateToR1C1(string, int, int)
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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, 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

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"

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"