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.
You can Use For each row in data Table activity. It will iterate to all the lines in the excel.
Check out this video link
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.