Issue
I'm looking for the opposite to this Q&A: Convert an excel or spreadsheet column letter to its number in Pythonic fashion.
or this one but in python How to convert a column number (eg. 127) into an excel column (eg. AA)
Solution
start_index = 1 # it can start either at 0 or at 1
letter = ''
while column_int > 25 + start_index:
letter += chr(65 + int((column_int-start_index)/26) - 1)
column_int = column_int - (int((column_int-start_index)/26))*26
letter += chr(65 - start_index + (int(column_int)))
Answered By - sundar nataraj
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.