/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

43 votes217 views6 answers
Pygame draw line
Python
3 votes222 views1 answer
Find unique char in string python
Python
1 vote222 views1 answer
Django return only part of string
Python Django
-1 vote205 views2 answers
Print tables in python
Python
1 vote206 views1 answer
Delimiter pandas
Python
32 votes215 views6 answers
Else if python
Python
8 votes206 views2 answers
Find max in a dataframe
Python
0 vote225 views3 answers
Split credit card number python
Python
14 votes195 views2 answers
How to read a website in python
Python
0 vote217 views1 answer
Django template datetime-local
Python