Function Reference


_Excel_ColumnToLetter

Converts the column number to letter(s)

#include <Excel.au3>
_Excel_ColumnToLetter ( $iColumn )

Parameters

$iColumn The column number which you want to turn into letter(s)

Return Value

Success: the column letter(s).
Failure: "" and sets @error.
@error: 1 - $iColumn is not a number

Related

_Excel_ColumnToNumber

Example

#include <Excel.au3>
#include <MsgBoxConstants.au3>

; Translate a column number to the Excel column letter
Local $iCol = 676
Local $sLetter = _Excel_ColumnToLetter($iCol)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_ColumnToLetter Example 1", "Error converting number to letter." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_ColumnToLetter Example 1", "Number: " & $iCol & " = Letter: " & $sLetter)