Column index in alphabets

[Joywin.Madtha]

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

[Palaniyappan (Palaniyappan P)]

@Joywin.Madtha

Based on the values present, I want the corresponding column index in excel in alphabets(A,B,C… )

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

Cheers @Joywin.Madtha

[Joywin.Madtha]

As alphabets ? Not as numbers

[Palaniyappan (Palaniyappan P)]

yah kindly try that and let know
@Joywin.Madtha

[Joywin.Madtha]

Sure.

Thanks @Palaniyappan

[Joywin.Madtha]

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

[ImPratham45 (Prathamesh Patil)]

will you please clear your doubt?
or shae your excel

[Joywin.Madtha]

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

[Joywin.Madtha]

@ImPratham45 please do take a look

[ImPratham45 (Prathamesh Patil)]

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

[ppr (Peter Preuss)]

@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:

AND

[sarathi125 (Parthasarathi)]

@Palaniyappan

Convert.ToChar(yourdatatablename.Columns.Indexof(columnindex)+65).ToString

I think this will support till 26 columns.

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

[Siddhant_Dimri]

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

[Palaniyappan (Palaniyappan P)]

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

Cheers @Siddhant_Dimri