GrapeCity.Documents.Excel.IWorksheet.Evaluate2

Evaluate2 Method

Evaluates the specified Excel formula or named expression and returns the result. The calculation behavior is consistent with Excel 2021/365.

object Evaluate2(string formula)

Function Evaluate2(formula As String) As Object

Type	Name	Description
string	formula	A string containing an Excel formula, named range, or defined name to evaluate.

Type	Description
object	The result of the evaluation in one of these forms: A single value for a standard formula A two-dimensional object array (System.Object[,]) for a dynamic array formula (first dimension: rows, second dimension: columns) An IRange object when the formula returns a reference (e.g. "=A1:A5")

Type

Description

The result of the evaluation in one of these forms:

A single value for a standard formula
A two-dimensional object array (System.Object[,]) for a dynamic array formula (first dimension: rows, second dimension: columns)
An IRange object when the formula returns a reference (e.g. "=A1:A5")