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.SetAddress(string, ExcelWorkbook, string)

ExcelAddressBase.BeforeChangeAddress()

ExcelAddressBase.ChangeAddress()

ExcelAddressBase.ToString()

ExcelAddressBase.GetHashCode()

ExcelAddressBase.Validate()

ExcelAddressBase.Equals(object)

ExcelAddressBase.Start

ExcelAddressBase.End

ExcelAddressBase.ExternalReferenceIndex

ExcelAddressBase.Table

ExcelAddressBase.AddressAbsolute

ExcelAddressBase.FullAddress

ExcelAddressBase.IsName

ExcelAddressBase.Rows

ExcelAddressBase.Columns

ExcelAddressBase.IsFullRow

ExcelAddressBase.IsFullColumn

ExcelAddressBase.LocalAddress

ExcelAddressBase.IsExternal

ExcelCellBase.TranslateFromR1C1(string, int, int)

ExcelCellBase.TranslateToR1C1(string, int, int)

ExcelCellBase.GetColumnLetter(int)

ExcelCellBase.GetColumnLetter(int, bool)

ExcelCellBase.GetAddressRow(int, bool)

ExcelCellBase.GetAddressCol(int, bool)

ExcelCellBase.GetAddress(int, int)

ExcelCellBase.GetAddress(int, bool, int, bool)

ExcelCellBase.GetAddress(int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int)

ExcelCellBase.GetAddress(int, int, int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int, bool, bool, bool, bool)

ExcelCellBase.GetFullAddress(string, string)

ExcelCellBase.GetFullAddress(string, string, string)

ExcelCellBase.IsSimpleAddress(string)

ExcelCellBase.IsValidAddress(string)

ExcelCellBase.IsValidTableAddress(string)

ExcelCellBase.IsValidRangeAddress(string)

ExcelCellBase.IsValidCellAddress(string)

object.GetType()

object.MemberwiseClone()

object.Equals(object, object)

object.ReferenceEquals(object, object)

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>