Fill data from EXCEL on WEB FORM - UiPath RPA Tutorial

hello everyone my name is marcelo and this we will learn how to fill data on the waveform with the data from an excel file with white path so we have here a form and i will share the link for this form on the description of this video so we can follow this tutorial and so we will create automation that will read it from this excel file and so for each row of this excel file our automation will input the data on each field so we'll put the name under field name dash on age and so on and then we'll click on the submit button and so we'll do this process for each row so we'll submit the data official here on our web form so let's start with our automation so what's the first thing that our submissions should do so our automation first should read the data from this excel file so extract the data from this excel file so we can use that data during the automation so for that so let's go to ipad studio let's use an activity that extracts data from the excel file so let's click here on activities and let's search for read range and so we can see here two read range activities let's use the one from workbook so let's write this activity to our sequence and so this activity can extract data from an excel file so first we just have to provide the path to the excel files so let's click here and let's indicate our excel file then we have to indicate the name the sheet name from which we want to read the data so we can see that it's sheet 1 so we don't have to change here and then here so the range so here we can specify uh from where we want to extract data from the excel file so in this case we want to read the world data so we just have to give so leave this property empty and so by this way our activity will extract the world data from the excel file then make sure this property is checked so the property add enters so by this way white path will consider the first row of our excel file as the row of the column names so now we just have to create a variable that will so contain the data extracted from our excel file so here on output let's click here and now let's create the variable and now let's give the name dt underscore waveform data and so we have already created our variable so now if we run our automation these variables should have the data here from the excel file so let's just see if it happens so let's here use the whiteline activity and let's hear open double quotes and let's just type in excel so i'm just using this activity so we can here toggle a breakpoint and so if you run now our automation in debug mode the automation will stop here and then we can see the value so that contains our variables so let's run our automation in debug mode so make sure you click here on the option debug and now as you can see our automation stopped here and we can see here the value of our dt waveform data variable so if you click here we can see that it contains the data extracted from the excel file so our automation is working as it expected so let's just stop our automation and let's just delete here the right line so after we get the data from the excel file we have to open the browser on the web form so for that let's use the activity use application browser so uh this activity allows us to open the application or browser during the automation so let's run so let's drag it after the read range and now we just have to indicate the application to automate so let's click here on indicate application to automate and now let's go to our browser and make sure the browser is already open on the web form and so now we just have to click and as you can see why path extracted url of our web form so now if we run our automation so let's just close the browser and let's run we can see that automation opens the browser and then closes so let's just remove the closed parts so let's click here on our activity and then we can see here the property clause so by default it selected the option if opened by app browser so that means that if this activity opens the browser it will close it then on the end so let's just select here the option never so by this way this activity will not close the browser so let's just test and as you can see our automation finished its execution but we still have here our browser open on the web form so now we have to create the loop so create a cycle for each row of our data table so by this way for each row we will do the same actions so in this case it's fill the data on each field and then click on the submit button so to create a loop for each row on the data table we have to use the action so the activity for each row in data so as you can see here the activity so let's track this activity for here and so we just have to indicate the data table that we want it to rate the rules so we want it rates the rows of this data table so let's indicate here the name of our variable and so now inside of our four-ish row we have to perform solid activities that will input the data and click on the submit button so here we have also access to the current rule so with this variable let's say we have access to the data of the row so let's just see how it works let's type in here message box and let's write this message box inside of our foreign data table so we can have access to the current row and then if we type here current row we are calling the row that it's being iterated so uh for each row what will happen basically so let's just open the browser so first this foreign data table will iterate this row and then when it goes to the end here on the body will it will get the next and so we will have access to this row and then next one next one until we don't have more rows to process so now how we can get specific data from each row we have to indicate basically the code name related to the value that we want to get so let's say we want just to get the name of each row so we have here to open variances and the walkwards and then we have to indicate the column name so as you can see here the column name its name so let's type in here name let's convert this to string and now let's run automation to see what will happen so let's run our automation and as you can see we got so the name of the first row so it's john then we got of the second rose sofia peter diana robert and then now automation should finish its execution so as you can see we learned now how we can get specific data from issue so let's delete this message box so now that we can iterate each row of our data table we have to use activity that can fill data on each field so let's click here on activities and let's search for the activity typing and so let's track type inactivity inside of our loop of our foreign data table and so this activity can input data on fields so we just have to indicate to this activity where we want it to fill data so let's click here on indicate target on screen and now let's indicate here the field related to the name so let's indicate and now let's indicate answers so this activity can detect uniquely this field so let's indicate here the label name and now it's nice so appears here a green so let's click here on confirm and now we should indicate what these activities should type on this field so in this case it's the name on each row so the the value related to the name so let's call here our row operances double quotes and so as we can see on our excel file the column name its name so let's type in here name and now dot to string so let's test our automation to see if it's working well so let's run and so as you can see automation it's working as expected so now we just have to do the same to the other fields so we need another two typing activities so let's just copy this activity so let's copy now let's paste with ctrl b and now so let's initiate the second field so the field age and now let's indicate the answer so the label age and let's click on confirm and so in this case the column name should be h as we can see and now here for the last so will be for the field city so let's indicate the answer let's confirm and now here so the code name related to the value of each city so each city it's the com city and so now what we have to do more so after our automation inputs the data on each field it should click here on the submit button so for that let's use the activities click after uh did i type in activities and so now we have to indicate uh the button to this activity so let's indicate it and now let's confirm and so let's see what appears next so let's here just type random data let's click on submit and as you can see after our automation click on submit it should click also here on this link on our where say submit another response because if it doesn't click here it will not be able to input the data of the next row so let's add another click to click here so on this link and now so our automation should basically read the data from the excel file and export the data to this variable then open the browser on our web form and so for each row it's true so basically fill the data on each field click on the submit button and then click so here on the link submit another response to be able so to input the data of the next row so let's close the browser and let's run our automation and so as we can see automation is working as it expected so it's going through each row and so far each row fills the data on the field name age and city then clicks on the submit button and clicks on the submit another response so it can fill the data after another row so i hope you liked this video don't forget to leave a like and subscribe to the channel so you don't miss any more white path related videos bye bye

Channel: Marcelo Cruz

Views: 30,909

Keywords: rpa, robotic process automation, rpa automation, rpa uipath, uipath, rpa tutorial, uipath tutorial, rpa demo, rpa training, uipath academy, rpa developer, uipath fill form, uipath tutorial for beginners, uipath tutorial 2021, rpa tutorial for beginners, what is rpa, uipath academy tutorial, uipath academy free, automate data entry from excel to web, uipath tutorials, robot data entry

Id: vnhWtP0Z5uQ

Length: 15min 19sec (919 seconds)

Published: Tue Aug 10 2021