The alphabet after Z

Help Activities
,
1

weekFirst = System.Text.RegularExpressions.Regex.Replace(DaysLocation, “[^a-zA-Z]+”,String.Empty)
weekFirstAlphabetNumber = (Asc(weekFirst) - asc(“A”) +1) + 4
FridayLocation = Chr(Asc(“A”) + weekFirstAlphabetNumber -1)+weekSecond.ToString

In this way, the alphabet comes out as much as +4 in Monday’s Excel position, but if the ‘Z’ goes over, the ‘[’ comes out.
After “Z”, I want to make it come out like “AA”, “AB”, and “AC”

2

Hi,

Can you try UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter method as the following?

image

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

Regards,

1 Like
3
1 Like
4

I’m increasing the alphabet by +4 using ‘for attach’. M → T → AA should come out, but M → T → ‘[’ comes out

5

have a look here:
grafik

done with:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

1 Like
6

Hi,

Can you try the following expression?

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("T")+7)

image
image1109×239 11 KB

Regards,

1 Like
7

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