How can I extract data from table in client’s win app

[ronanpeter]

This is how it works.

1. Find Children returns all descendant elements of the table which align to the value in the activity’s filter property ( e.g. "<webctrl idx='1' parentid='overview' tag='P' />" ). This is output to a list variable. You should edit the filter to align to whatever identifies a row in your table combined with a wildcard (e.g. “<webctrl row=*”).

2. Each item in this list, which is a UiPath.Core.Uielement object. In your case, these objects are instances of rows. To see if you are on the correct path, output the selectors for the elements collected using a For Each loop on the variable and write each item selector to a text file (item.selector.tostring). Maybe post the output here so we can help you understand it.

3. If all is well, then each object represents a row and a simple count of the number of objects in the list variable will provide you the number of rows in the table.

Some examples of how Find Children is used:

Data scraping from a single page

You should look at the Find Children activity, for which there are numerous examples on the forum on how to apply it. It will allow you to grab individual fields from the page and add them to a predefined datatable as you go along. This is how I would be most comfortable doing it, however, I will leave it to you to look over the details of how it works. It takes some up front analysis of the web page and the selectors which align to the data you want to grab. Once you understand this, you can u…

Clicking each row of a specific column in a table on a website

I want to click each row of the column “Dokumente”. My current solution is to do a Data Scraping of the table (selecting column “Dokumente” and one other column). Then I implemented a “For Each” activity referring to the output variable (DataTable; Default: NewSystem.Data.DataTable) of the Data Scraping. Then I come to the first issue: The “Double Click” I implemented thereafter is not working. The robot always clicks the first row (in a loop → so it would be endless without any progress) S…