Spread Windows Forms 13.0 Product Documentation
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.
Example


In This Topic
    TryParse Method (CellRange)
    In This Topic
    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