/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

8 votes165 views2 answers
Import math sqrt python
Python
0 vote167 views1 answer
Python pandas return column name of a specific column
Python
46 votes166 views6 answers
Python random list
Python
109 votes172 views6 answers
Python check if string contains substring
Python
10 votes162 views6 answers
Merge dicts python
Python
0 vote196 views1 answer
Pivot tables pandas explicación
Python
59 votes167 views3 answers
Join() python
Python
0 vote172 views1 answer
How to make an app like word in python
Python
0 vote168 views1 answer
Turn of warning iin python
Python
0 vote184 views1 answer
Aioredis pubsub example
Python