EvaluateValue Method

Evaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean or ValueError.

[Visual Basic]
Overridable Function EvaluateValue( _
   ByVal formula As String _
) As Object

[C#]
virtual object EvaluateValue( 
   string formula
);

[C++]
virtual Object* EvaluateValue( 
   string* formula
) 

[C++/CLI]
virtual Object^ EvaluateValue( 
   String^ formula
) 

Parameters

formula

The formula to evaluate.

Return Type

The result of evaluating the formula as a System.Double, System.String, System.Boolean or ValueError.

Remarks

null will be returned if the formula is invalid.

If the formula results in a range or an array, the top-left value of the range or array will be returned.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

ISheet Interface  | ISheet Members  | EvaluateRange Method  | EvaluateRanges Method  | EvaluateValues Method

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.