Class FormulaParser

Entry class for the formula calulation engine of EPPlus.

Inheritance

object

FormulaParser

Implements

IDisposable

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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 IDisposable

Declaration

public void Dispose()

Parse(string)

Parses a formula

Declaration

public virtual object Parse(string formula)

Parameters

Type	Name	Description
string	formula	A string containing the formula

Returns

Type	Description
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
string	formula	A string containing the formula
string	address	Address of the formula
ExcelCalculationOption	options	Calculation options

Returns

Type	Description
object

ParseAt(string)

Parses a formula in a specific location

Declaration

public virtual object ParseAt(string address)

Parameters

Type	Name	Description
string	address	address of the cell to calculate

Returns

Type	Description
object	The result of the calculation

ParseAt(string, int, int)

Parses a formula in a specific location

Declaration

public virtual object ParseAt(string worksheetName, int row, int col)

Parameters

Type	Name	Description
string	worksheetName	Name of the worksheet
int	row	Row in the worksheet
int	col	Column in the worksheet

Returns

Type	Description
object	The result of the calculation

Implements

IDisposable