Read data from excel and write it into a browser

[Fumani_Mlambo]

I am trying to copy data from excel and use it as input on a field in a web browser. I have successfully done this for one field, but I want to iterate this process because I have multiple records in the spreadsheet.

[Gokul001 (Gokul Balaji)]

Hi @Fumani_Mlambo

You can Use For each row in data Table activity. It will iterate to all the lines in the excel.

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @Fumani_Mlambo

Check out this video link

UiPath For Each Row Example

Regards
Gokul

[AM_CROUS]

Hi @Fumani_Mlambo, you can use the Read Range workbook. Then enter the file’s location path and the sheet’s name where you want to read the data. Remember to use quotation marks for example: “Sheet 1”. In properties select the DataTable you wish to read the data into.

Then use the for Each Row in Data Table and select the DataTable you wrote the data into. In the body, you can continue with the operations you want.

Regards
AM

[Fumani_Mlambo]

Thanks Goku