Excel Automation with the Modern Experience in Studio

About the Excel Automation with the Modern Experience in Studio course

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 was initially built using the 2022.10 version of UiPath Studio, with updates reflecting the new features from the 2023.10 version. It is applicable to both 2022.10 and newer versions.  

Audience: 

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.

Agenda:

1. Introduction to Excel Automation 
2. Design Experiences and Excel Add-in 
3. Build Automation Using Workbook and Data Tables Activities: 
4. Practice 1 - Workbook and Data Tables 
5. Build Automation using Excel Modern Activities 
6. Practice 2 - Excel Activities  

Learning Objectives:

• Provide an overview of Excel automation and its benefits. 
• Differentiate the ways of working with Excel files and DataTables in UiPath Studio. 
• Distinguish between the categories of activities used when working with Excel files: Workbook activities and Excel App Integration activities and use them appropriately. 
• Differentiate between the design experiences available in UiPath Studio for Excel automation and identify their features. 
• Explain what DataTables are and how they play a crucial role in automating Excel. 
• Use the Workbook Activities available in UiPath Studio. 
• Use the Basic activities of DataTable in UiPath Studio. 
• Use Excel App integration activities in UiPath Studio. 
• Use CSV activities in UiPath Studio.