How to loop through rows and columns in an excel and pass them to a webpage

[Jarzzz (Kyle)]

@Pals Do you have an activity after your “Type Into” activity? Is Empty Field checked? If not, the process will continue to loop until all rows are written.

[yushinchan]

Hi Vikas,

Can I know how do you resolve the problem that you mentioned above? As I was doing the same mistake as you even I followed the steps as mentioned above. Thanks for your sharing.

[maria_baby]

Hi,
If there are more than 20 columns in the excel sheet…Should I use 20 get row items ? Or is there any other method?
TIA

[sandipauti (Sandip)]

@maria_baby - You can loop though datatable using for each row activity.

For more reference use

https://docs.uipath.com/activities/docs/for-each-row

[mhon (Supakinee N.)]

Your answer is awesome. I can use this step for my job. Many Thanks for your kindness.

[pradeep26 (Pradeep Satvekar)]

@Rammohan91

Follow the below steps:

1. Use ‘Excel Application Scope’ activity and Add ‘Read Range’ activity inside the scope.
2. Create a DataTable variable and assign it to the output property of Read Range activity. Not all your username and password date is in that DataTable variable. Lets say it is dtCredentials.
3. Now use a ‘For Each Row’ activity after the ‘Excel Application Scope’ activity.
4. Add ‘Assign’ activity inside the for each loop and create string variables named ‘strUserName’. Assign should be like this “strUserName = row.item(0).ToString”
5. Add another ‘Assign’ activity next to the first assign activity. Create another string variable named ‘strPassword’. Assign should be like this “strPassword = row.item(1).ToString”.
6. Add an ‘Open Browser’ activity with the login page url.
7. Add a ‘Type Into’ activity inside the Open Browser activity and indicate your username textbox.
8. Pass the value of the text as ‘strUserName’.
9. Add another ‘Type Into’ activity after the 1st one and indicate your password textbox.
10. Pass the value of the text as ‘stePassword’.
11. Add a ‘Click’ activity and Indicate your submit button.

Note: Step 4 to Step 11 should be inside your for each row loop.

how to do it?
if the data is in 3 row. how assign it

[angelia (Angelia Howard)]

Thank you for the steps. One more question.
How would I write “Pass” or “Fail” to the rows in Excel as I process each row?

[BernardD (Bernard Dandan)]

Thank you, but what if I want to have each row inputted in different text boxes on a single website? If I do the step above, I will have only one variable assigned to each. I want one variable be assigned to each row in the same column, so that Row 1 column 1 be entered into text box 1 on the website, then enter row 2 column 1 to the next text box. How can this be done?

[hoang_thien (hoàng thiên)]

Hi Rammohan91. This is great answer . I learned very much from y

[technixtechnologies (Support)]

This has helped us a lot today. Many years later

[Sanat_Pattnaik]

Hi Rammohan,
I need a Help On Web automation From Excel.
I have a Excel workbook with two column Thats A & B with 100 records and i want to do the Entry on a website but the Problem is its running only once & not doing the same for 2nd onward records i have checked all the Things but not Found the solution. Also i have created same thing for another website that’s work fine but this one not working.

Please Any Suggestions…

[pranam.gangadhar]

@Sanat_Pattnaik

m is its running only once & not doing the same for 2nd onward records i have checked all the Things but not Found the solution. Also i have created same thing for another website that’s work fine but this one not working.

Hi Sanat,

Add the activity within a For Each Excel Row Activity. It will repeat the same action for row 2 until last row in question.

[Dawodm (Mahmoud Dawod)]

Please see this video to learn more about looping rows and columns in Excel.

UiPath | Loop through Rows and Columns in Excel | Loop Excel/DataTable rows and columns in UiPath

Best regards
Mahmoud

[Fahim_Aktab]

What to do if I want to enter 6 row data into web form and save it and again enter data for next 6 rows and again save. Thus looping this to the last of the row.
Thank you.