Class FormulaParser
Entry class for the formula calulation engine of EPPlus.
Inheritance
System.Object
FormulaParser
Implements
System.IDisposable
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
Assembly: EPPlus.dll
Syntax
public class FormulaParser : IDisposable
Constructors
FormulaParser(ExcelDataProvider)
Constructor
Declaration
public FormulaParser(ExcelDataProvider excelDataProvider)
Parameters
Type | Name | Description |
---|---|---|
Excel |
excelDataProvider | An instance of Excel |
FormulaParser(ExcelDataProvider, ParsingContext)
Constructor
Declaration
public FormulaParser(ExcelDataProvider excelDataProvider, ParsingContext parsingContext)
Parameters
Type | Name | Description |
---|---|---|
Excel |
excelDataProvider | |
Parsing |
parsingContext | Parsing context |
Properties
Logger
An IFormula
Declaration
public IFormulaParserLogger Logger { get; }
Property Value
Type | Description |
---|---|
IFormula |
Methods
Configure(Action<ParsingConfiguration>)
This method enables configuration of the formula parser.
Declaration
public void Configure(Action<ParsingConfiguration> configMethod)
Parameters
Type | Name | Description |
---|---|---|
System. |
configMethod | An instance of the |
Dispose()
Implementation of System.
Declaration
public void Dispose()
Parse(String)
Parses a formula
Declaration
public virtual object Parse(string formula)
Parameters
Type | Name | Description |
---|---|---|
System. |
formula | A string containing the formula |
Returns
Type | Description |
---|---|
System. |
The result of the calculation |
Parse(String, String)
Parses a formula at a specific address
Declaration
public virtual object Parse(string formula, string address)
Parameters
Type | Name | Description |
---|---|---|
System. |
formula | A string containing the formula |
System. |
address | Address of the formula |
Returns
Type | Description |
---|---|
System. |
ParseAt(String)
Parses a formula in a specific location
Declaration
public virtual object ParseAt(string address)
Parameters
Type | Name | Description |
---|---|---|
System. |
address | address of the cell to calculate |
Returns
Type | Description |
---|---|
System. |
The result of the calculation |
ParseAt(String, Int32, Int32)
Parses a formula in a specific location
Declaration
public virtual object ParseAt(string worksheetName, int row, int col)
Parameters
Type | Name | Description |
---|---|---|
System. |
worksheetName | Name of the worksheet |
System. |
row | Row in the worksheet |
System. |
col | Column in the worksheet |
Returns
Type | Description |
---|---|
System. |
The result of the calculation |
Implements
System.IDisposable