Course

Working with Data in Studio

This RPA Developer FastStart course is meant to take you through the most common ways of working with data in UiPath.
  • 2909 enrolled students
  • April 01, 2022
Not Started

Watch a preview

Working with Data in Studio

  • 04:00:00
  • Downloadable resources available
  • Diploma of Completion included
Start Learning Now

Course details

Difficulty Level

Intermediate

Language

English

Completion time

04:00:00

Product covered

Product alignment 

This course was built using the 2020.10 product version of UiPath Platform and is applicable to newer versions as well.

Audience 

RPA Developers with relevant experience with other RPA tools, as well as other Experienced Developers

Learning objectives

At the end of this course, you should be able to:

  • Use the Invoke Workflow File activity to chain workflow execution and pass data through arguments.
  • Use the most common .NET methods to manipulate String variables.
  • Use specific methods to initialize and manipulate List variables.
  • Use specific methods to initialize and manipulate Dictionary variables.
  • Use the RegEx builder in UiPath Studio to perform complex string manipulation.
  • Use specific methods to perform data manipulation operations using DateTime variables.
  • Use the most common methods for DataTable manipulation.
  • Differentiate between the categories of activities used when working with Excel files: Workbook activities and Excel App Integration activities.
  • Use specific activities to work with Excel files (read data, write data, save files, and so on).
  • Use the Select method to filter DataTables.

Course agenda

1. Workflows and Arguments

  • Invoke Workflow and Arguments

2. Data Manipulation

  • Strings
  • Lists
  • Dictionaries
  • The RegEx Builder
  • DateTime
  • Data Manipulation Practice

3. Tabular Data

  • What Are DataTables?
  • Working with DataTables

4. Spreadsheets

  • Workbooks and Common Activities
  • Excel Application Scope and Specific Activities
  • The Select Method
  • Practice with Spreadsheets