How to itterate alphabet?

Help Activities
, ,
1

this code:

Convert.ToChar(Convert.ToUInt16("A"C)+Counter)

just able to itterate until Z, i want it to itterate to unlimited letter if possible.
for example until ZZZ.
How to achieve this?

2

do this instead

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(number)

where number is integer variable
e.g.
number=1 will return A
number = 26 returns Z
number = 100 returns CV
number = 1000 returns ALL
and so on…

1 Like
3

is this package or what?

4

Hi @wija,

I imagine you will need UiPath.Excel.Activities to do it:
image

1 Like
5

no just need excel activities which is already there. just try to use it…

1 Like
6

OK this works the way i want.

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.