/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

0 vote184 views1 answer
Numpy sort row by
Python
0 vote173 views1 answer
How to get ********** on python
Python
0 vote179 views1 answer
Colorbar font size python
Python
1 vote221 views1 answer
Django filter not equal to
Python Django
0 vote168 views2 answers
Django create view filter options
Python
0 vote193 views4 answers
Create a python for loop that sums the numbers from 100 to 200
Python
0 vote164 views1 answer
Python index of lowest value in list
Python
-2 votes215 views1 answer
Do i need do some set when i use GPU to train tensorflow model
Python
3 votes176 views1 answer
How to stop python for certain time in python
Python
0 vote161 views1 answer
How to install gym
Python