Class ExcelFormulaAddress

Range address used in the formula parser

Inheritance
object
ExcelCellBase
ExcelAddressBase
ExcelFormulaAddress
Inherited Members
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public class ExcelFormulaAddress : ExcelAddressBase

Constructors

ExcelFormulaAddress(int, int, int, int)

Creates an Address object

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

start row
int fromCol

start column
int toRow

End row
int toColumn

End column

ExcelFormulaAddress(string, ExcelWorksheet)

Creates an Address object

Declaration
public ExcelFormulaAddress(string address, ExcelWorksheet worksheet)
Parameters
Type Name Description
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
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
List<ExcelFormulaAddress>