Class ExcelFormulaAddress¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Range address used in the formula parser

public class ExcelFormulaAddress : ExcelAddressBase

Inheritance¶

object ← ExcelCellBase ← ExcelAddressBase ← ExcelFormulaAddress

Inherited Members¶

ExcelAddressBase.Address
ExcelAddressBase.AddressAbsolute
ExcelAddressBase.BeforeChangeAddress()
ExcelAddressBase.ChangeAddress()
ExcelAddressBase.Columns
ExcelAddressBase.End
ExcelAddressBase.Equals(object)
ExcelAddressBase.ExternalReferenceIndex
ExcelAddressBase.FullAddress
ExcelAddressBase.GetHashCode()
ExcelAddressBase.IsExternal
ExcelAddressBase.IsFullColumn
ExcelAddressBase.IsFullRow
ExcelAddressBase.IsName
ExcelAddressBase.LocalAddress
ExcelAddressBase.Rows
ExcelAddressBase.SetAddress(string, ExcelWorkbook, string)
ExcelAddressBase.Start
ExcelAddressBase.Table
ExcelAddressBase.ToString()
ExcelAddressBase.Validate()
ExcelCellBase.GetAddress(int, bool, int, bool)
ExcelCellBase.GetAddress(int, int, bool)
ExcelCellBase.GetAddress(int, int, int, int, bool, bool, bool, bool)
ExcelCellBase.GetAddress(int, int, int, int, bool)
ExcelCellBase.GetAddress(int, int, int, int)
ExcelCellBase.GetAddress(int, int)
ExcelCellBase.GetAddressCol(int, bool)
ExcelCellBase.GetAddressRow(int, bool)
ExcelCellBase.GetColumnLetter(int, bool)
ExcelCellBase.GetColumnLetter(int)
ExcelCellBase.GetFullAddress(string, string, string)
ExcelCellBase.GetFullAddress(string, string)
ExcelCellBase.IsSimpleAddress(string)
ExcelCellBase.IsValidAddress(string)
ExcelCellBase.IsValidCellAddress(string)
ExcelCellBase.IsValidRangeAddress(string)
ExcelCellBase.IsValidTableAddress(string)
ExcelCellBase.TranslateFromR1C1(string, int, int)
ExcelCellBase.TranslateToR1C1(string, int, int)
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelFormulaAddress(int, int, int, int)¶

Creates an Address object

public ExcelFormulaAddress(int fromRow, int fromCol, int toRow, int toColumn)

Parameters¶

fromRow int

start row

fromCol int

start column

toRow int

End row

toColumn int

End column

ExcelFormulaAddress(string, ExcelWorksheet)¶

Creates an Address object

public ExcelFormulaAddress(string address, ExcelWorksheet worksheet)

Parameters¶

address string

The formula address

worksheet ExcelWorksheet

The worksheet

Properties¶

Address¶

The address for the range

public string Address { get; set; }

Property Value¶

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.

public List<ExcelFormulaAddress> Addresses { get; }

Property Value¶

List<ExcelFormulaAddress>