Watch a preview
This course covers automating one of the most widely used business tools—Excel. We'll go through the different ways to work with Excel and associated files (.xlsx, .xls, .csv) using the specific methods and tools that UiPath Studio offers. We'll also introduce a type of variable meant for working with Excel files, and databases, the DataTable (System.Data.DataTable).
Product alignment: this course is aligned with the 2022.10 version of UiPath Studio, and we recommend installing this version to make use of all the features presented. However, if you are using a different version of UiPath Studio, you can still work with the required version activities by updating the related project dependencies, particularly the UiPath.Excel.Activities 2.16.1 package version.
The Excel Automation with the Modern Experience in Studio course is beginner level. Before you enroll, you should have completed the following courses:
Designed and developed for automation explorers aspiring to become Automation Developers, including Document Understanding Specialists, Attended Automation Specialists, Automation Solution Architects, Automated Test Engineers, and Automated Test Managers. It's also ideal for those seeking to gain a complete understanding of Excel automation capabilities and its basics from UiPath.
The agenda covers:
a. Overview of Excel Automation
b. Benefits of Excel Automation
2. Design Experiences and Excel Add-in
a. Excel Add-in and its features
b. Design experiences available in UiPath Studio for Excel automation
c. Best practices for designing Excel automation workflows.
3. Build Automation Using Workbook and Data Tables Activities:
a. Workbook activities in UiPath Studio
b. Working with Excel files using Workbook activities
c. Introduction to DataTables and their importance in automating Excel
d. Basic activities of DataTable in UiPath Studio
4. Practice 1 - Workbook and Data Tables
a. Hands-on practice exercises using Workbook activities and DataTables in UiPath Studio
5. Build Automation using Excel Modern Activities
a. Excel App Integration activities in UiPath Studio
b. Working with Excel files using Excel App Integration activities
c. Introduction to CSV activities in UiPath Studio
6. Practice 2 - Excel Activities
a. Hands-on practice exercises using Excel App Integration activities and CSV activities in UiPath Studio
At the end of the course, you should be able to: