像excel一样的Python字符串序列

Question

我想要像 excel 标题一样的序列。

例如:A,B,C,..,Z,AA,AB....

我的代码

>>> s = 'A'
>>> chr(ord(s) + 1)
'B'
>>> s = 'Z'
>>> chr(ord(s) + 1)  
'['
>>> 
# I want AA after chr(ord('Z') + 1)

Answer 1

使用 itertools，

import itertools

alpha = [chr(x) for x in range(65, 91)] # create a list of character's

print(alpha + [k + v for k,v in itertools.product(alpha, repeat=2)])