Convert integer to Excel column

Help
1

Hello, I have managed to get the column number e.g. 4 and I want to change this into “D” so that I can use this to write stuff in to Excel.

Any help?

3 Likes
2

Hi @mzucker

What do you mean to change the 4 to D ?

cheers :smiley:

Happy learning :smiley:

1 Like
3

please explain with a scenario, what you have stated here is too vague for us to understand what you are asking.

2 Likes
4

Sorry guys, for example, I have got the column number/index in a datatable (4). I have also got the row number e.g. 4. In VBA, I would write this as (4,4) but UiPath does not allow me to do this as I would need to write it as (D4). Therefore, is there a way to convert the integer 4 to the corresponding alphabet/Excel letter (D)

Sorry for any confusion!

2 Likes
5

Hi @mzucker

Actually i dont get the issue but if you want to transform the 4 to D just use simple case is fine.

cheers :smiley:

Happy learning :smiley:

1 Like
6

what is simple case?

2 Likes
7

Hi @mzucker

See this link for your reference.

cheers :smiley:

Happy learning :smiley:

1 Like
8

Hello @mzucker

use this code
Convert.ToChar(Convert.ToUInt16("@"c)+4)

you can also start with A but then to get D you’ll have to add 3
Convert.ToChar(Convert.ToUInt16("A"c)+3)

Use what suits you the best !!!

As @DanielMitchell said below the above could work for 26 letters.You could always get two letter by using an IF condition and assigning the above code twice with a + sign like this

Convert.ToChar(Convert.ToUInt16("A"c)+3)+Convert.ToChar(Convert.ToUInt16("A"c)+3)

So If the digits are higher then I would suggest you to use @DanielMitchell link i tried the logic and methods used in that link and it works flawlessly. :slight_smile:

Check the workflow below it contains logic used in that link
ColumnLetterFor.xaml (7.3 KB)

5 Likes
9

@mzucker

The formula at the link above should help you. This will work for any number of columns, including higher than 26 where excel has “AA” and so on.

2 Likes
10

Hello, here is the code that converts any index to a column name :slight_smile: ChangeColumnNoToName.xaml (11.6 KB)

6 Likes
11

Hi,
Converting the Excel Column type . you can use the “ChangeCellType”. Which is existing in the below link.

Regards
Balamurugan.S

12

You can directly use this XAML. Hope it helps.

ExcelGetColumnNumberFromLetter.xaml (6.0 KB)