Increment alphabet in excel

Hello,

Can anyone help with the following problem I am facing? I am currently building some automation where I am looking for a certain string in an excel spread sheet. If found I must then look for next available empty cell in that particular row until I find an empty cell and then write to that cell.

The issue is I can’t seem to be able to increment alphabetically - so if my string is found in cell B20 I then need to check C20 and D20 etc until I find the next empty cell but how to I increment alphabetically instead of numerically? that is the only part I need help on.

Thanks

Hi @cbot ,

Welcome to UiPath Forum.

Could you pls review below thread it might helpful for your requirement on incrementing alphabet or character in uipath. Thanks.

Have a Look Here in the helper Methode

col.ColumnName = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(yourcolindex)

1 Like