How to increment cell value by 1

Help Robot
,
1

Hi, I am using Look up range activity to find the index of particular cell. Say suppose I got the index is B7. Now I want to move to C8. I have extracted the only integer part from “B7” and stored in a variable called “Intcell”. So while writing to cell, I wrote like “C”+(IntCell+1).ToString. But it is giving me error that strictly disallow implicit conversion from string to double.
Can anyone suggest me on this? or is there any other way to achieve this?
Thanks in advance!

2

@Rohit_Patil1
“C”+((IntCell+1).ToString)
Try with this

3

Thanks for reply Sangeetha. Let me try on this.

4

Hi,

The following expression can output offset address from specific cell.

image
image1668×290 22.1 KB 

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(System.Text.RegularExpressions.Regex.Match(strCell,"^[A-Za-z]+").Value)+1)+(CInt(System.Text.RegularExpressions.Regex.Match(strCell,"\d+$").Value)+1).ToString

Please modify the above two 1 to actual offset value.

Regards,

5

Hi Thanks, but i am getting the same error.

6

Hi Yoichi, Thanks for the response. Let me try with this method.

7

Hi Yoichi. This worked. This is great approach to do in future tasks also. Thanks for the help.

1 Like
8

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