Need to find previous cell for given cell address

Help Activities
,
1

Need to find previous cell address
For eg: if current cell address is AF
Then previous cell address is AE

2

Hi,

Can you try the following expression?

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("AF")-1)

This returns “AE”

Regards,

3

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