GetAddress Method (Int32, Boolean, Int32, Boolean)

Office Open XML

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 Row,
	bool AbsoluteRow,
	int Column,
	bool AbsoluteCol
)
Visual Basic (Declaration)
Public Shared Function GetAddress ( _
	Row As Integer, _
	AbsoluteRow As Boolean, _
	Column As Integer, _
	AbsoluteCol As Boolean _
) As String
Visual C++
public:
static String^ GetAddress(
	int Row, 
	bool AbsoluteRow, 
	int Column, 
	bool AbsoluteCol
)

Parameters

Row
Type: System..::.Int32
The number of the row
AbsoluteRow
Type: System..::.Boolean
Absolute row
Column
Type: System..::.Int32
The number of the column in the worksheet
AbsoluteCol
Type: System..::.Boolean
Absolute column

Return Value

The cell address in the format A1

See Also