SpreadsheetGear 2012
GetAddress Method (IRange)






True if the row should be treated as an absolute reference, false otherwise.
True if the column should be treated as an absolute reference, false otherwise.
Specfies whether A1 style or R1C1 style should be used.
True if the workbook and worksheet should be included in the address, false otherwise.
Represents the cell which this range is relative to. This parameter is unused for A1 style. It may be null to indicate relative to the top-left cell (A1).
Returns a string representing the address of the range.
Syntax
'Declaration
 
Function GetAddress( _
   ByVal rowAbsolute As System.Boolean, _
   ByVal colAbsolute As System.Boolean, _
   ByVal referenceStyle As ReferenceStyle, _
   ByVal external As System.Boolean, _
   ByVal relativeTo As IRange _
) As System.String
'Usage
 
Dim instance As IRange
Dim rowAbsolute As System.Boolean
Dim colAbsolute As System.Boolean
Dim referenceStyle As ReferenceStyle
Dim external As System.Boolean
Dim relativeTo As IRange
Dim value As System.String
 
value = instance.GetAddress(rowAbsolute, colAbsolute, referenceStyle, external, relativeTo)
System.string GetAddress( 
   System.bool rowAbsolute,
   System.bool colAbsolute,
   ReferenceStyle referenceStyle,
   System.bool external,
   IRange relativeTo
)
function GetAddress( 
    rowAbsolute: System.Boolean;
    colAbsolute: System.Boolean;
    referenceStyle: ReferenceStyle;
    external: System.Boolean;
    relativeTo: IRange
): System.String; 
function GetAddress( 
   rowAbsolute : System.boolean,
   colAbsolute : System.boolean,
   referenceStyle : ReferenceStyle,
   external : System.boolean,
   relativeTo : IRange
) : System.String;
System.string* GetAddress( 
   System.bool rowAbsolute,
   System.bool colAbsolute,
   ReferenceStyle referenceStyle,
   System.bool external,
   IRange* relativeTo
) 
System.String^ GetAddress( 
   System.bool rowAbsolute,
   System.bool colAbsolute,
   ReferenceStyle referenceStyle,
   System.bool external,
   IRange^ relativeTo
) 

Parameters

rowAbsolute
True if the row should be treated as an absolute reference, false otherwise.
colAbsolute
True if the column should be treated as an absolute reference, false otherwise.
referenceStyle
Specfies whether A1 style or R1C1 style should be used.
external
True if the workbook and worksheet should be included in the address, false otherwise.
relativeTo
Represents the cell which this range is relative to. This parameter is unused for A1 style. It may be null to indicate relative to the top-left cell (A1).

Return Value

The string representing the address of the range.
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

IRange Interface
IRange Members

Send Feedback