Cell.ResolveCellAddress Method

NanoXLSX

NanoXLSX

CellResolveCellAddress Method

Gets the address of a cell by the column and row number (zero based)

Namespace:  NanoXLSX
Assembly:  NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)
Syntax
C#
public static string ResolveCellAddress(
	int column,
	int row,
	CellAddressType type = CellAddressType.Default
)

Parameters

column
Type: SystemInt32
Column number of the cell (zero-based)
row
Type: SystemInt32
Row number of the cell (zero-based)
type (Optional)
Type: NanoXLSXCellAddressType
Optional referencing type of the address

Return Value

Type: String
Cell Address as string in the format A1 - XFD1048576. Depending on the type, Addresses like '$A55', 'B$2' or '$A$5' are possible outputs
Exceptions
ExceptionCondition
RangeExceptionThrows an RangeException if the start or end address was out of range
See Also