Best approach to read many fields from excel and paste /enter on webpage


#1

Hi,
I am new to uipath and want to implement below scenario.
I want to read data from around 30 cells on excel and then want to enter those fields on webpage.
Webpage is also having equivalent 30 fields
Can you please suggest best approach for that ?

Reading each excel cell and put details using type into is the only option ?

Thanks!


#2

You can take all the data into a Datatable (using Read Range Activity) and iterate through the datatable to put the values on the website (Type Into)


#3

@Shashii
Use Excel application scope
Read range activity (store variable in type data table)
Use fo reach row (pass data table variable here)
Use get row item (it will give ur cell store in string variable )
Use type into activity (pass string variable here)

Reference


#4

Got the read range part but do I need 30 "Type into " activities ?


#5

@Shashii No in one type into activity just pass variable it will iterate


#6

if possible please share the example


#7

@Shashii Can you share webpage you are trying to automate


#8

for simplicity we can consider https://login.oracle.com as its having only two fields.
Thanks for the time


#9

@Shashii https://login.oracle.com its not working for me attached zip file is for googe sign up page values are retrieved from excel and entered into sign up page check it

GoogleSignup.zip (24.4 KB)


How to paste something from excel to the browser by using UiPath/
Data from excel to web looping
#10

Thanks Indra… but for 5 fields you used 5 Type into activities

So if on same webpage… In case there are 30 fields… do we require same number of type into activities ?
Is there any way by using which just one type into for all the 5 fields ?


#11

@Shashii Yes If there are 30 fields in excel and 30 text box in web page than you need 30 type into actvity