Class ExcelAddress

Range address with the address property readonly

Inheritance

object

ExcelCellBase

ExcelAddressBase

ExcelAddress

ExcelDatavalidationAddress

ExcelRangeBase

Inherited Members

ExcelAddressBase.SetAddress(string, ExcelWorkbook, string)

ExcelAddressBase.BeforeChangeAddress(string)

ExcelAddressBase.ChangeAddress(string)

ExcelAddressBase.Start

ExcelAddressBase.End

ExcelAddressBase.ExternalReferenceIndex

ExcelAddressBase.Table

ExcelAddressBase.AddressAbsolute

ExcelAddressBase.FullAddress

ExcelAddressBase.IsName

ExcelAddressBase.ToString()

ExcelAddressBase.GetHashCode()

ExcelAddressBase.Validate()

ExcelAddressBase.Rows

ExcelAddressBase.Columns

ExcelAddressBase.IsFullRow

ExcelAddressBase.IsFullColumn

ExcelAddressBase.LocalAddress

ExcelAddressBase.Equals(object)

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.Equals(object, object)

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public class ExcelAddress : ExcelAddressBase

Constructors

ExcelAddress(int, int, int, int)

Constructor

Declaration

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

Parameters

Type	Name	Description
int	fromRow	From row
int	fromCol	From column
int	toRow	To row
int	toColumn	To column

ExcelAddress(string)

Constructor

Declaration

public ExcelAddress(string address)

Parameters

Type	Name	Description
string	address	The Excel address

ExcelAddress(string, ExcelPackage, ExcelAddressBase)

Creates an Address object

Declaration

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

Parameters

Type	Name	Description
string	Address	The Excel Address
ExcelPackage	package	Reference to the package to find information about tables and names
ExcelAddressBase	referenceAddress	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

Declaration

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

Parameters

Type	Name	Description
string	ws	Worksheet name
int	fromRow	From row
int	fromCol	From column
int	toRow	To row
int	toColumn	To column

Properties

Address

The address for the range

Declaration

public string Address { get; set; }

Property Value

Type	Description
string

Remarks

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