/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

2 votes259 views3 answers
Python count of values in array
Python
7 votes258 views2 answers
How to get the remainder in python
Python
0 vote266 views1 answer
Msg91 python
Python
3 votes269 views1 answer
Ipython autoreload
Python
0 vote273 views1 answer
DRf Representation
Python
17 votes262 views5 answers
Find all occurrences of an element in a list python
Python
0 vote261 views1 answer
Create pytorch zeros
Python
0 vote339 views1 answer
Django custome login
Python Django
0 vote269 views1 answer
Pandas backward fill after upsampling
Python
0 vote273 views1 answer
TypeError: 'LazyCorpusLoader' object is not callable
Python