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


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
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

CellRange Class
CellRange Members
Parse Method

 

 


Copyright © GrapeCity, inc. All rights reserved.