Datatable click

I want to open the window by clicking on the red square one by one and put the data in that window into Excel. Once I’ve entered Excel, I’d like to turn off that window, press the next column, and repeat to put all 59 data. You are currently not repeating the click.

Hi @wjdehdnr456

Please check the below thread:

Regards

1 Like

Hi @wjdehdnr456

→ You can use the Extract datatable activity to extract the data into a datatable.
→ Use for each row in datatable activity to iterate each row in datatable,
→ Inside for each Insert an assign activity to store the column value.
→ After assign activity insert the click activity and indicate the first option in the web browser, when indicating the first option check the strict selector and uncheck the fuzzy and Image and validate.
→ Open the Properties of Click activity and open strict selector, then open Ui Explorer, choose a attribute which contains the row value, for that attribute pass the variable that we have created for that attribute the validate.
→ After click activity insert other activities for your further process.

It will iterate through the each row in datatable in web browser.

Hope it helps!!

1 Like

I want to know the modified part of click

Hi @wjdehdnr456

Store the currentitem.tostring value into a variable and use the Ui Explorer option and then pass the variable into that. so that the variable gets dynamic and then the click acts according to the value extracted.

Regards

1 Like

Hi @wjdehdnr456


Open the above highlighted one if the aaname or else innertext is not visible.

Regards

1 Like

I did it like this, but I can’t

Possible solutions:
• Verify that the application is open and that the UI element is displayed on the screen at runtime.
• Edit targets for UI activities and use validation to debug issues.
• Redefine the element when the element properties change, if necessary.
• Use the “Check state” activity to check the application status before running the action.
• Increase the value of “Next Previous Delay” to allow time for the application to be rendered and responded globally.

Hi @wjdehdnr456

Is the validation done for that?

Have you assigned the default value to the variable?

Regards

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