This video tutorial shows, how to Web Scrape in UiPath with a simple use case. We read data from Excel, perform Amazon searches and data scrape back to Excel.

You could also watch:
🔵 UiPath RPA Beginners Tutorial - [ Ссылка ]
🔵 UiPath Data Scraping (Web Page to Excel) - [ Ссылка ]

0:00 Presenting the UiPath use case
We want to read an Excel sheet with topics, search the topics online (Amazon) and then scrape data back to Excel.

0:50 Open Browser
Specify the URL in a variable and place the variable in the Open Browser activity.

1:44 Excel Application Scope and Read Range
Read our Excel data into a Data Table.

3:08 Looping through our data
With a For Each Row we can loop through our Data Table data with search input. In the start of each loop remember to navigate to our start URL.

4:00 Type in our Amazon search
With a Type Into we type in our search in the Amazon search field. Here (and a lot of other places, we use VB .NET code. If you want to master it, I can recommend this book: [ Ссылка ] I will get affiliate, if you order the book fyi).

4:59 Web Scrape Wizard
We use the Data Scraping Wizard in UiPath to define what we want to scrape. Do remember that we can only scrape structured data with this wizard. If your data is unstructed, you can use this guide instead: [ Ссылка ]

7:00 Write our data back to Excel
With a Write Range we write our scraped data back to Excel

8:16 Close our Browser
With a Close Application we close our browser, in this case Internet Explorer. We tune the selector a bit.

10:19 Verifying our scraped data
We have the data in our wanted columns and rows. Do you want to work more with the data, I will recommend you to use Regex, which is a powerful extraction language. And quite easy to learn. Check this where I extract data out of an invoice: [ Ссылка ]

Connect with me:
🔔 Subscribe - [ Ссылка ]
💼 LinkedIn - [ Ссылка ]
👥 Facebook - [ Ссылка ]
💌 Email Newsletter - [ Ссылка ]

#uipath #rpa #automation

свернуть