Class ExcelFormulaAddress

Range address used in the formula parser

Inheritance
System.Object
ExcelCellBase
ExcelAddressBase
ExcelFormulaAddress
Inherited Members
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 ExcelFormulaAddress : ExcelAddressBase

Constructors

ExcelFormulaAddress(Int32, Int32, Int32, Int32)

Creates an Address object

Declaration
public ExcelFormulaAddress(int fromRow, int fromCol, int toRow, int toColumn)
Parameters
Type Name Description
System.Int32 fromRow

start row
System.Int32 fromCol

start column
System.Int32 toRow

End row
System.Int32 toColumn

End column

ExcelFormulaAddress(String, ExcelWorksheet)

Creates an Address object

Declaration
public ExcelFormulaAddress(string address, ExcelWorksheet worksheet)
Parameters
Type Name Description
System.String address

The formula address
ExcelWorksheet worksheet

The worksheet

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"

Addresses

Addresses can be separated by a comma. If the address contains multiple addresses this list contains them.

Declaration
public List<ExcelFormulaAddress> Addresses { get; }
Property Value
Type Description
System.Collections.Generic.List<ExcelFormulaAddress>