EvaluateValues Method

Evaluates the specified formula and returns the result as an array of objects, where each object is a System.Double, System.String, System.Boolean or ValueError.

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

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

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

[C++/CLI]
virtual array<Object^>^ EvaluateValues( 
   String^ formula
) 

Parameters

formula

The formula to evaluate.

Return Type

The result of evaluating the formula as an array of objects, where each object is a System.Double, System.String, System.Boolean or ValueError.

Remarks

Multiple values may be returned by providing a formula with comma separated (or the appropriate argument separator for the workbook set's locale) expressions.

null will be returned if the formula is invalid.

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

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  | EvaluateValue 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.