Class NameInfo¶

Namespace: OfficeOpenXml.FormulaParsing.Ranges
Assembly: EPPlus.dll

EPPlus implementation of the INameInfo interface

public class NameInfo : INameInfo

Inheritance¶

object ← NameInfo

Implements¶

INameInfo

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

NameInfo(ExcelNamedRange)¶

public NameInfo(ExcelNamedRange nameItem)

Parameters¶

nameItem ExcelNamedRange

Properties¶

Formula¶

Formula of the name

public string Formula { get; }

Property Value¶

string

Id¶

Id

public ulong Id { get; }

Property Value¶

ulong

IsRelative¶

public bool IsRelative { get; }

Property Value¶

bool

Name¶

The name

public string Name { get; }

Property Value¶

string

Tokens¶

Tokens

public IList<Token> Tokens { get; }

Property Value¶

IList<Token>

Value¶

Value

public object Value { get; set; }

Property Value¶

object

wsIx¶

Worksheet name

public int wsIx { get; }

Property Value¶

int

Methods¶

GetRelativeFormula(int, int)¶

Gets the forumla relative to a row and column.

public string GetRelativeFormula(int row, int col)

Parameters¶

row int

The row

col int

The column

Returns¶

string

GetRelativeRange(IRangeInfo, FormulaCellAddress)¶

Returns the range relative to the cell for a named range with a relative address.

public IRangeInfo GetRelativeRange(IRangeInfo ri, FormulaCellAddress currentCell)

Parameters¶

ri IRangeInfo

currentCell FormulaCellAddress

Returns¶

IRangeInfo

GetValue(FormulaCellAddress)¶

Get the value relative to the current cell.

public object GetValue(FormulaCellAddress currentCell)

Parameters¶

currentCell FormulaCellAddress

Returns¶

object