/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 vote131 views1 answer
Python arithmetic operation with list
Python
0 vote111 views1 answer
First hitting time python
Python
10 votes120 views2 answers
Convert hex to decimal python
Python
0 vote117 views1 answer
Python skip input
Python
0 vote114 views1 answer
Access value of posted object python
Python
2 votes114 views1 answer
How to check if all characters in string are same python
Python
0 vote117 views1 answer
Remover espaços string python
Python
18 votes111 views3 answers
String Slices
Python
0 vote102 views1 answer
Repeats in python
Python
0 vote103 views1 answer
Extract n grams from text python
Python