How to Increment a three letter string for a variable

I’m trying to create a three l prefix for a certain series of code, like for example, AAA → AAB and AAZ → ABA. I found some Alphabet Increments online, but they usually use it in excel. I want to put this code in a variable, since I need to put it on an email.

1 Like

use this function
UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(number)

where number is an integer

If number = 1 it return “A”,
number = 27 return AA
if number = 703, it will return “AAA”
number = 704…return “AAB”
and so on…
image

2 Likes

Thanks. I’ll just increment it until it reach 18278(ZZZ).

1 Like

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