Book Image

Learning Robotic Process Automation

By : Alok Mani Tripathi
Book Image

Learning Robotic Process Automation

By: Alok Mani Tripathi

Overview of this book

Robotic Process Automation (RPA) enables automating business processes using software robots. Software robots interpret, trigger responses, and communicate with other systems just like humans do. Robotic processes and intelligent automation tools can help businesses improve the effectiveness of services faster and at a lower cost than current methods. This book is the perfect start to your automation journey, with a special focus on one of the most popular RPA tools: UiPath. Learning Robotic Process Automation takes you on a journey from understanding the basics of RPA to advanced implementation techniques. You will become familiar with the UiPath interface and learn about its workflow. Once you are familiar with the environment, we will get hands-on with automating applications such as Excel, SAP, Windows and web applications, screen and web scraping, working with user events, and we'll cover exceptions and debugging. By the end of the book, you'll not only be able to build your first software robot, but you'll also wire it up to perform various automation tasks with the help of best practices for robot deployment.
Table of Contents (12 chapters)

File operation with step-by-step example

In this module, we are going to operate on Excel file. The following are the methods that are frequently used with an Excel file:

  • Read cell
  • Write cell
  • Read range
  • Write range
  • Append range

Once you get familiar with these methods, it will become very easy for you to use other methods too.

Read cell

This is used to read the value of a cell from an Excel file. We have a sample Excel file that we will use in this example:

Suppose we have to read the value of the B3 cell:

  1. Drag and drop a Flowchart activity on the main Designer panel. Also, drag and drop an Excel application scope inside the Flowchart. Connect it to the Start node. Double click on Excel application scope.
It is a good...