Increment Alphabet

How to Increment Alphabet

EX1: Input: AC → Output-> AD
EX2: Input: E → Output-> F

Just get the index of any column and add 1 to it and use below code.

NumbertoAlphabet.xaml (7.2 KB)

2 Likes

@Sweety_Girl
as already mentioned by others in your other post:

Column as Letter to Int
have a second look on the connect platform or use activity from below as well and write a converter (do while, increase an int counter until Column letter is returned, when passed to the snippet)

(For a macro / invoke vba based approach have a look here: VBA Code To Convert Column Number to Letter Or Letter To Number)

int to Column Letter:

EDITED / UPDATE:
nowadays we can do:
grafik

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(YourColIndex)
UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("YourColLetter")
1 Like

Hey @Sweety_Girl

Please try the workflow given in this post. That really works.

Regards,
Krishna C

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