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)

Chapter 11: Automating Excel

You must be feeling like an XML automation guru now. In the previous chapter, we covered all the actions available in the XML package, giving hands-on experience with reading and updating XML files as well as running XPath functions against your XML datasets.

In this chapter, we will be looking into using automation with Microsoft Excel. We will go through several walk-throughs, looking at how we can build bots to automate Excel workbooks and worksheets. Automation Anywhere 2019 has two packages offering loads of Excel actions. These packages are Excel basic and Excel advanced. Starting with the basics will enable you to feel confident with opening, closing, and saving workbooks. You will also learn how to read datasets from Excel as well as write to worksheets. This will include creating loops to iterate through rows of data. As we move onto the advanced package, we will look at manipulating worksheets by doing things such as inserting columns, adding...