Converts a string to a cell range.

Syntax

Visual Basic (Declaration)
Public Shared Function Parse( _ ByVal s As String _ ) As CellRange

Visual Basic (Usage)	Copy Code
Dim s As String Dim value As CellRange value = CellRange.Parse(s)

C#
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

Exception	Description
System.ArgumentNullException	s is a null reference (Nothing in Visual Basic).
System.FormatException	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.

C#	Copy Code
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;

Copy Code

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;

Visual Basic	Copy Code
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

Visual Basic

Copy Code

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

Requirements

Target Platforms: 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