UiPath Data Scraping (Web Page to Excel) - Tutorial

Опубликовано: 07 Октябрь 2024
на канале: Anders Jensen

58,590

414

In this tutorial, you will learn how to use Data Scraping in UiPath to scrape data from a website, place it in a Data Table and present it in Microsoft Excel afterward. You will see two practical examples where the last one will have problems with the ‘Next Link Selector’. Here we will solve the problem by creating a dynamic selector and a simple While Loop.

You could also watch:
🔵 Data Scraping Beginners Guide -    • UiPath Basics #10 - Data Scraping to ...
🔵 UiPath Beginners Tutorial -    • UiPath RPA Beginners Tutorial [2020]
🔵 Try Open Source Data Scraping with OpenRPA -    • How to scrape data from a website wit...
🔵 UiPath Data Scrape from Amazon to Excel -    • UiPath - How to Data Scrape from a we...

00:00 Intro

00:30 Data Scraping case #1 - Strava
The first use case scrapes data from Strava, a social network for running and cycling tracking.

02:35 UiPath Data Scraping
We are using the build-in Data Scraping guide in UiPath. By selecting two elements in the structured data, UiPath recognizes the entire data set, including that the data spans multiple pages (the Data Scraping will automatically click the next page).

03:30 Renaming Data Table
To operate within the best practices for UiPath, we are renaming the Data Table to camel format.

03:55 Export data to Excel
With a Write Range, we are exporting the scraped data to an Excel sheet.

06:30 Data Scraping case #2 - 'Smiley-ordning'
Scraping the data from the Food Control (applied by the Danish Government) web page. Again, we indicate that our data is spanning multiple pages and renaming the data table to fit the UiPath best practice standard.

08:32 Write out the scraped data to Excel

10:15 Fixing the Problem - creating a dynamic selector
To do Data Scraping that can target multiple pages, when the build-in wizard fails, we create a dynamic selector.

13:36 Element Exist
We are asking if the "Next Page" button exists.

14:18 Creating a While Loop to scrape the Data
If yes, then click it and scrape the data.

18:34 Bingo 😄

FOLLOW ME:
💼 LinkedIn:   / andersjensenorg
🐦 Twitter:   / andersjensenorg
📸 Instagram:   / andersjensenorg
👨 Facebook:   / andersjensenorg
👨‍👩‍👧‍👦 Discord:   / discord
💌 Email Newsletter: https://andersjensen.org/email-newsle...

📂Get the files from the video
https://1drv.ms/u/s!Al9RjoWZcShJiNouB...

#uipath #webscraping #datascraping