Hi, I need to convert excel column letter to index value. suppose column letter is AA, index value should be 27.

I got the solution. Thanks everyone…:slight_smile: columnLetter = columnLetter.ToUpper() sum=0 For i As Integer = 0 To columnLetter.Length-1 sum *= 26 Dim charA As Double = Asc(“A”) Dim charColLetter As Double = Asc(columnLetter(i)) sum += (charColLetter - charA) + 1 Next

Convert Excel column letter to index

Help Studio

kadiravan_kalidoss (Kadiravan K) March 11, 2020, 12:29pm 5

Refer this also.! @reshmaprabh

Thanks!

1 Like

Topic		Replies	Views
Convert Column index to column letter Activities datatable , excel , activities , question	14	10148	May 20, 2022
Convert excel alphabetical characters into column numbers Help	3	2228	July 29, 2020
Getting column index from Excel Help activities , question	13	6876	June 22, 2020
Convert column index to Excel column letter Studio	4	6135	October 20, 2021
Column index in alphabets Help	13	3184	March 1, 2020

Most Active Users - Yesterday
Anil_G
Shakib
ashokkarale
sharu_priya
sven.wullum1
Babjee.Vangipurapu
Prathamesh_Trimurti_Hulav
riley
sharazkm32
A_Learner
More details...

Convert Excel column letter to index

Related topics