Hello I am trying to select all the rows shown in image on “plan code” column but i don`t want to select row which starts with number “19004” . (all highlighted rows will be selected though)
Hi
I think you are trying to click this on a application and not on a excel file
- In that case use FIND CHILDREN activity and get the descendants and save it in a variable named out_childrens
-
Then use a FOR EACH activity and pass the above output variable and inside the loop use a GET ATTRIBUTE activity and pass the input as item and get the output of attribute aaname or innerText as a string variable named str_arg
-
Then inside the same loop use a IF condition and check like this
** NOT str_arg.ToString.StartsWith(“19”)**
If true it goes to THEN block where use a CLICK activity
- Use a assign activity and mention like this
sel_argument = str_arg
Where sel_argument is a string variable
-
With that click activity initially click on a element under that column and get the selector
-
Edit that selector in a way like replace the attribute value which has the column values with a variable that we created above sel_argument
Here you go on how to create a variable
Now it will click on each element one by one
Hope this would help you resolve this
Cheers
If you want to filter the rows in Excel which is starting other than "19004"Check below for your reference
Hope this may help you
Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.