Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.ColLetterToNumber Method

Explanation Converts an alphabetic string in a column header to the corresponding column number.

For example, "A" is converted to 1, "B" is converted to 2, and "AA" is converted to 27.
Call format ColLetterToNumber(letter)
Return value Column index
Arguments letter Alphabet string in column header
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 ColNumberToLetter method