Class ExcelAddress

Range address with the address property readonly

Inheritance
Object
ExcelCellBase
ExcelAddressBase
ExcelAddress
ExcelDatavalidationAddress
ExcelRangeBase
Inherited Members
Object.Equals(Object, Object)
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, Object)
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public class ExcelAddress : ExcelAddressBase

Constructors

ExcelAddress(Int32, Int32, Int32, Int32)

Constructor

Declaration
public ExcelAddress(int fromRow, int fromCol, int toRow, int toColumn)
Parameters
Type Name Description
Int32 fromRow

From row
Int32 fromCol

From column
Int32 toRow

To row
Int32 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, Int32, Int32, Int32, Int32)

Constructor

Declaration
public ExcelAddress(string ws, int fromRow, int fromCol, int toRow, int toColumn)
Parameters
Type Name Description
String ws

Worksheet name
Int32 fromRow

From row
Int32 fromCol

From column
Int32 toRow

To row
Int32 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"