Spread Windows Forms 11.0 Product Documentation
TryParse Method (CellRange)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > CellRange Class : TryParse Method
String to be parsed
Cell range represented by the string. If the return value is false then result is set to null.
Converts a string to a cell range.
Syntax
'Declaration
 
Public Shared Function TryParse( _
   ByVal s As String, _
   ByRef result As CellRange _
) As Boolean
'Usage
 
Dim s As String
Dim result As CellRange
Dim value As Boolean
 
value = CellRange.TryParse(s, result)
public static bool TryParse( 
   string s,
   out CellRange result
)

Parameters

s
String to be parsed
result
Cell range represented by the string. If the return value is false then result is set to null.

Return Value

true if the string is converted successfully; false otherwise

The result parameter returns the result of parsing the string.

Remarks
The text passed to the TryParse method must contain the cell name(s) as a column name (as one or more letters) following by the row number (as one or more digits). The row number is 1-based.
Example
This example returns the result.
bool result; 
FarPoint.Win.Spread.Model.CellRange range;
result = FarPoint.Win.Spread.Model.CellRange.TryParse("B3", out range);
textBox1.Text = result.ToString();
Dim trange As FarPoint.Win.Spread.Model.CellRange
Dim result As Boolean 
result = FarPoint.Win.Spread.Model.CellRange.TryParse("B1", trange)
TextBox1.Text = result
See Also

Reference

CellRange Class
CellRange Members
Parse Method