I’m going to jump right to the chase: I’m trying to copy-paste data from each row in a column in excel to multiple textboxes on a website called tailwind.
Here’s a visual representation of what I’m trying to achieve:
I have to do this 150 times each day, so automating it would help me a lot…
Now, I’ve tried my best to come up with a way for doing this - I’ve assigned the target to one text box, but I don’t know how to make uipath get to the other one or how to define multiple selectors on the same page…
Can anyone help me please? Thanks!
P.S: I’m very limited when it comes to anything about coding, so please…Take me slow
Hi
Welcome to uipath community
May I know how many text boxes are to be filled
And were we we able to select them as individual elements…if so here you go
—use a excel application scope and pass the file path as input
—use read range activity and get the output with a variable of type outdt a variable of type datatable
—use a for each row loop and pass the above variable as input
—inside this loop use a open browser and mention the url of the page we need to navigate
—there we can use simple click and type into activity if we are able to select each text box as individual elements and don’t need to worry about the dynamic selectors as we can replace such attribute values with * wildcards
That would work for sure
Hope this would help w
Kindly try this and let know for any queries or clarification
Cheers @Josh_Teller
Hey @Palaniyappan, thank you very much for your insights!
I’ll also answer your question with this occasion: You can select each textbox individually, as they have the following id: “description-placeholder-977823”,“description-placeholder-977825”.
Thank you for the steps you’ve outlined above, and sorry if I sound stupid but I’m a bit confused on steps 2 and 5.
Step 2: How do I define and use the variable? Should I put it in the “output” box, and then create a variable?
Step5: Do I need a click + text into action? And how do I pass from one textbox to the other using them? Could you help me a bit with the * wildcards?
Ok so I managed to get a script working. Unfortunately, the only problem I have is that it depends on the first description-placeholder-“id” to work.
For each text box, the id is added a 2.
So the id’s for each textbox are “description-placeholder-19000”, “description-placeholder-19002” “description-placeholder-19004” etc…
These id’s change from one page to another, so I was wondering if there’s any way I could make UiPath select the first ID no matter what cell it is, and then grow from there. Here’s two snapshots of Ui Explorer and the website to see what I’m talking about…
Hi
I get one task
I have given with excel sheet which contains URLs
The task is to copy each url and we have to search it and fetch information in it, and data should be stored in excel.
This method should repeat for all urls
Plz help me I don’t know how to complete this task
And I am new to uipath field
ashokkarale
Anil_G
Soudios
ppr
Yoichi
lrtetala
Anjani_Kapoor
sarikayaebru
rodrigo.simao
Jon_Smith