Question

How can I use text automation activities to extract data from a table and display it in UiPath studio?

Answer 1

Hi @Simran, if you want to extract data from a table on a webpage and display it, you can use Extract Structured Data activity in UiPath studio. To understand better, follow the mentioned steps one by one:

1. Create a new Sequence and drag an Open Browser activity to it. In URL field write http://poloniex.com/exchange#btc_xrp
2. In the Design ribbon tab, click Data Scraping. The Extract Wizard will be displayed to scrape the Markets table from the page. An Attach Browser activity is generated, containing an Extract Structured Data activity set to retrieve the table contents.
3. Add an Output Data Table activity in the Do container of the Attach Browser activity, after the Extract Structured Data.
4. Create a new String variable, called getText.
5. Select the Output Data Table activity, enter the ExtractDataTable variable in the DataTable field, and the getText variable in the Text field of Output section.
6. Add a Write Line activity after the Output Data Table activity and insert the getText variable in the Text field.