In this blog, allow us to understand the concepts that we’ve studied till now with the assistance of detailed examples.
Excel Automation
The first example explains Excel automation. during this example, you’ll learn to −
• Open Excel file
• Read cells or ranges
• Showing the Output.
To do Excel automation using UiPath studio, we’d like to follow the steps given below −
Step 1 − First, open UiPath studio and begin a replacement blank project.
Step 2 − Now, put the Excel file from which you would like to read the info within the folder of your current project. We are reading the info from following Excel file

rpa 23

Step 3 − Drag & drop a sequence within the Designer Panel.
Step 4 − Drag & drop “Excel Application scope” activity below the sequence in Designer panel. Note that it are often searched from activity panel.
Step 5 − Now, we’d like to supply the trail of the Excel file. Click the Browse (…) button. it’ll open the situation of your current project where you saved the excel file. Select that excel file and path are going to be shown in “Excel Application scope”.
Step 6 − As we’d like to read the file, drag & drop Read range activity under “Excel Application scope” within the Designer panel. It are often searched from activity panel.
Step 7 − within the properties of Read range activity, provide the name of Output Data Table as variable (Right click within the Data Table text box then Click Create variable for instance, we gave it as DT1.
Step 8 − Now, we also want to ascertain its output, we’d like to tug & drop Output data table activity under the Read range activity.
Step 9 − within the properties of Output data table activity provide the name of Output Text as variable (as wiped out step 7) for instance, we provides it as DTout. alongside that it also requires input, which might be DT1 as provided in read range activity.
Step 10 − Now, after getting the output we would like UiPath to display it. For this we’ve to tug & drop Message box under Output data table. within the text box of Message box write DTout. the ultimate project will appear as if follows −

rpa 24

Step 11 − Run the project. it’ll read the Excel file and provides the output during a message box as follows −

rpa 25

That was an easy example of Excel automation during which we read the info from Excel file.
Please note that before implementing this instance confirm that the EXCEL activities are installed. It are often searched from the activity panel. If it shows empty, then you’ll install it via manage packages under activity panel.

PDF Data Extraction & Automation

In this example, we are getting to affect the extraction of data from mostly used file format i.e. PDF. PDF may contain simple text or text within the sort of images. With the assistance of following steps we will extract data from PDF file and save them into document or show as a message on screen −
Step 1 − First, open UiPath studio and begin a replacement blank project.
Step 2 − Now, put the PDF file from which you would like to read the info within the folder of your current project. We are using sample.pdf file for this instance.
Step 3 − Drag & drop a sequence within the Designer Panel.
Step 4 − Drag & drop “Read PDF Text” activity below the sequence in Designer panel. It are often searched from activity panel.
Step 5 − Now, we’d like to supply the trail of the PDF file. Click on the Browse (…) button. it’ll open the situation of your current project where you saved the PDF file. Select that excel file and path are going to be shown in “Read PDF Text”.
Step 6 − within the properties of “Read PDF Text” activity, provide the name of Output Data Table as variable (Right click within the Data Table text box then Click Create variable. for instance, we provide it as read text output. We also got to provide the range of pages. By default, it might be set as “ALL” but you’ll give the worth in range like “1-3” pages, it’ll read first three pages otherwise you also can specify a specific page like “3”, it’ll read only 3rd page.
Step 7 − Now, we also want to write down the output in document, we’d like to tug & drop Write document activity under Read PDF Text activity.
Step 8 − Now provide the name of the computer file in quotation mark. for instance, we write “Output.txt”. Also within the properties of Write document activity provide the name of Output Text as variable (as wiped out step 6). It must be an equivalent provided in Read PDF Text activity’s output i.e. readtextoutput.
Step 9 − Now, after getting the output we would like UiPath to display it. For this we’ve to tug & drop Message box under Write document. within the text box of Message box write readtextoutput.
The final project will look as follows −

rpa 26

Step11 − Run the project. it’ll extract the PDF file and make a document named output.txt and also give the output during a message box like follows −

rpa 27

The above example will only extract data from PDF file, but if that PDF file contains text as image, then you’ll use Read PDF with OCR activity rather than Read PDF text. Both are quite similar.
Another way of extracting data from PDF is Screen Scraping which we’ve already discussed within the previous chapter.
Please note that before implementing this instance , confirm that the PDF activities are installed. It are often searched from activity panel. If it shows empty, then you’ll install it via manage packages under activity panel.

Email Automation

In this example, we are getting to affect the reading of Unread Emails from our Gmail account through UiPath studio.
We can perform this with the assistance of the subsequent steps −
Step 1 − First, open UiPath studio and begin a replacement blank project.
Step 2 − Drag & drop a sequence within the Designer Panel.
Step 3 − Drag & drop “Get IMAP Mail Messages” activity below the sequence in Designer panel. It are often searched from activity panel.
Step 4 − within the properties of “Get IMAP Mail Messages” activity, provide the name of the server as “imap.gmail.com” and Port as 993 under Host. Also provide Email address and password under Logon property.
Another thing we’d like to supply is that the name of Messages, under Output property, as variable (Right click within the Data Table text box then Click Create variable. for instance, we provide it as “Messages”.
You can also select what percentage unread messages UiPath studio should read by giving the amount in Top property under Options. we elect 5 here so it’ll read top 5 unread messages.
Step 5 − Now, what you would like to try to for every email? For specifying this we’d like to tug & drop for every activity. It are often search from activities. Provide here variable “Messages” which we utilized in step4. We even have to vary Type Argument to System.Net.Mail.MailMessages from property panel. It are often selected from Browse for Type options.
Step 6 − Now, after getting the output we would like UiPath to display it. For this we’ve to tug & drop Message box under for every activity. within the text box of Message box write mail.Subject which suggests it’ll show only the topic of top 5 unread messages. There are other options also. the ultimate project will appear as if follows −

rpa 28

When you will run the above project, UiPath will show the messages having subject with top 5 unread emails from the e-mail id you provided.
Please note that before implementing this instance confirm that the MAIL activities are installed. It are often searched from activity panel. If it shows empty, then you’ll install it via manage packages under activity panel.
So, this brings us to the end of blog. This Tecklearn ‘UiPath – Detailed Examples’ blog helps you with commonly asked questions if you are looking out for a job in Robotic Process Automation. If you wish to learn RPA and build a career in Robotic process Automation domain, then check out our interactive, Robotic Process Automation using UiPath Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/robotic-process-automation-using-uipath/

Robotic Process Automation using UiPath Training

About the Course

Tecklearn’s Robotic Process Automation training using UiPath will prepare you for UiPath’s RPA Developer Advanced Certification Exam so that you can drive RPA initiatives in your organization. RPA training and certification is a comprehensive course for mastering Robotic Process Automation, different tools in RPA, the life cycle of RPA, deploying the UiPath tool, UiPath Studio, invoking a UiPath workflow, Citrix automation, automating the virtual environment and more through hands-on projects and case studies.

Why Should you take Robotic Process Automation using UiPath Training?

• The average salary of RPA Technical Automation Architect is $116,872 per annum – Indeed.com.
• Robotic Process Automation market will reach $2.9 billion by 2021 – Forrester Research
• Robotic Process Automation is being heralded as one of the booming industries in today’s digitally-driven economy. Every industry including banking, finance and information technology can immensely benefit from the RPA industry

What you will Learn in this Course?

Introduction to Robotic Process Automation

• Why RPA?
• Industry Implementation of RPA
• RPA Growth Trends
• Different RPA Tools
• Types of Bots
• Why UiPath?
• UiPath Installation
• Getting Started with UiPath
• Project and Project Types
• UiPath Dashboard
• UiPath Overview

Important components of UiPath

• Introduction to UiPath Studio, UiPath Robot and UiPath Orchestrator
• Working with variables
• Managing control flow
• Excel Automation
• Gmail automation with UiPath

More about RPA

• Ui Path Studio Components
• Passing rogramming, Debugging and Exception Handling

Programming, Debugging and Exception Handling

• Programming Activities in UiPath
• Debugging errors in a UiPath Project
• Different ways of Error Handling in UiPath
• Browse through the log files related to UiPath Project

Connect Orchestrator with UiPath

• UiPath Orchestrator Overview
• Orchestrator activities

RPA Tools like REFramework

• Introduction to REFramework
• Purpose of REFramework
• Using State Machine Layout
• State Machine States
• Workflows Involved
• Exception Handling and Logging

Programming Activities Using Data Table

• Programming activities using Data Table
• Learn Data Table Structure, Comprehend Searching Method and Data Table Activities
• Create an environment and associate the workflow
• Creation of Collection
• Email Automation
• Understanding Sequence and Flowchart
• Automate Sending and Reading of Email Message

Data Scrapping

• Importance of Data scraping with UiPath
• Data scraping aspects: Taking screenshot, Activating, getting text, highlighting and selecting item, loading image and more

Desktop Automation

RPA Project

• Excel Operations Automation using Ui Path

UiPath Orchestrator

• Orchestrator Overview
• Orchestrator Account Creation
• Connecting a Robot
• Create an Environment and Associate the Robot
• Publish a Package
• Create a Process from the Package
• Running a Robot and Examine Logs
• Scheduling and Running of Unattended Robot

Got a question for us? Please mention it in the comments section and we will get back to you.

448