Column 76686766181 in Excel called INFINITY
def colname(x):
if x == 0:
return ''
else:
(q, rm1) = divmod(x - 1, 26)
return colname(q) + chr (ord ('A') + rm1)
a = 76686766181
print (colname (a))
print (colname (a) == 'INFINITY')
ran63 ms
INFINITY True
No comments yet.