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(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, ExcelCalculationOption)

Parses a formula at a specific address

Declaration

public virtual object Parse(string formula, string address, ExcelCalculationOption options = null)

Parameters

Type	Name	Description
System.String	formula	A string containing the formula
System.String	address	Address of the formula
ExcelCalculationOption	options	Calculation options

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