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