Working with Data in Studio

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