SpreadsheetGear 2010
EvaluateValues Method
See Also  Send Feedback
SpreadsheetGear Namespace > ISheet Interface : EvaluateValues Method

formula
The formula to evaluate.
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.

Syntax

Visual Basic (Declaration) 
Function EvaluateValues( _
   ByVal formula As String _
) As Object()
C# 
object[] EvaluateValues( 
   string formula
)

Parameters

formula
The formula to evaluate.

Return Value

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

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

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.