i got a scenario where in my excel file it read in a loop it go over the first row then 2nd etc
during the first row after pasting the information in the html there this Add button in the html page how can i make sure that after read finish the excel loop
it dont press this Add button as it dont exist anymore ?
Example best will be google.com
say i paste in the search it press search
but after it read finish the excel it shouldnt press the search button anymore
@xxGoRpa
1.After reading the excel with read range work book create a variable = dt
2.Pass that variable in the for each row activity
3. if suppose excel has 10 rows it i will click if the excel has empty it will not click
4. in body you can pasting the information in the html there and Add button all can do there
i see so i read each row in my database this will able to prevent after end of excel do the press add button ?
Which loop are you using
if you want to perform same steps for all the rows then use for each
if you are using any other loop with indefinite number and want to stop once the button is not found then use check app state and check for button and end the loop
cheers
Hi @xxGoRpa
you can see the below screenshot
if the excel as no rows it will not go inside the loop and also not click the add button
and dont keep any click add button for off the loop
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
