Class NameInfo
EPPlus implementation of the IName
Inheritance
System.Object
NameInfo
Implements
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
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 |
---|---|---|
Excel |
nameItem |
Properties
Formula
Formula of the name
Declaration
public string Formula { get; }
Property Value
Type | Description |
---|---|
System. |
Id
Id
Declaration
public ulong Id { get; }
Property Value
Type | Description |
---|---|
System. |
IsRelative
Declaration
public bool IsRelative { get; }
Property Value
Type | Description |
---|---|
System. |
Name
The name
Declaration
public string Name { get; }
Property Value
Type | Description |
---|---|
System. |
Tokens
Tokens
Declaration
public IList<Token> Tokens { get; }
Property Value
Type | Description |
---|---|
System. |
Value
Value
Declaration
public object Value { get; set; }
Property Value
Type | Description |
---|---|
System. |
wsIx
Worksheet name
Declaration
public int wsIx { get; }
Property Value
Type | Description |
---|---|
System. |
Methods
GetRelativeFormula(Int32, Int32)
Gets the forumla relative to a row and column.
Declaration
public string GetRelativeFormula(int row, int col)
Parameters
Type | Name | Description |
---|---|---|
System. |
row | The row |
System. |
col | The column |
Returns
Type | Description |
---|---|
System. |
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 |
---|---|---|
IRange |
ri | |
Formula |
currentCell |
Returns
Type | Description |
---|---|
IRange |
GetValue(FormulaCellAddress)
Get the value relative to the current cell.
Declaration
public object GetValue(FormulaCellAddress currentCell)
Parameters
Type | Name | Description |
---|---|---|
Formula |
currentCell |
Returns
Type | Description |
---|---|
System. |