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(ExcelPackage)
Constructor
Declaration
public FormulaParser(ExcelPackage package)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelPackage | package | The package to calculate |
Properties
Logger
An IFormulaParserLogger for logging during calculation
Declaration
public IFormulaParserLogger Logger { get; }Property Value
| Type | Description |
|---|---|
| IFormulaParserLogger |
Methods
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