Working with variables

[absentia8]

Hello.
Faced another problem with variables. I would be grateful if you help me.

Task: double click on each row in Excel.

Here is the original:

Here's what I changed:

The question is, why didn't it work for me?
What did I do wrong?
How should I write correctly so that my idea works for me?

[Nived_Nambiar]

Hi @absentia8 

so you want to click each row in excel or a particular cell in each row 

It would be helpful if you can share screenshot of excel file as well 

Also please specify what you are trying to acheive here 🙂

[absentia8]

Hello @Nived_Nambiar . Glad to see you.

I am trying to click into each cell.
I took a screenshot where I want to first click on cell 1 and so on.

[Nived_Nambiar]

Hi @absentia8 

Have you used test selector option to test selector by change the Id value to S1, S2, S3 etc ?

i have tried below selector to click cells A1, A2, A3 etc under A column like below

it is working fine 🙂

could you try the way above i have mentioned 🙂

[absentia8]

Have you used test selector option to test selector by change the Id value to S1, S2, S3 etc ?

-Yes

Thanks for the answer @Nived_Nambiar .

This method you described also works for me.
But the task is a little different. You are on the right track!

Please look at my very first screenshot and also at the second screenshot.
Do you understand what I want to do?

I'll try to explain in more detail:
I previously dropped my Excel file here in the Topic. The method that you suggested to me - it works. BUT. Imagine if there are a lot of such cells and FOR EACH cell I need to click the mouse. Then your proposed method no longer works, because each time the PAD will click on the same cell with the mouse. (When I used the test selector option, it only recognizes it as "S2")
If you look at my second screenshot, I wanted to implement this through a variable. I set the value of the variable "2" and on the next pass to the FALL, this value "2" changed to the value "3", "4", "5" and so on, and this would completely suit me.
But PAD refuses to understand me and I hope that you will understand me and help me.

Please ask me if I didn't explain clearly.
This is a very simple problem, but I don't understand how to solve it.

[Nived_Nambiar · Accepted solution]

Hi @absentia8 

This works for me perfectly !

it is able to click each cell under the A column when iterated through 2,3,4,5 🙂

Try this kind of selector 

hope it helps !

[absentia8]

Thanks for the answer @Nived_Nambiar .
Could you send me a more detailed screenshot of your PAD?
I did everything as you wrote, but I did not understand how I should set up the "LoopIndex" function so that my stream is error-free?

[Nived_Nambiar]

Hi @absentia8 

Try like below

Additionally after clicking on cell, i have used Down hotkey so that next cell becomes visible to click (or you can use down arrow itself to move cell by cell :))

[absentia8]

Thanks for the answer @Nived_Nambiar , I almost got my plan, except for one moment.

I recorded a short video that shows that the PAD does not click on the "Down" button when the text in the cell is on the very last line.

https://dropmefiles.com/O0hph 
Instead, it does not go to the next cell below, but immediately to the eleventh (skipping cells 3,4,5,6,7,8,9,10)
What do I need to do to make my PAD work on EVERY cell?

[Nived_Nambiar]

Hi @absentia8 

Somehow i am not able to access the link due to some restrictions, if possible could you share the screenshot of the flow ?

[absentia8]

Expensive @Nived_Nambiar .
I can't send you a screenshot because the screenshot alone won't tell you the problem.

Could you please download the file from the video I posted on another resource?
I will be glad if you use vpn if you can't download it.

https://drive.google.com/file/d/10PPsugw0FGeEyP4lkJYW4L4SERq654fl/view?usp=sharing 

[Nived_Nambiar]

Hi @absentia8 

Is highlighted cell is a merged cell ?

[absentia8]

Hello @Nived_Nambiar .
Thank you that I have not bothered you yet and you continue to try to help me.
Answer: this is the most common and standard cell. There are many lines in this cell. If I expand this column "S", then there are fewer rows. Everything is as usual in Excel.