Table Extraction With Infinite Scrolling In UiPath - Full Tutorial
12.3 هزار بار بازدید -
2 سال پیش
-
This full video tutorial shows
This full video tutorial shows how to extract tables from web pages with infinite scrolling in UiPath Studio. First, you learn how to use the Table Extraction wizard in UiPath while we work on an actual use case. Later in the use case, we do data filtering with the Filter Data Table activity and LINQ.
VIDEOS FOR YOU:
🔹 Complete UiPath Course: • Playlist
🔹 My RPA Developer Salary: https://www.seevid.ir/fa/w/KDaTZDo8LVM
👨👩👧👦 Discord: https://discord.gg/pJEXZNTCzs
- Join my network with 3100+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg
📸 Instagram: https://www.instagram.com/andersjensenorg
👨 Facebook: https://www.facebook.com/andersjensenorg
🐦 Twitter: https://twitter.com/andersjensenorg
💌 Email Newsletter: https://andersjensen.org/email-newsletter
MY MONITOR (Amazon affiliate):
🖥️ Samsung 49-inch CRG9 Curved Monitor = https://geni.us/MDpejc
- If you are buying this, I can recommend the Mi Monitor Light Bar = https://geni.us/3Wwad
https://www.seevid.ir/fa/w/046VQDEeARM Intro
Today we're building a real-time UiPath use case from scratch. We want to extract structured data, and our problem is that it's a web page with scrolling.
https://www.seevid.ir/fa/w/046VQDEeARM Handle Mouse Scrolling In Data Extraction
Before we can extract data, we need to ensure we're scrolled down the web page. Then, using the Mouse Scroll and Do While activities in UiPath, we compare the results and keep scrolling until we're at the bottom of the page. The best practice is always to ensure we validate the data before we extract the data.
https://www.seevid.ir/fa/w/046VQDEeARM The Table Extraction Wizard In UiPath
The table extraction wizard is easy to use. First, find the structured data you want to scrape. Then, you can even extract the URL. Finally, you can rename the headers to make the automation and output easier to interpret.
https://www.seevid.ir/fa/w/046VQDEeARM Save The Scraped Results To Excel
We use a variable for storing the folder path. This is handy if the path change or we're using the path several times in the UiPath workflow. To ensure we don't overwrite the Excel results, we create a dynamic file name using the .NET time format.
https://www.seevid.ir/fa/w/046VQDEeARM Filter Data In UiPath
The Filter Data Table activity in UiPath helps us define the data table rows we want to keep. Finally, we use LINQ to filter and sort data. LINQ is a powerful query language we use a lot in UiPath.
#uipath #rpa #roboticprocessautomation
2 سال پیش
در تاریخ 1401/04/09 منتشر شده
است.
12,341
بـار بازدید شده