UiPath - How to loop through rows and columns in Excel and pass values to web search/input

In this video tutorial, I show you how to easily loop through rows and columns in an Excel sheet and pass the values to e.g. a web page or an app inpiut.

You could also watch:

0:04 Present our UiPath Excel use case
We want to loop through data in Excel and paste them into websearch/input fields.

0:46 Read Range
We use a Read Range activity to read the data from Excel into a Data Table. You can see a Data Table as an Excel sheet that exists only in the memory, while the workflow runs.

1:44 Loop through all rows
With a For Each Row we can loop through all our rows in the Excel sheet.

2:20 Set Text and Click

Connect with me:

#uipath #rpa #automation

[hayashikinjo]

+1 for specifying the column name, thanks!

[V.MITHUNCHANNEL]

Hi Anders
Thanks for your excellent videos

[MyAdventureHat]

Thanks for the info Anders! If you wanted to highlight the excel row after the data has been loaded correctly how would you do that? I've managed to get the first row to highlight but not the following rows.

[whitevanqueen]

Hi Anders, how would you edit this workflow to log in to a website several times using user ids and passwords in an excel sheet? Trying to do this for our time recording system at work, having issues passing arguments between workflows - ie for each row in the table, take the employee id, then pass that to the next workflow which is opening the timesheet and entering the employee id. Any tips?

[himanshutanwar]

Thank you for the videos.
One question though, I have a excel containing list of url. I want them to open one by one. Did try assign a datatable value to a variable but don't know how to pass it to the open browser url field. I tried entering just the variable name but it does not work.
Please help

[maktedarp]

Hello Anders, I liked the video and replicated the same in my code but I am getting error "ui element not initialized". It is selecting the column values in the sheet but not displaying in web page as Set Text. Please let me know if you have any solutions.

[anunegler]

Hi Anders, I have a question. I want to read the excel sheet and then I want to loop through the data in that sheet, while looping, when I loop through the first row of main spreadsheet I want the process to enter spreadsheet1 and get some data, do some operations and get back to main worksheet, loop through second row and enter to spreadsheet2 get some data there do some actions and then get back to main spreadsheet and so on. I want this to happen for all the rows which has data in main worksheet. Can you help??

[harryforlife]

Hi Jensen, once i get the result from web browser i want to copy into excel next column how do i do so? From your example, column A + Column B = Column C . I want to have the result in column C. Thank you!

[V.MITHUNCHANNEL]

Hi had one scenario will it possible to provide a solution plz
1.i had multiple excel files in data folder
2.how to read the multiple excel files as a transaction data table and transaction Item using Reframe work ..if possible can u make a video tutorials plz
Thanks in advance

[Donaldtrump]

I really appreciate you teach me a lot, I have already subscribe and like your videos. By the way, do you have any tutorial about passing data from one excel file to other excel file in "If then else" statement? As I want to get some data from one excel file and do some data filtering, then write to other excel file, I don't know how to define a variable to store the data from the excel file then pass to the new excel file. Would you please give me a hand?

[surajpatil]

Does it work if excel Is open in background and changing, please reply

[taranveersingh]

I created a process to execute on multiple excel rows using “for each row”.

It works fine except that it doesn’t repeat for the next rows.

The process involves submitting one form and then it loads another page after which I’m done with one row. I added an activity to go back to the first page after the first row tasks are done.

However, it still doesn’t repeat. When I remove the form submission on page one, the process repeats for all rows (form filling of all rows on single page minus submission and second page activities).

What do you think I’m missing here?

[EmpoweringMindBody]

my uipath doesnt have .item() function. please help me on how i can get that

[Rlikhitham]

If we have no 4 rows and and many columns if in some rows value is condersider as null sobthat we should keep the status as not eligible how should do in uipath .. can any one help me out

[piraisoodanj]

Can u post a video on "Loop through rows adding in excel sheet"

[bobforlyfe]

Do you know loop condition if there is no more excel sheets, stop the loop