Increment alphabet in excel

[cbot]

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

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

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.

Incrementing character

I have a variable alphaName=“A”. I want to increment its value till “Z”. How do I do this using UiPath.

[ppr (Peter Preuss)]

Have a Look Here in the helper Methode

How to give column name selected data

in addition to you can do a generic datacolumn naming by following: [grafik] TypeArgument: DataColumn It will create columnnames like Col0,Col1,… as much Columns are present within the datatable The naming schema can be adopted as well E.g. col.ColumnName = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(idx + 1) will create Columnname like A,B,C, …AA,AB,… We would also recommend to do some initial filterings on empty rows and unneeded columns

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