Enable Javascript in your browser and then refresh this page, for a much enhanced experience.
First solution in Clear category for Excel Column Number by kazuki.h
import string
ALPHABET = string.ascii_uppercase
ALPHABET_num = {c: ALPHABET.index(c) for c in ALPHABET}
def column_number(name: str) -> int:
return ALPHABET_num[name] + 1 if len(name) == 1 else column_number(name[:-1]) * 26 + ALPHABET_num[name[-1]] + 1
Dec. 11, 2021
Comments: