TryParseA1Reference(String,Int32,Int32,RangeReference) Method

In This Topic

Converts the string representation of a range reference in A1 format its RangeReference equivalent. A return value indicates whether the conversion succeeded or failed.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function TryParseA1Reference( _
   ByVal ref As String, _
   ByVal baseRow As Integer, _
   ByVal baseColumn As Integer, _
   ByRef rangeRef As RangeReference _
) As Boolean

'Usage
 
Dim ref As String
Dim baseRow As Integer
Dim baseColumn As Integer
Dim rangeRef As RangeReference
Dim value As Boolean
 
value = FormulaEngine.TryParseA1Reference(ref, baseRow, baseColumn, rangeRef)

public static bool TryParseA1Reference( 
   string ref,
   int baseRow,
   int baseColumn,
   ref RangeReference rangeRef
)

Parameters

ref: A string containing a range reference to convert.
baseRow: An integer value indicates the context row.
baseColumn: An integer value indicates the context column.
rangeRef: A RangeReference value represents the parsed range reference.

Return Value

true if s was converted successfully; otherwise, false.

Reference

FormulaEngine Class
FormulaEngine Members