Class NameInfo
EPPlus implementation of the INameInfo interface
Inheritance
Object
NameInfo
Implements
Inherited Members
Object.Equals(Object)
Object.Equals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, Object)
Object.ToString()
Namespace: OfficeOpenXml.FormulaParsing.Ranges
Assembly: EPPlus.dll
Syntax
public class NameInfo : INameInfoConstructors
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 |
|---|---|
| UInt64 |
IsRelative
Declaration
public bool IsRelative { get; }Property Value
| Type | Description |
|---|---|
| Boolean |
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 |
|---|---|
| Int32 |
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 |
|---|---|---|
| Int32 | row | The row |
| Int32 | 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 |