Check from excel list

excel
uiautomation
activities

#1

Hello All,

I have a list in excel need to check in web ,then scrape web data.

Is there anyone know how to copy data from excel to web?

thanks in advance for your kind help.


#2

Hi! Use Excel application scope and give the path of the excel file by clicking on the three dots.
After that use a read range activity to read all the data from excel…
Now use a for each row activity and filter the data from excel, for eg. If you want data from “Name” colum
Use row(“Name”).toString…
Now put this data into the web application using type into…


#3

I’ve tried your sugguestion, and error happen as below.

%E5%9B%BE%E7%89%87

my work flow is like this

Do you know why?

thanks


#4

What are you typing inside the field? Could you please tell that.


#5

Also if you could please send the xaml file.


#6

Here is what I type into

%E5%9B%BE%E7%89%87

is that correct?

thanks


#7

Sorry I can’t share the xaml since it’s internal company web…


#8

Have you included the headers?


#9

HU Reference is the header.

here is how excel data like

%E5%9B%BE%E7%89%87

thanks


#10

Go to Read Range activity and check the Add Header property…


#11

Add%20header
Or just use row(0) instead of row(“HU Reference”)


#12

Thank you, I found it and another error happen:sob:

%E5%9B%BE%E7%89%87

do you know why?


#13

Try to indicate the element again! Check if the selector changes.


#14

And the field you where you are typing the data, that is an input field Right? I mean is it a drop-down?
Also try playing with properties of type into. Try changing waitforready property to NONE. It might work.


#15

I’ve change the waitforready to null, It works, but it can only type in excel file. It can’t turn to web page and insert the .

The field is the input field , not drop down.


#16

Try indicating the input box using UIExplorer and try to add more tags…that might help


#17

Hi! Try using anchor base like this:
Anchor Base Example.zip (5.6 KB)
Read this link:


I hope now your issue will be resolved :slight_smile:


#18

Yes,it works. Thank you a lot!:slight_smile:


#19

Welcome Mate :slight_smile:
please mark it as a solution so that others can use it!