SpreadsheetGear 2010
GetAddress Method
See Also  Send Feedback
SpreadsheetGear Namespace > IRange Interface : GetAddress Method

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).
Returns a string representing the address of the range.

Syntax

Visual Basic (Declaration) 
Function GetAddress( _
   ByVal rowAbsolute As Boolean, _
   ByVal colAbsolute As Boolean, _
   ByVal referenceStyle As ReferenceStyle, _
   ByVal external As Boolean, _
   ByVal relativeTo As IRange _
) As String
C# 
string GetAddress( 
   bool rowAbsolute,
   bool colAbsolute,
   ReferenceStyle referenceStyle,
   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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.