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

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

🤖UiPath Video Tutorial

#uipath #excel #datatable

[tomcat]

Man, this is better than UIPath Academy beginner wise

[anatolek]

thanks! Now I figured out the Add Column! Keep up the great videos! They are really helpful!

[АнастасияКузьмина-ро]

Thanks, Anders, a lot for your wonderful instructions. You make best videos!

[moneyboy]

Hi Anders, thank you for making so helpful videos!

[shintaainal]

HI! I currently keep watching your video because it is super easy to understand and make me understand the very basic of every function.

Now i am still learning on this video tho, hopefully i can master it soon because it hink i am a slow learner huhuh.
Good work for you, you did a great job here ! Give me even many people chance to understand better ! Very Useful!

I am going to make you as my main source for learning uipath, thank you! Really appreciate your efforts here!

[lionelblak]

Hi Anders, thank-you for such clear videos. How can I change the Number Format of an entire column in an Excel sheet to Text? As a user, I would normally highlight the whole column, right-click and select the Format Cells command. I would then select Text from the Category panel in the Number Format tab of the Format Cells dialog. Many thanks in advance!

[dmuirheid]

Wonderful instruction! Thank you for your video.

[rale]

These elaborations are so transparent and clear in understanding that i want to see more and more :) you tell it clearly and
understandable! Super!

[MovieTheatrebyDR.]

Hi Andres, I am new to UiPath. And I had few queries regarding the read excel and write excel by row or column. Prior to that I worked for Pega RPA. Thank you for this video.

[nayannimisha]

Hey Anders !. Your videos are very helpful for beginners. I want to know from where to learn basic dot net commands which will be helpful to learn in Automation.
Thnx
Nimi

[Donaldtrump]

hi Anders,

May I know how to print out every column instead of using "row.item(2).ToString" from excel? If I got 20 column wanna output, it's quite stupid using "row.item(0).ToString + row.item(1).ToString + row.item(2).ToString etc..."

[yannademcissoko]

thx ; but iwant to know how to ad a new column to the excel sheet when we add a new name

[manuelcaballero]

Thank you Anders, just a question. Is it posible to add a row in the same sheet (not adding a "Updated Data")? It will add the row whenever Uipath finds an empty row, I am not sure about this..
Thank you for your videos!!
Manuel.

[mohamedshehata]

thank you.Q1: how can i make filter ondate in row but the filter must take the the date of the seme day i run the Robot.

[AlexPlayz]

Is it possible to make a video on UiPath determining expiration dates from one column in excel, finding the corresponding contractor email address found in another column then set up UIPath to email these contractors within a predetermined time (ex. 45 days before expiration date)?

[mehmetmustali]

Hi Anders, thanks for the detailed explanations for every videos. I have a question about for each row function. I am trying to get some data tables from a website with using “each row” function and paste them into a sheet in an excel file. Related data tables' row quantity can change, some of them less than 10 rows the others can be more than 30 but columns are always same. Robot is working, but it’s pasting all datas one of the top of the other. So after process has finished, I can just get latest searched datas in related excel sheet. How can I manage that these results will come one under the other without overlapping?

[wonsikchoi]

Thanks a lot for your wonderful instructions. I'm a beginner of uipath rpa and I've been learning many things thru your videos. Just one question. What is the most effective way to change header (colume names) by uipath? There are times when you get some data sheets from the internet using Extracting DT activity and you don't like the header, so you want to change it after or as soon as you generate an excel sheet using write range activity. How would you do it?

[MsJsmith]

How do you suppress the message that says the data has been modified. This is when using the For each row in Data Table source? Thanks

[itsmechethan]

I have a Question

How to automate the Azure data lake please make a tutorial on this it will help to us
need to create a folder and upload the file

[athenaellis]

Is there a way, using uipath, to determine the location of the current cell? For example: if using filtered data, some rows are hidden and the row number will be unknown.