SpreadsheetGear 2023
GetAddress(Int32,Int32,Int32,Int32,Int32,Int32,Boolean,Boolean,Boolean,Boolean,Boolean,ReferenceStyle) Method


SpreadsheetGear Namespace > IWorkbookSet Interface > GetAddress Method : GetAddress(Int32,Int32,Int32,Int32,Int32,Int32,Boolean,Boolean,Boolean,Boolean,Boolean,ReferenceStyle) Method
The first row of the range.
The first column of the range.
The last row of the range.
The last column of the range.
Specifies the base row for relative references in the R1C1 reference style, ignored for the A1 reference style.
Specifies the base column for relative references in the R1C1 reference style, ignored for the A1 reference style.
Specifies whether the first row is absolute.
Specifies whether the first column is absolute.
Specifies whether the last row is absolute.
Specifies whether the last column is absolute.
Specifies whether a range reference should be returned for a single cell (row1 == row2 and column1 == column2).
Specifies whether to use the A1 reference style or R1C1 style.
Returns a string representing the specified zero based row and column indexes.
Syntax
'Declaration
 
Overloads Function GetAddress( _
   ByVal row1 As System.Integer, _
   ByVal column1 As System.Integer, _
   ByVal row2 As System.Integer, _
   ByVal column2 As System.Integer, _
   ByVal rowBase As System.Integer, _
   ByVal columnBase As System.Integer, _
   ByVal row1Abs As System.Boolean, _
   ByVal column1Abs As System.Boolean, _
   ByVal row2Abs As System.Boolean, _
   ByVal column2Abs As System.Boolean, _
   ByVal forceRange As System.Boolean, _
   ByVal referenceStyle As ReferenceStyle _
) As System.String
'Usage
 
Dim instance As IWorkbookSet
Dim row1 As System.Integer
Dim column1 As System.Integer
Dim row2 As System.Integer
Dim column2 As System.Integer
Dim rowBase As System.Integer
Dim columnBase As System.Integer
Dim row1Abs As System.Boolean
Dim column1Abs As System.Boolean
Dim row2Abs As System.Boolean
Dim column2Abs As System.Boolean
Dim forceRange As System.Boolean
Dim referenceStyle As ReferenceStyle
Dim value As System.String
 
value = instance.GetAddress(row1, column1, row2, column2, rowBase, columnBase, row1Abs, column1Abs, row2Abs, column2Abs, forceRange, referenceStyle)
System.string GetAddress( 
   System.int row1,
   System.int column1,
   System.int row2,
   System.int column2,
   System.int rowBase,
   System.int columnBase,
   System.bool row1Abs,
   System.bool column1Abs,
   System.bool row2Abs,
   System.bool column2Abs,
   System.bool forceRange,
   ReferenceStyle referenceStyle
)

Parameters

row1
The first row of the range.
column1
The first column of the range.
row2
The last row of the range.
column2
The last column of the range.
rowBase
Specifies the base row for relative references in the R1C1 reference style, ignored for the A1 reference style.
columnBase
Specifies the base column for relative references in the R1C1 reference style, ignored for the A1 reference style.
row1Abs
Specifies whether the first row is absolute.
column1Abs
Specifies whether the first column is absolute.
row2Abs
Specifies whether the last row is absolute.
column2Abs
Specifies whether the last column is absolute.
forceRange
Specifies whether a range reference should be returned for a single cell (row1 == row2 and column1 == column2).
referenceStyle
Specifies whether to use the A1 reference style or R1C1 style.

Return Value

The range formatted as a range reference in the specified reference style.
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

See Also

Reference

IWorkbookSet Interface
IWorkbookSet Members
Overload List
GetAddress(Int32,Int32) Method