How to Increment Alphabet
EX1: Input: AC → Output-> AD
EX2: Input: E → Output-> F
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)
@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:
UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(YourColIndex)
UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("YourColLetter")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.