Skip to content

Instantly share code, notes, and snippets.

@CodeByAidan

CodeByAidan/get_excel_column_letter.py

Last active August 15, 2024 13:57
Show Gist options
  • Save CodeByAidan/d18f8d6dfdc2d1f8896f2cbf6a4e023e to your computer and use it in GitHub Desktop.
Save CodeByAidan/d18f8d6dfdc2d1f8896f2cbf6a4e023e to your computer and use it in GitHub Desktop.
Download ZIP
Convert column index to Excel column letter
Raw
get_excel_column_letter.py
def get_excel_column_letter(col_idx: int) -> str:
letter = ""
while col_idx > 0:
col_idx, remainder = divmod(col_idx - 1, 26)
letter: str = chr(65 + remainder) + letter
return letter
# EX:
# >>> get_excel_column_letter(49)
# 'AW'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment