Book Image

Robotic Process Automation for Developers [Video]

By : Ramesh Nougain
2 (1)
Book Image

Robotic Process Automation for Developers [Video]

2 (1)
By: Ramesh Nougain

Overview of this book

The future of work is here: digital workforces. RPA solves a major software integration problem by automating at the presentation layer. Robotic Process Automation is the automation of repetitive and rule-based human tasks working with software applications at the User Interface layer. This course aims to make you ready for new-age RPA Developer jobs in the Digital Workforce era. You will begin by learning RPA concepts and how they can benefit people at their work. Then, you will master UI automation and extract content using scraping methods. You will get to know the various recorders available in UiPath to record human actions. Finally, you will build a workflow automation and get the hang of automating Excel, PDF, e-mail and Citrix applications. By the end of the course, you'll be equipped with the knowledge and skills to apply the power of automation to your projects. The code files are placed on GitHub at this link https://github.com/PacktPublishing/Robotic-Process-Automation-RPA-for-Developers
Table of Contents (6 chapters)
Chapter 6
Automating Excel, PDF, and Email Documents
Content Locked
Section 1
Excel Automation
Excel files are often used for data collection, organization, analysis and for sharing. This work in many business environments is manual, tedious and error prone. RPA UiPath provides automating such tasks involving Excel file data. - Use Application Integration Excel Activities to manipulate the excel data. Commonly used excel actions are available in the form of activities. For this MS Excel must be installed - Use File Direct Access Workbook Excel Activities to manipulate the excel data. Only basic actions are available in the form of activities. MS Excel installation is not required - Understand that UiPath provides activities for executing Excel Macros, VBA, Table operations, creating pivot table, etc