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:
🔵 UiPath RPA Beginners Tutorial - • UiPath RPA Beginners Tutorial
🔵 UiPath Data Scraping (Web Page to Excel) - • UiPath Data Scraping (Web Page to Exc...
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
For the first row of data, we type the data into an web application. We finalize with an accept click. To target the right row we use a little bit of VB .NET code. That's the coding language of UiPath and I can recomend this book, if you want to learn it: https://geni.us/v6ffI (affiliate).
Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeande...
💼 LinkedIn - / andersjensens
👥 Facebook - / andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsle...
#uipath #rpa #automation
Смотрите видео UiPath - How to loop through rows and columns in Excel and pass values to web search/input онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Anders Jensen 24 Март 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 40,750 раз и оно понравилось 405 людям.