GetCellRange(String,Int32,Int32,Int32,Int32) Method

In This Topic

Gets the cell range.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shared Sub GetCellRange( _
   ByVal value As String, _
   ByRef startRowIndex As Integer, _
   ByRef startColumnIndex As Integer, _
   ByRef endRowIndex As Integer, _
   ByRef endColumnIndex As Integer _
)

'Usage
 
Dim value As String
Dim startRowIndex As Integer
Dim startColumnIndex As Integer
Dim endRowIndex As Integer
Dim endColumnIndex As Integer
 
ExcelXMLHelpers.GetCellRange(value, startRowIndex, startColumnIndex, endRowIndex, endColumnIndex)

public static void GetCellRange( 
   string value,
   ref int startRowIndex,
   ref int startColumnIndex,
   ref int endRowIndex,
   ref int endColumnIndex
)

Parameters

value: value. such as "A1:C3"
startRowIndex: Start index of the row base 0
startColumnIndex: Start index of the column base 0
endRowIndex: End index of the row base 0
endColumnIndex: End index of the column base 0

Reference

ExcelXMLHelpers Class
ExcelXMLHelpers Members
Overload List