-
DS.Documents.Excel Assembly
-
GrapeCity.Documents.Excel
- Classes
- Enums
-
Interfaces
- IAboveAverage
- IAreas
- IAuthor
- IAutoFilter
- IAutoMergeRangeInfo
- IBarcode
- IBorder
- IBorders
- IBuiltInDocumentPropertyCollection
- ICalcContext
- ICalculatedFields
- ICalculatedItems
- ICascadeSparkLine
- ICellCollection
- ICellColorSortField
- ICellDecoration
- ICellDecorationIcon
- ICellPadding
- ICodabar
- ICode128
- ICode39
- ICode49
- ICode93
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStop
- IColorStops
- IComment
- IComments
- ICommentsThreaded
- ICommentThreaded
- IConditionValue
- ICornerFold
- ICsvParser
- ICustomDocumentPropertyCollection
- ICustomView
- ICustomViews
- IDataBar
- IDataBarBorder
- IDataMatrix
- IDataOptions
- IDisplayFormat
- IDocumentProperty
- IDocumentPropertyCollection
- IEAN13
- IEAN8
- IExcelOptions
- IFilter
- IFilters
- IFont
- IFontColorSortField
- IFontOption
- IFormatColor
- IFormatCondition
- IFormatConditions
- IFormulaOptions
- IFormulaResolver
- IGraphic
- IGraphicsInfo
- IGroupInfo
- IGS1128
- IHeaderFooter
- IHPageBreak
- IHPageBreaks
- IHyperlink
- IHyperlinks
- IIcon
- IIconCriteria
- IIconCriterion
- IIconSet
- IIconSetCondition
- IIconSets
- IIconSortField
- IInterior
- IJsonSerializer
- ILabelOption
- ILabelOptions
- ILinearGradient
- IName
- INames
- INegativeBarFormat
- IOutline
- IOutlineColumn
- IPage
- IPageSetup
- IPane
- IPanes
- IPDF417
- IPivotAxis
- IPivotCache
- IPivotCaches
- IPivotCell
- IPivotField
- IPivotFields
- IPivotFilter
- IPivotFilters
- IPivotFormula
- IPivotFormulas
- IPivotItem
- IPivotItemList
- IPivotItems
- IPivotLine
- IPivotLineCells
- IPivotLines
- IPivotTable
- IPivotTables
- IPivotValueCell
- IProtectionSettings
- IQRCode
- IRange
- IRangeProvider
- IReadOnlySignatureDetails
- IRectangularGradient
- IRichText
- IScenario
- IScenarios
- ISheetTab
- ISheetTabs
- IShrinkToFitSettings
- ISignature
- ISignatureSet
- ISignatureSetup
- ISlicer
- ISlicerCache
- ISlicerCaches
- ISlicerItem
- ISlicerItems
- ISlicerPivotTables
- ISlicers
- ISort
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- ISparkLineObject
- ISparkPoints
- ISparkVerticalAxis
- IStyle
- IStyleCollection
- ITable
- ITableColumn
- ITableColumns
- ITableDataSource
- ITableRow
- ITableRows
- ITables
- ITableStyle
- ITableStyleCollection
- ITableStyleElement
- ITableStyleElements
- ITextRun
- ITheme
- IThemeColor
- IThemeColorScheme
- IThemeFont
- IThemeFonts
- IThemeFontScheme
- ITop10
- IUniqueValues
- IValidation
- IValueSortField
- IVPageBreak
- IVPageBreaks
- IWebRequestHandler
- IWorkbook
- IWorkbookView
- IWorksheet
- IWorksheets
- IWorksheetView
- Structs
- GrapeCity.Documents.Excel.Drawing
- GrapeCity.Documents.Excel.Expressions
- GrapeCity.Documents.Excel.Forms
-
GrapeCity.Documents.Excel
GrapeCity.Documents.Excel.IWorksheet.Evaluate
Evaluate Method
Evaluate(string)
Evaluates the specified Excel formula or named expression and returns the result. The calculation behavior is consistent with Excel 2019 and earlier versions.
Declaration
object Evaluate(string formula)Function Evaluate(formula As String) As ObjectParameters
| Type | Name | Description |
|---|---|---|
| string | formula | A string containing an Excel formula, named range, or defined name to evaluate. |
Returns
| Type | Description |
|---|---|
| object | The result of the evaluation. When the result of the formula is a reference, such as "=A1", it will return an IRange object. |
Evaluate(string, IFormulaResolver)
Declaration
object Evaluate(string formula, IFormulaResolver resolver)Function Evaluate(formula As String, resolver As IFormulaResolver) As ObjectParameters
| Type | Name | Description |
|---|---|---|
| string | formula | |
| IFormulaResolver | resolver |
Returns
| Type | Description |
|---|---|
| object |