/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 votes344 views6 answers
Create a dataframe python
Python
0 vote301 views1 answer
Python proxy scraper
Python
6 votes346 views1 answer
Change dataframe value by index
Python
16 votes329 views3 answers
List mean python
Python
0 vote329 views1 answer
Django amzon like app
Python Django
2 votes335 views1 answer
How to create a loop in python turtle
Python
0 vote314 views1 answer
Check if a the time is 24 hours older python
Python
0 vote302 views1 answer
Ordenar lista python
Python
0 vote306 views1 answer
A python string
Python
0 vote322 views1 answer
Printing a range of no one line in python
Python