UiPath | How to automate Excel and work with Data Tables | Tutorial

Опубликовано: 28 Сентябрь 2024
на канале: Anders Jensen

59,880

649

A guide that teaches you how to work with Excel data in UiPath. The guide will show you how to import the data from an Excel Sheet, then work with it in UiPath using Data Tables and finally print it out again to Excel.

00:36 Get Data Sample
02:11 Excel Application Scope
03:49 Read Range (Excel)
04:38 Create Data Table
05:28 For Each Row
06:21 Using a Write Line to print selected data
09:44 Using an If to apply a condition on our data
10:28 Converting a String to a Double
12:33 Add Data Row
13:21 Creating an Array of variables
15:01 How to use a Write Range to print our selected data
17:10 Add Headers
17:38 Add Data Column
18:35 Input Dialog
19:21 Creating a dynamic array
21:15 How to write cells in a new column

🔔Subscribe if you enjoyed
http://www.youtube.com/user/klogeande...

🤖UiPath Video Tutorial
• UiPath: How to get a Dark Theme

#uipath #excel #datatable