SpreadsheetGear
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

Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 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.