Robotic process automation using UiPath StudioX : a citizen developer's guide to hyperautomation / Adeel Javed [et al.]

Format:

Book

Author/Creator:

Javed, Adeel, author.

Contributor:

Sundrani, Anum.

Malik, Nadia active 2021.

Prescott, Sidney Madison.

Language:

English

Subjects (All):

Robotics.

Robots--Programming.

Robots.

Physical Description:

1 online resource (xix, 628 pages) : illustrations

Place of Publication:

Berkeley, CA : APress, [2021]

Summary:

Learn about Robotic Processing Automation (RPA) and how to build bots using UiPath. This book uses hands-on examples to explain the basics of UiPath and then walks you through real-world prototypes for testing your knowledge. Organizations around the world are implementing RPA in some capacity, and there is a shortage of RPA developers in the market. Analysts predict that the RPA market size will be worth $4 Billion by 2025. With UiPath as one of the three major players in the RPA market, professionals and students can use this book to get ahead of the curve. This book helps you kick-start your automation journey with a special focus on one of the most popular RPA tools: UiPath. Robotic Process Automation using UiPath explains in detail the various features and functionalities of the RPA platform including development, debugging, and error handling. What You'll Learn * Create robots from scratch, using one of the market leaders in RPA * Develop automation apps and deploy them to all the computers in your department * Build, test and perform enterprise automation tasks with UiPath * Understand the key building blocks and components of UiPath * Apply UiPath programming techniques to deploy robot configurations * Review email Automation * Automate Excel and PDF interactions Who This Book Is For RPA developers and business users alike, bringing the power and skill set of automation to anyone interested in citizen-led development, specifically UiPath StudioX. The simple exercises and no-code platform require no prior programming or RPA knowledge to follow along with this beginner's guide.

Contents:

Intro

Table of Contents

About the Authors

About the Technical Reviewer

Acknowledgments

Part I: Overview

Chapter 1: Robotic Process Automation: Overview

Return on Investment (ROI)

Automation Types

UiPath StudioX

Chapter 2: UiPath StudioX

Learning Objectives

System Requirements

Hardware Requirements

Software Requirements

Installation and Setup

Register

Download

Install

Interface Overview

Home

Start

Templates

Tools

Settings

Help

Design View

The Ribbon

Save

Export as Template

Cut, Copy, and Paste

Project

Notebook

Manage Packages

App/Web Recorder

Table Extraction

Analyze

Export to Excel

Publish

Run

Project Workspace

Activities Panel

Designer Panel

Context Menu

Properties Panel

Data Manager Panel

Output Panel

Part II: Building Blocks

Chapter 3: Common Concepts

Default Notebook

Custom Notebook

Activity Inputs

Activity Outputs

Common Properties

Common Activities

Write Line

Configuration

Message Box

Input Dialog

Modify Text

Text to Left/Right

Delay

If

Switch

Repeat Number Of Times

Skip Current

Exit Loop

Get Username/Password

Get Orchestrator Asset

Save For Later

Wait for Download

Group

Chapter 4: UI Automation

Sample Overview

Activities Reference

Use Application/Browser

Go To URL

Navigate Browser

Highlight

Take Screenshot

Configuration.

Check App State

Click

Type Into

Select Item

Check/Uncheck

Get Text

Get Attribute

Extract Table Data

Hover

Keyboard Shortcuts

Get Active Window

Maximize Window

Minimize Window

Hide Window

Restore Window

Move Window

Chapter 5: Mail Automation

Desktop Outlook Setup

File System Structure

Use Desktop Outlook App

Use Outlook 365

Use Gmail

For Each Email

Mark Email As Read/Unread

Forward Email

Save Email Attachments

Save Email

Send Email

Send Calendar Invite

Move Email

Reply to Email

Archive Email

Delete Email

Chapter 6: Word Automation

Word Setup

Bookmarks

Alt Text

Use Word File

Save Document As

Read Text

Set Bookmark Content

Replace Text in Document

Append Text

Insert Data Table in Document

Replace Picture

Add Picture

Save Document as PDF

Chapter 7: Excel Automation

Use Excel File

Insert Sheet

Rename Sheet

Duplicate Sheet

Delete Sheet

For Each Excel Sheet

Insert Column

Text To Columns

Delete Column

Insert Rows

Delete Rows

Find First/Last Data Row

For Each Excel Row

Write Cell

Create Pivot Table

Format as Table

Change Pivot Data Source

Refresh Pivot Table

Append Range

Copy Range

Clear Sheet/Range/Table

Sort Range

Auto Fill

Fill Range

Write Range

Read Cell Formula

Read Cell Value

Format Cells

Export to CSV

Save Excel File

Save Excel File As

Save Excel File As PDF

VLookup

Filter

Run Spreadsheet Macro

Chapter 8: CSV Automation

Write CSV

Append To CSV

Read CSV

Chapter 9: File Automation

Get Folder Info

Folder Exists

Create Folder

Delete Folder

Copy Folder

Move Folder

For Each File In Folder

Compress/Zip Files

Extract/Unzip Files

Get File Info

File Exists

Create File

Delete File

Copy File

Move File

Write Text File

Append Line

Read Text File

Chapter 10: Presentation Automation

Use PowerPoint Presentation

Copy Paste Slide

Delete Slide

Add New Slide

Replace Text in Presentation

Add Text to Slide

Add Data Table to Slide

Add Image/Video to Slide

Add File to Slide

Run Presentation Macro

Save PowerPoint File As

Save Presentation as PDF

Part III: Prototypes

Chapter 11: Product Data Entry Automation

Manual Task Overview

Solution Design

Initialize

Process Emails

Enter Data

Send Confirmation

Implementation

Step 1: Setup

App

Daily Processing

Samples

Step 2: Create Project

Step 3: Setup Project Notebook

Step 4: Check Folder Structure Exists

Step 5: Create New Folders

Step 6: Process Emails

Step 7: Save Email Details for Confirmation

Step 8: Launch Inventory Management App

Step 9: Fetch All Downloaded Files

Step 10: Insert Processing Status Column

Step 11: Enter Data &amp

Update Status For Each Row

Step 12: Move File to Processed Folder

Step 13: Send Confirmation Emails

Test

Chapter 12: Invoice Generation Automation

Manual Process Overview

Step 3: Set Up Project Notebook.

Step 4: Initialize

Step 5: Generate Invoices

Step 6: Extract &amp

Process All Orders

Step 7: Filter Orders w/ Pending Invoices

Step 8: Extract Orders Table Data

Step 9: Process All Orders

Step 10: Generate Invoice Number

Step 11: Create Order Details Excel Copy

Step 12: Create Invoice Template Copy

Step 13: Extract Order Details &amp

Generate Invoice

Step 14: Extract Order Details Table Data

Step 15: Generate Invoice for Current Order

Step 16: Mark Purchase Order as Processed

Step 17: Delete Temporary Order Details Excel

Index.

Notes:

Description based on print version record.

Includes index.

ISBN:

9781523150786

1523150785

9781484267943

148426794X

OCLC:

1245674331