Class NameInfo

EPPlus implementation of the INameInfo interface

Inheritance
object
NameInfo
Implements
Inherited Members
Namespace: OfficeOpenXml.FormulaParsing.Ranges
Assembly: EPPlus.dll
Syntax
public class NameInfo : INameInfo

Constructors

NameInfo(ExcelNamedRange)

Nameinfo

Declaration
public NameInfo(ExcelNamedRange nameItem)
Parameters
Type Name Description
ExcelNamedRange nameItem

Properties

Formula

Formula of the name

Declaration
public string Formula { get; }
Property Value
Type Description
string

Id

Id

Declaration
public ulong Id { get; }
Property Value
Type Description
ulong

IsRelative

Declaration
public bool IsRelative { get; }
Property Value
Type Description
bool

Name

The name

Declaration
public string Name { get; }
Property Value
Type Description
string

Tokens

Tokens

Declaration
public IList<Token> Tokens { get; }
Property Value
Type Description
IList<Token>

Value

Value

Declaration
public object Value { get; set; }
Property Value
Type Description
object

wsIx

Worksheet name

Declaration
public int wsIx { get; }
Property Value
Type Description
int

Methods

GetRelativeFormula(int, int)

Gets the forumla relative to a row and column.

Declaration
public string GetRelativeFormula(int row, int col)
Parameters
Type Name Description
int row

The row
int col

The column
Returns
Type Description
string

GetRelativeRange(IRangeInfo, FormulaCellAddress)

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

Declaration
public IRangeInfo GetRelativeRange(IRangeInfo ri, FormulaCellAddress currentCell)
Parameters
Type Name Description
IRangeInfo ri
FormulaCellAddress currentCell
Returns
Type Description
IRangeInfo

GetValue(FormulaCellAddress)

Get the value relative to the current cell.

Declaration
public object GetValue(FormulaCellAddress currentCell)
Parameters
Type Name Description
FormulaCellAddress currentCell
Returns
Type Description
object

Implements