How to do Web Scraping with UiPath - Use Case
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 - https://youtu.be/3ZKzTHdpsTs
🔵 UiPath Data Scraping (Web Page to Excel) - https://youtu.be/vIAJvk4quqA
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: https://geni.us/v6ffI 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: https://youtu.be/MdNVjWWkD98
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: https://youtu.be/uCdBC2pXPyY
Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeanders?sub_confirmation=1
💼 LinkedIn - https://www.linkedin.com/in/andersjensens/
👥 Facebook - https://www.facebook.com/andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsletter/
#uipath #rpa #automation
Видео How to do Web Scraping with UiPath - Use Case канала Anders Jensen
You could also watch:
🔵 UiPath RPA Beginners Tutorial - https://youtu.be/3ZKzTHdpsTs
🔵 UiPath Data Scraping (Web Page to Excel) - https://youtu.be/vIAJvk4quqA
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: https://geni.us/v6ffI 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: https://youtu.be/MdNVjWWkD98
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: https://youtu.be/uCdBC2pXPyY
Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeanders?sub_confirmation=1
💼 LinkedIn - https://www.linkedin.com/in/andersjensens/
👥 Facebook - https://www.facebook.com/andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsletter/
#uipath #rpa #automation
Видео How to do Web Scraping with UiPath - Use Case канала Anders Jensen
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Web Scraping With UiPath](https://i.ytimg.com/vi/vDxgfcnaZco/default.jpg)
![UiPath Document Understanding - Invoice Data Extraction (Full Tutorial)](https://i.ytimg.com/vi/cp1hbChzUQ4/default.jpg)
![How to do API calls in UiPath | Full Tutorial](https://i.ytimg.com/vi/HiS_lQ1wbD4/default.jpg)
![Work with Files and Folders in Power Automate Desktop](https://i.ytimg.com/vi/bWUdUrCvfiY/default.jpg)
![UiPath Tutorial For Beginners | RPA Tutorial For Beginners | UiPath Training Online | Edureka](https://i.ytimg.com/vi/kVtgA_PQ5R4/default.jpg)
![UiPath | How to Read Excel Data, do an Online Search and write the result in the next Column | Guide](https://i.ytimg.com/vi/9HxtyuAiPTk/default.jpg)
![How to Extract Multiple Web Pages by Using Google Chorme Web Scraper Extension](https://i.ytimg.com/vi/Gz3fbdXnjmw/default.jpg)
![How to extract data from PDF's with RegEx in UiPath - Full Tutorial](https://i.ytimg.com/vi/uCdBC2pXPyY/default.jpg)
![How to use Excel in Power Automate Desktop](https://i.ytimg.com/vi/Xtc3bHcDrW4/default.jpg)
![UiPath: Browsers (open, fix problems, click, type into web fields and how to close down)](https://i.ytimg.com/vi/gQ0d4aWIu0U/default.jpg)
![News from OpenRPA and Data Scraping to Excel Tutorial](https://i.ytimg.com/vi/9E_jIxxITpQ/default.jpg)
![RPA Challenge StudioX - UiPath StudioX Tutorial](https://i.ytimg.com/vi/SWPXDoDyZxo/default.jpg)
![UiPath Data Scraping (Web Page to Excel) - Tutorial](https://i.ytimg.com/vi/vIAJvk4quqA/default.jpg)
![How to select dates from a Date Picker with UiPath - Full Tutorial](https://i.ytimg.com/vi/G5s2YZZd49E/default.jpg)
![How to parse specific XML data in UiPath - Full Tutorial](https://i.ytimg.com/vi/iaaSYul29uE/default.jpg)
![How to Copy a File with a Dynamic Name in UiPath - Full Tutorial](https://i.ytimg.com/vi/PCxO1b1KkGo/default.jpg)
![UiPath Web Automation | Automate Web Data Extraction - UiPath Studio | UiPath Training | Edureka](https://i.ytimg.com/vi/96pDRsPbb10/default.jpg)
![UiPath - How to loop through rows and columns in Excel and pass values to web search/input](https://i.ytimg.com/vi/LVHwmq7QVmI/default.jpg)
![UiPath Tutorial 16 - Read data from Config File | Write Config File Data to Dictionary Variable](https://i.ytimg.com/vi/woBpbt3adBE/default.jpg)
![UiPath Tutorial 14 - Web Automation UiPath Example | Excel to Web Automation in UiPath](https://i.ytimg.com/vi/Ch5bk8AABZQ/default.jpg)