Convert excel alphabetical characters into column numbers

[Sailaja_Pasupuleti]

Hi,

How to get index of a excel alphabetical characters say AG

Regards
Sailaja Pasupuleti

[Palaniyappan (Palaniyappan P)]

Kindly have a view on this thread buddy

Finding Column Index value in Excel

Fine the reason is there is no ASCII code for AG combined together we have for A and G in separate but here we are trying to get them together probably with value 100 but ascii for 100 is d Thats the reason why it was not getting us the right cell position so lets do one thing –First lets get the cell position out_cell = OhioCashBS770.Columns.IndexOf(State) where out_cell is a int32 value so it will be like out_cell = 32 –then another assign activity out_cellsub = (out_cell - 26)+1 wher…

Cheers @Sailaja_Pasupuleti

[Nitya1 (Nitya Tomar)]

May i know why you have subtracted 26 from it.

[balupad14 (Balamurugan)]

Hi @Sailaja_Pasupuleti,

@Nitya1 Welcome to UiPath Community !

Here is an activity called “Get Column Index” that returns the column index for the column name.

UiPath Go ! BalaReva EasyExcel Activities

Hi All, Here I have presented 2 activities Get Column Index - Get Column index by column name Get Column Name - Get Column name by column index Get Column Number (Index) [image] Get Column Name [image] Sample : ColumnIndexName.zip (22.5 KB) Thank you Balamurugan.S

Regards
Balamurugan.S