| Channel | Publish Date | Thumbnail & View Count | Download Video |
|---|---|---|---|
 | Publish Date not found |  0 Views |
Download the course material: https://andersjensen.org/uipath/beginners-course-2023-for-rpa-developers/
BEST UIPATH BOOKS (Amazon Partner)
Visual Basic .NET: https://geni.us/v6ffI
UiPath Associate Certification Guide: https://geni.us/Ek3l
Democratizing Artificial Intelligence with UiPath: https://geni.us/HK8K
The clean coder: https://geni.us/lPdmRMR
SQL in 10 minutes: https://geni.us/QlbJH
Intelligent Automation: https://geni.us/iX4u1
The Robot Process Automation Handbook: https://geni.us/MCT3EDx
UiPath Administration and Support Guide: https://geni.us/kTm2A
UIPATH GROUPS:
Discord: https://discord.gg/iloveautomation
– Join my network of 5,300 Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other advance our careers. It is free!
LinkedIn: https://www.linkedin.com/groups/13875336
Facebook: https://www.facebook.com/groups/1817369781750298
0:00 Introduction
I'm Anders Jensen, a two-time UiPath Most Valuable Professional.
0:15 Install and set up UiPath
We download and install the UiPath Community version, the complete package, for free. Plus, we get all the Automation Cloud features. Install the browser extensions. Enable the Modern Design experience.
6:25 Your first UiPath automation
Choose 'New Project – Process' and use VB instead of C#, as all documentation and tutorials are in VB. Then to create a no-code automation, we can drag and drop the predefined code blocks called Activities into UiPath. Our first UiPath robot opens an application and clicks a button.
12:11 Build a complete UiPath project
Download the course material from the course page. In our project, we want to build a complete UiPath RPA robot that can read an Excel sheet, scrape web data and write the results back to Excel. I've faced some challenges, and to solve them we need to use all the UiPath practices around RPA development.
17:04 Open a web page and perform a search
Using the application/browser opens a web page. It also defines a browser scope. Type the Type Into activity in the search field.
23:33 Scraping web pages with the Next button
We use the Table Extraction Wizard to extract the web data we want. Here are our search results. Grab the title, price and URL. Since our search results span multiple pages, we define the Next button. We'll work with the selector for the Next button to make it stable. Finally, with the Write Workbook Range activity, we write the scraped results back to Excel.
35:12 Reading an Excel sheet
We use the Excel Process Scope, Use Excel File, and Read Scope activities to read an Excel worksheet with UiPath. Additionally, we set the Show Excel Window property in the Excel Process Scope to false. When we read data from Excel, it is stored as a DataTable.
39:37 Web Scrape multiple pages
Now we want to scrape multiple pages to Excel with UiPath. Here we read the search topics from Excel, do the search, scrape the results and write the result back to Excel. Use a For Each Row in Data Table to iterate through the DataTable with the Excel data.
46:32 Dynamic file naming with DateTime
We don't want to overwrite files, so we use a dynamic file name that uses the date and time from when the robot is running. When we work with dates and times in UiPath, we use .NET's custom date and time formats.
54:34 Regular Expressions – RegEx
Regular expressions, or RegEx, are a series of characters that define a search pattern. We use it to extract data from structured data. Use a RegEx tester like regex101 to design your regular expression patterns. To use it in UiPath, drag in an Assign and create the expression: System.Text.RegularExpressions.Regex.Match(/"YourString/
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
