How to Fill WEB FORM with EXCEL Data in UiPath
In this UiPath tutorial, we will learn how to read data from Excel sheet and retrieve List to Datatable. We will get each row one-by-one and fill Employee Contact Info (Google Forms) Form fields with respected value in datarow. We will use also Open Browser and Navigate activities to handle Browser Automation.
👉 Follow me:👇👇
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
🔔 Subscribe - / @oguzhansanyilmaz
💼 LinkedIn - / osanyilmaz
💻 Website - https://automationschool.org/
[00:00] - Introduction
[00:40] - Reading Excel File
[01:55] - Opening Browser
[02:40] - Datatable Iteration - For Each Row
[03:35] - Name - Reading & Typing Value
[05:20] - Email - Reading & Typing Value
[06:33] - Department - Reading & Typing Value
[07:50] - Address - Reading & Typing Value
[09:00] - Adding Submit Button
[09:20] - Adding Delay & Navigation
[09:55] - Adding Navigation to Google Forms Page
[10:20] - Adding Close Tab
[10:45] - Running the Project
[12:10] - Conclusion
[12:45] - Outro
