Class ExcelAddress

Range address with the address property readonly

Inheritance
System.Object
ExcelCellBase
ExcelAddressBase
ExcelAddress
ExcelDatavalidationAddress
ExcelRangeBase
Inherited Members
System.Object.Equals(System.Object, System.Object)
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.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
System.Int32 fromRow

From row
System.Int32 fromCol

From column
System.Int32 toRow

To row
System.Int32 toColumn

To column

ExcelAddress(String)

Constructor

Declaration
public ExcelAddress(string address)
Parameters
Type Name Description
System.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
System.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
System.String ws

Worksheet name
System.Int32 fromRow

From row
System.Int32 fromCol

From column
System.Int32 toRow

To row
System.Int32 toColumn

To column

Properties

Address

The address for the range

Declaration
public string Address { get; set; }
Property Value
Type Description
System.String
Remarks

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