Book Image

Robotic Process Automation with Automation Anywhere

By : Husan Mahey
Book Image

Robotic Process Automation with Automation Anywhere

By: Husan Mahey

Overview of this book

With an increase in the number of organizations deploying RPA solutions, Robotic Process Automation (RPA) is quickly becoming the most desired skill set for both developers starting their career and seasoned professionals. This book will show you how to use Automation Anywhere A2019, one of the leading platforms used widely for RPA. Starting with an introduction to RPA and Automation Anywhere, the book will guide you through the registration, installation, and configuration of the Bot agent and Control Room. With the help of easy-to-follow instructions, you’ll build your first bot and discover how you can automate tasks with Excel, Word, emails, XML, and PDF files. You’ll learn from practical examples based on real-world business scenarios, and gain insights into building more robust and resilient bots, executing external scripts such as VBScripts and Python, and adding error handling routines. By the end of this RPA book, you’ll have developed the skills required to install and configure an RPA platform confidently and have a solid understanding of how to build complex and robust, yet performant, bots.
Table of Contents (20 chapters)

Working example walk-through

You will now start building the modular task bot as described in our scenario. We have got the main and sub-bot designs to guide us. We will build four bots in total – one main task bot and three sub-task bots. For this scenario, we will use the sample Chapter15_SQLite.db database and will limit the records for each table to 20. Firstly, let's give our bots some names; we will name them as follows:

  • Chapter16_Sub_CreateNewExcel
  • Chapter16_Sub_GetSqLiteTableNames
  • Chapter16_Sub_CopySqLiteTableToExcel
  • Chapter16_Main_SqLiteToExcel

It always makes sense to start with the sub-tasks first. This will enable us to build the main task quickly as we bolt the smaller sub-tasks together. We will start the walk-through with the first sub-task bot, Chapter16_Sub_CreateNewExcel.

Building a bot – Chapter16_Sub_CreateNewExcel

This bot takes an Excel file path input and checks whether it exists. If it does, then this file...