Class NameInfo
EPPlus implementation of the INameInfo interface
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 : INameInfoConstructors
NameInfo(ExcelNamedRange)
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 |
|---|---|
| System.String |
Id
Id
Declaration
public ulong Id { get; }Property Value
| Type | Description |
|---|---|
| System.UInt64 |
IsRelative
Declaration
public bool IsRelative { get; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Name
The name
Declaration
public string Name { get; }Property Value
| Type | Description |
|---|---|
| System.String |
Tokens
Tokens
Declaration
public IList<Token> Tokens { get; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<Token> |
Value
Value
Declaration
public object Value { get; set; }Property Value
| Type | Description |
|---|---|
| System.Object |
wsIx
Worksheet name
Declaration
public int wsIx { get; }Property Value
| Type | Description |
|---|---|
| System.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 |
|---|---|---|
| System.Int32 | row | The row |
| System.Int32 | col | The column |
Returns
| Type | Description |
|---|---|
| System.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 |
|---|---|
| System.Object |