Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / CellRange Class / Parse Method
String to be parsed
Example


In This Topic
    Parse Method (CellRange)
    In This Topic
    Converts a string to a cell range.
    Syntax
    'Declaration
     
    Public Shared Function Parse( _
       ByVal s As String _
    ) As CellRange
    'Usage
     
    Dim s As String
    Dim value As CellRange
     
    value = CellRange.Parse(s)
    public static CellRange Parse( 
       string s
    )

    Parameters

    s
    String to be parsed

    Return Value

    CellRange object containing the cell range represented by the string
    Exceptions
    ExceptionDescription
    s is a null reference (Nothing in Visual Basic).
    s does not represent a cell range.
    Remarks
    The string passed to this 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 sets the background color of the cell and cell range.
    FarPoint.Win.Spread.Model.CellRange range = FarPoint.Win.Spread.Model.CellRange.Parse("B2"); 
    fpSpread1.Sheets[0].Cells[range.Row, range.Column].BackColor = Color.Red;
    
    FarPoint.Win.Spread.Model.CellRange range1 = FarPoint.Win.Spread.Model.CellRange.Parse("B4:C6");
    fpSpread1.Sheets[0].Cells[range1.Row, range1.Column, range1.Row + range1.RowCount - 1, range1.Column + range1.ColumnCount - 1].BackColor = Color.Blue;
    
    Dim range As FarPoint.Win.Spread.Model.CellRange 
    range = FarPoint.Win.Spread.Model.CellRange.Parse("B2")
    FpSpread1.Sheets(0).Cells(range.Row, range.Column).BackColor = Color.Red
    
    Dim range1 As FarPoint.Win.Spread.Model.CellRange
    range1 = FarPoint.Win.Spread.Model.CellRange.Parse("B4:C6")
    FpSpread1.Sheets(0).Cells(range1.Row, range1.Column, range1.Row + range1.RowCount - 1, range1.Column + range1.ColumnCount - 1).BackColor = Color.Blue
    
    See Also