Version

TryParse(String,CellReferenceMode,WorkbookFormat,CultureInfo,Formula,FormulaParseException) Method

Parses the specified formula value. The return value indicates whether the operation succeeded.
Syntax
'Declaration
 
Public Overloads Shared Function TryParse( _
   ByVal value As System.String, _
   ByVal cellReferenceMode As CellReferenceMode, _
   ByVal fileFormat As WorkbookFormat, _
   ByVal culture As System.Globalization.CultureInfo, _
   ByRef formula As Formula, _
   ByRef exception As FormulaParseException _
) As System.Boolean
public static System.bool TryParse( 
   System.string value,
   CellReferenceMode cellReferenceMode,
   WorkbookFormat fileFormat,
   System.Globalization.CultureInfo culture,
   out Formula formula,
   out FormulaParseException exception
)

Parameters

value
The string which defines the formula to parse.
cellReferenceMode
The mode used to interpret cell references in the formula.
fileFormat
The file format to use when parsing the formula. This will be used to determine certain limits which are format dependant.
culture
The culture used to parse the formula.
formula
When this method returns, contains the formula which was parsed from value if the conversion succeeded or null if the conversion failed. This parameter is passed uninitialized.
exception
When this method returns, contains the error information if the conversion failed or null if the conversion succeeded. This parameter is passed uninitialized.

Return Value

True if value was converted successfully; False otherwise.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionvalue is null or empty.
System.ComponentModel.InvalidEnumArgumentExceptioncellReferenceMode is not defined in the CellReferenceMode enumeration.
System.ComponentModel.InvalidEnumArgumentExceptionfileFormat is not defined in the WorkbookFormat enumeration.
Requirements

Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

View on GitHub