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 with data in Excel

In the previous section, we looked at the basics of Excel automation, such as opening, reading, writing, saving, and closing Excel workbooks. In this section, we will explore the Automation Anywhere Excel advanced package. The walk-through will involve building a bot that performs a specific role. The bot will replace a manual task that involves updating an Excel spreadsheet. The file used is available as part of the GitHub repository Chapter11_SampleData.xlsm:

Figure 11.23 – Snapshot of the Chapter11_SampleData.xlsm file

Figure 11.23 – Snapshot of the Chapter11_SampleData.xlsm file

This file contains a data table of sales achieved by a fictitious organization. In order to automate the file, we perform the following steps:

  1. Open the Excel file Chapter11_SampleData.xlsm.
  2. Insert a new column after column 4 and call it Amount on the worksheet Extract.
  3. Add a formula in the new column to calculate the sales amount (Units Sold * Sale Price).
  4. Sort the data table by the...