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.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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, 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

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

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