Column index in alphabets

Help
1

I have an excel with a few cell values
Based on the values present, I want the corresponding column index in excel in alphabets(A,B,C… )

How do I go about

1 Like
2

yah sure we can get the column index with this expression
Convert.ToChar(yourdatatablename.Columns.Indexof(columnindex)+65).ToString

Cheers @Joywin.Madtha

3

As alphabets ? Not as numbers

4

yah kindly try that and let know
@Joywin.Madtha

5

Sure.

Thanks @Palaniyappan

6

How do I get the cell values. They are randomly placed in excel

7

will you please clear your doubt?
or shae your excel

8

Screenshot_20191010-153335__01
Screenshot_20191010-153335__011080×2160 168 KB

I have to read the cell values and corresponding column index(alphabets) have to be got

9

@ImPratham45 please do take a look

10

Sequence.xaml (11.7 KB) testval.xlsx (7.9 KB)

11

@Joywin.Madtha
Have a Look on this
https://go.uipath.com/component/excel-index-to-column

WE used IT in some Bots and was working fine

EDIT / UPDATE:
with newer for UiPath Activities packages we can do it now as following:

grafik
AND
grafik

1 Like
12

I think this will support till 26 columns.

Check this as well:
https://go.uipath.com/component/convert-numbers-to-excel-column-name

13

this is not working,my result is every time coming -@

14

May I know the expression used and the output we got if possible with a screenshot

Cheers @Siddhant_Dimri