Program to print column names of excel eg. a, b ... ab, ac ... az, ba ... azz, caa

Published: April 10, 2017

---

def incrementString(str1):
    arr = list(str1)
    arr.reverse()

    if ord(arr[0]) - ord('a') + 1 == 26:
        arr[0] = 'a'
        if str1[:-1] is not '':
            str1 = incrementString(str1[:-1])
        else:
            str1 = 'a'
            str1 = str1 + ''.join(arr[0])
    else:
        arr[0] = chr(ord(arr[0]) + 1)
        str1 = str1[:-1] + ''.join(arr[0])

    return str1


while True:
    val = incrementString(val)
    print(val)