/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 vote232 views1 answer
Python diffie hellman
Python
1 vote247 views1 answer
Import CSV Files into R Using read.csv() method
Python
8 votes253 views6 answers
Python functions
Python
0 vote227 views1 answer
Pyspark rdd method
Python
1 vote234 views1 answer
That, given an array a of n integers, returns the smallest positive integer (greater than 0) that does not occur in a. python
Python
0 vote215 views1 answer
Python. printing varibles
Python
0 vote213 views1 answer
Template tag django
Python
0 vote220 views1 answer
Make beep python
Python
5 votes217 views1 answer
Check if special character in string python
Python
2 votes261 views1 answer
Django create model from dictionary
Python Django