How to use a number variable as row of a cell in the "Get Values (Cells)" activity in RPA?

[cdcasas187]

Hi.

I need to retrieve the values from a row of cells in excel and paste it on a web app. To do that, I have created a forever loop that iterates in the row until the active cell is empty. But I don't know how to correctly type the counter variable in the Get Values (Cells). I used several formats, and none of them worked. I need help understanding how to use the variable as the cell's row to obtain its value.

Any help would be highly appreciated!

BR.
Cristian Casas

[former_member17397 · Accepted solution]

Hello,

You have this issue because you entered the value as a string.

So you're looking for the cell "A;Step7.count" instead of "A;" + Step7.count.

Here is the correct format to use:

And to be able to write such values, I highly recommend you to open the expression editor:

Let me know if you have further questions regarding this !

Thanks a lot and best regards,

Baptiste

[cdcasas187 · Accepted solution]

It worked, thank you so much!