Increment column range logic

Help Activities
, ,
1

I have a weekly report that I want the bot to automatically generate for me but I want to create a logic for my bot to specifically increment the column range logic.

Initialize variable, variable is a excel column range:
strStartofWeek = “AZ” (Last thursday)
strEndofWeek = “BC” (Today, Tuesday)

Is there a way to build a logic to increment column range?

For example:
Check day if its not Thursday
New day calculation = “BC” + 1 = “BD”

Once check if its Thursday,
New week calculation = “AZ” + 7 = “BG”

2

Hi,

The following post will help you.

We can use the following expression.

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("BC")+1)

Regards,

3

Bingo man! I dont know what to search but this is exactly what I want. Thank you ya

1 Like
4

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