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)

CSV/Excel to data table and vice versa (with a step-by-step example)

In this section, we will see how to extract data from an Excel file into a data table and vice versa. We will achieve this by:

  • Reading an Excel file and creating a data table using data from the Excel file
  • Creating a data table and then writing all its data to an Excel file

Reading an Excel file and creating a data table by using data from the Excel file

We have an existing Excel file and we are going to use it in our project:

  1. Drag and drop the Flowchart activity on the main Designer window. Also, drag and drop the Excel application scope inside the Flowchart.
  2. Double-click on the Excel application scope. You have to specify the path of your workbook/Excel...