Convert Excel column letter to index

[nerlichman (Nicolas Erlichman)]

You could also use this snippet from the marketplace:
https://go.uipath.com/component/convert-numbers-to-excel-column-name

Or take a look into this solution from @Palaniyappan

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…