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)

Opening, closing, and saving Excel workbooks

Whenever we use an external data source, no matter what type this may be, a connection needs to be established. Once we have consumed the data, the connection needs to be closed. Not only does this apply to Automation Anywhere but to most development platforms. How we make this connection is where it differs. Automation Anywhere refers to this connection as a session. We will create various types of sessions as we progress through this book. We have already created sessions when connecting with CSV files.

The first thing we need to learn about Excel is how to open, close, and save workbooks. So, we'll start off with a simple walk-through. You will open an Excel workbook, save it, and close it. For this walk-through, we will use the sample workbook Chapter11_Catalog.xlsx from the GitHub repository.

Let's start this walk-through by executing the following steps:

  1. Log into Control Room.
  2. Create a new bot and call it...