Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.ColNumberToLetter Method

Explanation Gets the alphabetic string in the column header that corresponds to the column number.

For example, 1 can get "A", 2 can get "B", and 27 can get "AA".
Call format ColNumberToLetter(num)
Return value Alphabet string in column header
Arguments num Column index
Exception None
Example of use 
    print(ColLetterToNumber("A"), "\n");
    print(ColLetterToNumber("B"), "\n");
    print(ColLetterToNumber("Z"), "\n");
    print(ColLetterToNumber("AA"), "\n");
    print(ColLetterToNumber("AB"), "\n");
    print(ColNumberToLetter(1), "\n");
    print(ColNumberToLetter(2), "\n");
    print(ColNumberToLetter(26), "\n");
    print(ColNumberToLetter(27), "\n");
    print(ColNumberToLetter(28), "\n");
Related item ColLetterToNumber method