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.

You could also watch:

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.

Connect with me:

#uipath #rpa #automation

[Thaagaard]

Thank you much. Just as I wanted. :) You are the best. And my name is Danish. So you did great. ;)

[МихаилКоржов-оф]

Hi, Anders. Thank you for your videos. Recently I faced with the problem. Then I try to insert text which looks like number (for example "01400") Excel changes format and converts it to "1400". How I can eliminate it? Columns in DataTable are in string format.

[samueltemi]

Hello Anderson Jensen, I have a scenario whereby I have to add a new column called "CountryName" to my excel file. I also have to write the country Name for each product on the file, how do I write the country code to this new column? UiPath says the Column does not exist on the data table when I run my code, even though the column is added to the table once the code runs.

[Deepakgupta-eyfc]

Hii sir
How can I take data from an Excel file or CSV one by one and use it to search and scrape data through UiPath . please help by making one lecture on it

[jerrychen]

Hello Anders, really appreciate for your very derailed explanation on every single step.
I went thru your video couple times and eventually that works out, really thanks for my first copy robot :).
I have a scenario may need some advises from your side to see if it's possible to have a tutorial and below is some explanations.
1. check the first cell of the row, to see if it contains something
2. if the logic is true, then start to count how many rows was empty down there till the next row is not empty
3. copy the content of the cell and fill it up(without the formula)
4. proceed to next row and check how many empty rows down there till next row is not empty again. (actually this is a repeat tasks), then copy
Thanks again and I have have already subscribe your channel and launch to watch your beginner videos, you are really amazing. :)

[yuhuichong]

thank you so much for this helpful tutorial

[damandeepsingh]

Hey! I like your videos one of the best method you choose.
I have a query I have 3 excel sheet.
1st excel looks like Name, Dob, Age
2nd excel like. Address, city, pincode
And 3rd one I have that all column name like
Name, Dob, Age, Address, city, pincode.
So my question is how to read the data from both sheet and write it to 3rd sheet on specific columns.

[simpleful]

Hei Anders! Thank you so much for great videos :)
How do you get data from merged cells in Excel? I need to extract data/value from merged cells (4-5 cell are merged together) and use this value in another sequence.
Hilsen en nybegynner fra Norge :)

[nazeemakhanam]

Hello Anders, I have a scenario and it would be really helpful if you can provide me some light here. I have a data table which holds data from the orchestrator Queue and the information from the data table has to be written into specific cell in the excel sheet. (The data table has multiple columns and I should be able to read the specific data from dt and write into specific cells.)

[XiroNyakuya]

Thank you, I had to complete the excel empty fields with info that I had to obtain according to the rest of the info of each row.

[ShahidKhan-ufhd]

Hey Anders,
How do I add column of data from another excel sheet, column with multiple rows is what I meant please help me I'm trying to solve this couldn't do it yet
It would be a great help
Thank you in advance

[kaylatanli]

This was something I was looking for. But I have a question for what I am working on. I have a column of values in one sheet that I would like to put into a column of the main sheet (same as what you are doing). So for example in this video, let strVar1, strVar2, and strVar3 be a column in another sheet, so I have to read that sheet and input it into excel column. How would I go about it? Do I do a for each row, then a for each item for the array of values (str1, str2, str3)?

[suzannafaith]

Hi, how do I append data to a specific column after I have read it from another excel workbook? E.g., I want to append the data from Column C instead of Column A, how do I do that?

[itsmechethan]

I need help I want to read the row and I want to send the email to the row what we stored after that I want to update in another excel file means data every day same procedure but every day new column will update in the new file but it's not affected to the old data how to do this please help me.

[varundey]

Ur voice is not clear man.. Plz be loud and clear wen u r teaching someone..