How to read data from excel and search on a web page?

Help
, , ,
1

How to read data from excel → find value in web—> click it?

2

Use Read Range Activity to Read Excel file

3

and find value in web?

4

Its depend upon which type of selector of element/value you find on web

5

value from child page.

6

Find value in web means you want to search that value on screen or want to search on web

7

find value on child web.
But value is from excel.

8

You wanna find that value ?
Is that value present on that child web page???
If yes then using Text Exist You can do…

10

I want to map data from excel to web and click it.
Example: I want set row after MM-YYYY in excel = Start date
and row before total = end date

then send 2 value to web and robot choose for click.

image

11

You just want to take data from 1st row and second last row ryt?
Then according to that map it on Web

12

From MM-YYYY
till total you want all the data in between?

13

I want start date and end end date to find value in webpage dialog and click it.

14

if you want specific column values use read range from excel, it will return datatable then use this code … datatable.rows.item(“the column you want”).tostring

and use them in web using for each row
i hope this helps

Thanks
Raghava

1 Like
15

Now, I can read value from excel.
but i can’t bright value to find in webpage dialog and click.

1 Like
16

@fairymemay can you send me the screen shot of web so that i will help you out

17

@fairymemay i thinky you want to get specific column tems and search them in web accordingly …so try using for each row activity get item and use type into activity AND click on seach using click activity …

18

hi guys…
Is there any activity which can be used to search for an element and click on it

eg- reading value from excel and then search for the same in application and if it is found i need to click on it…

19

Use find element activity…

20

@charan1 Thanks dude!! working

can any one help me out with orgainizing my project… have to do multiple tasks… so is there any possibility of creating multiple folders and calling them sequentially in 1 single prjct

21

:tada:welcome