/Python/Convert excel cellname to index python

Convert excel cellname to index python

Function columnNumber(colLetter As String) As Integer

    Dim colNumber As Integer
    Dim i As Integer

    colLetter = UCase(colLetter)
    colNumber = 0
    For i = 1 To Len(colLetter)
        colNumber = colNumber + (Asc(Mid(colLetter, Len(colLetter) - i + 1, 1)) - 64) * 26 ^ (i - 1)
    Next

    columnNumber = colNumber

End Function

Source: stackoverflow.com

Similar codes

3 votes186 views1 answer
Python tkinter filedialog folder
Python
0 vote197 views1 answer
Voting classifier grid search
Python
0 vote199 views1 answer
Shelve Data Storage
Python
0 vote180 views1 answer
Flask mongoengine configuration
Python
0 vote204 views1 answer
Pyttsx3 NameError: name 'voices' is not defined
Python
3 votes204 views1 answer
Pythone csv
Python
91 votes224 views6 answers
Python for in
Python
0 vote188 views1 answer
Python color input
Python
0 vote191 views1 answer
Kivy Python ListView Scrollview with Toggle on off
Python
10 votes184 views3 answers
Pacman 30th anniversary
Python