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(ExcelDataProvider)

Constructor

Declaration

public FormulaParser(ExcelDataProvider excelDataProvider)

Parameters

Type	Name	Description
ExcelDataProvider	excelDataProvider	An instance of ExcelDataProvider which provides access to a workbook

FormulaParser(ExcelDataProvider, ParsingContext)

Constructor

Declaration

public FormulaParser(ExcelDataProvider excelDataProvider, ParsingContext parsingContext)

Parameters

Type	Name	Description
ExcelDataProvider	excelDataProvider	An ExcelDataProvider
ParsingContext	parsingContext	Parsing context

Properties

Logger

An IFormulaParserLogger for logging during calculation

Declaration

public IFormulaParserLogger Logger { get; }

Property Value

Type	Description
IFormulaParserLogger

Methods

Configure(Action<ParsingConfiguration>)

This method enables configuration of the formula parser.

Declaration

public void Configure(Action<ParsingConfiguration> configMethod)

Parameters

Type	Name	Description
System.Action<ParsingConfiguration>	configMethod	An instance of the

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