How to read data from excel --> find value in web—> click it?
Use Read Range Activity to Read Excel file
and find value in web?
Its depend upon which type of selector of element/value you find on web
value from child page.
Find value in web means you want to search that value on screen or want to search on web
find value on child web.
But value is from excel.
You wanna find that value ?
Is that value present on that child web page???
If yes then using Text Exist You can do…
then send 2 value to web and robot choose for click.
You just want to take data from 1st row and second last row ryt?
Then according to that map it on Web
till total you want all the data in between?
I want start date and end end date to find value in webpage dialog and click it.
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
Now, I can read value from excel.
but i can’t bright value to find in webpage dialog and click.
@fairymemay can you send me the screen shot of web so that i will help you out
@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 …