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

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)?

Hi Anders, thank you for making so helpful videos!

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

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.

HI Anders , I am beginner in RPA.Your video is very simple and useful. I am getting following error Error
ERROR Validation Error Compiler error(s) encountered processing expression "DoubleParse(row.item("Total").ToString)>1000".

'DoubleParse' is not declared. It may be inaccessible due to its protection level. Main.xaml

Pls. Reply

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

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

could we delete the column we do not want?

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

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!

I can't find any excel option under activities, I searched online for the reasons why but I can't find anything. What should I do?

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

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.

Man, this is better than UIPath Academy beginner wise

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

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.

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!

Do you have a video to demp comparing two columns from excel 1 to two columns in excel 2 and updating excel 1 with data from excel 2 if match is found?

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?

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..."

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?

Wonderful instruction! Thank you for your video.

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.

why to use row.Item("column_name")
If row("column_name") works

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

Hello, can you show me how to use auto increments in add data column.