GetAddress Method (Int32, Int32, Int32, Int32, Boolean)

Office Open XML

previous page next page
Returns the AlphaNumeric representation that Excel expects for a Cell Address

Namespace:  OfficeOpenXml
Assembly:  EPPlus (in EPPlus.dll) Version: 3.0.0.1 (3.0.0.1)

Syntax

C#
public static string GetAddress(
	int FromRow,
	int FromColumn,
	int ToRow,
	int ToColumn,
	bool Absolute
)
Visual Basic (Declaration)
Public Shared Function GetAddress ( _
	FromRow As Integer, _
	FromColumn As Integer, _
	ToRow As Integer, _
	ToColumn As Integer, _
	Absolute As Boolean _
) As String
Visual C++
public:
static String^ GetAddress(
	int FromRow, 
	int FromColumn, 
	int ToRow, 
	int ToColumn, 
	bool Absolute
)

Parameters

FromRow
Type: System..::.Int32
From row number
FromColumn
Type: System..::.Int32
From column number
ToRow
Type: System..::.Int32
To row number
ToColumn
Type: System..::.Int32
From column number
Absolute
Type: System..::.Boolean
if true address is absolute (like $A$1)

Return Value

The cell address in the format A1

See Also

previous page start next page