Class FormulaParser

Namespace

OfficeOpenXml.FormulaParsing

Assembly

EPPlus.dll

Entry class for the formula calulation engine of EPPlus.

public class FormulaParser : IDisposable

Inheritance

object

FormulaParser

Implements

IDisposable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

FormulaParser(ExcelPackage)

Constructor

public FormulaParser(ExcelPackage package)

Parameters

package ExcelPackage

The package to calculate

Properties

Logger

An IFormulaParserLogger for logging during calculation

public IFormulaParserLogger Logger { get; }

Property Value

IFormulaParserLogger

Methods

Dispose()

Implementation of IDisposable

public void Dispose()

Parse(string)

Parses a formula

public virtual object Parse(string formula)

Parameters

formula string

A string containing the formula

Returns

object

The result of the calculation

Parse(string, string, ExcelCalculationOption)

Parses a formula at a specific address

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

Parameters

formula string

A string containing the formula

address string

Address of the formula

options ExcelCalculationOption

Calculation options

Returns

object

ParseAt(string)

Parses a formula in a specific location

public virtual object ParseAt(string address)

Parameters

address string

address of the cell to calculate

Returns

object

The result of the calculation

ParseAt(string, int, int)

Parses a formula in a specific location

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

Parameters

worksheetName string

Name of the worksheet

row int

Row in the worksheet

col int

Column in the worksheet

Returns

object

The result of the calculation