UiPath - How to add data to a new Excel column - Full Tutorial

This video tutorial shows you, how to add data to a new Excel column and/or DataTable column. Main activities are read range, assign, write range and some .net commands.
Join my community, 7-day free trial: iloveautomation.ai/community

You could also watch:
🔵 UiPath RPA Beginners Tutorial - youtu.be/3ZKzTHdpsTs
🔵 UiPath Advanced Use Cases - youtube.com/playlist?list=PLXXz88_TPiHo7TmTn15s…

0:08 Explaining the Uipath use case
We want to add data to a new Excel column (the first new empty column) instead of a row.

1:24 Read data from Excel
We are working with the Workbook activities instead of Excel in order to make the UiPath workflow more efficient (more simple). A Data Table in UiPath is just a mirror of the Excel Sheet, but do remember it will dissapear, when the workflow is done (= remember to save it somewhere, if you are going to use it).

2:19 Add a Header to the Excel Table
Using an Assign activity to get todays date (DataTime.Now.ToString).

3:42 Add Data Column
Specifying the Data Table we are working with as well as the desired Column Name.

4:10 Write Range
Writing our Data Table back to Excel.

5:47 Adding data to Excel with an assign
We can specify where, in the Excel table, we want to add our data.

#uipath #rpa #automation