Show / Hide Table of Contents

Class ExcelAddress

Range address with the address property readonly

Inheritance
System.Object
ExcelCellBase
ExcelAddressBase
ExcelAddress
ExcelRangeBase
Inherited Members
ExcelAddressBase.SetAddress(String, ExcelWorkbook, String)
ExcelAddressBase.ChangeAddress()
ExcelAddressBase.Start
ExcelAddressBase.End
ExcelAddressBase.ExternalReferenceIndex
ExcelAddressBase.Table
ExcelAddressBase.FullAddress
ExcelAddressBase.IsName
ExcelAddressBase.ToString()
ExcelAddressBase.Validate()
ExcelAddressBase.Rows
ExcelAddressBase.Columns
ExcelAddressBase.IsFullRow
ExcelAddressBase.IsFullColumn
ExcelAddressBase.LocalAddress
ExcelAddressBase.Equals(Object)
ExcelAddressBase.IsExternal
ExcelCellBase.TranslateFromR1C1(String, Int32, Int32)
ExcelCellBase.TranslateToR1C1(String, Int32, Int32)
ExcelCellBase.GetColumnLetter(Int32)
ExcelCellBase.GetColumnLetter(Int32, Boolean)
ExcelCellBase.GetAddressRow(Int32, Boolean)
ExcelCellBase.GetAddressCol(Int32, Boolean)
ExcelCellBase.GetAddress(Int32, Int32)
ExcelCellBase.GetAddress(Int32, Boolean, Int32, Boolean)
ExcelCellBase.GetAddress(Int32, Int32, Boolean)
ExcelCellBase.GetAddress(Int32, Int32, Int32, Int32)
ExcelCellBase.GetAddress(Int32, Int32, Int32, Int32, Boolean)
ExcelCellBase.GetAddress(Int32, Int32, Int32, Int32, Boolean, Boolean, Boolean, Boolean)
ExcelCellBase.GetFullAddress(String, String)
ExcelCellBase.GetFullAddress(String, String, String)
ExcelCellBase.IsSimpleAddress(String)
ExcelCellBase.IsValidAddress(String)
ExcelCellBase.IsValidCellAddress(String)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
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"

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"

Back to top Generated by DocFX