Book Image

Robotic Process Automation Projects

By : Nandan Mullakara, Arun Kumar Asokan
Book Image

Robotic Process Automation Projects

By: Nandan Mullakara, Arun Kumar Asokan

Overview of this book

Robotic Process automation helps businesses to automate monotonous tasks that can be performed by machines. This project-based guide will help you progress through easy to more advanced RPA projects. You’ll learn the principles of RPA and how to architect solutions to meet the demands of business automation, along with exploring the most popular RPA tools - UiPath and Automation Anywhere. In the first part, you’ll learn how to use UiPath by building a simple helpdesk ticket system. You’ll then automate CRM systems by integrating Excel data with UiPath. After this, the book will guide you through building an AI-based social media moderator using Google Cloud Vision API. In the second part, you’ll learn about Automation Anywhere's latest Cloud RPA platform (A2019) by creating projects such as an automated ERP administration system, an AI bot for order and invoice processing, and an automated emergency notification system for employees. Later, you’ll get hands-on with advanced RPA tasks such as invoking APIs, before covering complex concepts such as Artificial Intelligence (AI) and machine learning in automation to take your understanding of RPA to the next level. By the end of the book, you’ll have a solid foundation in RPA with experience in building real-world projects.
Table of Contents (14 chapters)

Reading and writing the image path list to the ImageDetails Excel file

Perform the following steps:

  1. Since we only need the image files, we need to check whether the files have a certain extension – we will only pass JPG or PNG images in this project. To inspect the file properties, create a new variable called strFileInfo of the FileInfo type and set the scope to the Try-Catch block.
  2. Let's also add a counter variable called intCounter of the Int32 type and set the scope to Try-Catch as well. We will be using this variable to loop through the Excel cells. Go ahead and set the default value for this variable to "2" since we want to start from the second row in Excel.
  3. Now that we have the variables, let's use the Assign activity to pass the file information (New FileInfo(item.ToString)) value to the strFileInfo variable we just created. Now, we are ready to inspect the variable for file information. Here is what your For...