/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

13 votes193 views4 answers
Update anaconda
Python
10 votes142 views2 answers
Python create file if not exists
Python
0 vote136 views1 answer
Print Wavelet modes
Python
0 vote182 views1 answer
Delay print in python
Python
39 votes148 views4 answers
How to make a comment in python
Python
0 vote113 views1 answer
Check if environment variable exists
Python
0 vote143 views1 answer
Lowercase all text in a column
Python
0 vote138 views1 answer
Menu with icons tkinter
Python
2 votes153 views1 answer
Python convert a string to a list of words
Python
24 votes153 views1 answer
Creating a new enviroment in conda
Python