I have excel file, I need to read excel and dump that values into website and get Response from that and paste it in excel…
i am done with almost all part of it…
but iam not able to scrape the ans from the website, selector problem can anyone help me , i need to submit it by End of the day so please…
On each loop of the currencies, I am sure there is only one result you wish to grab i.e. the conversion rate. Well then it is better to use the GetAttribute activity instead of the ExtractStructuredData activity. See below, the selector has had a wildcard added and the attribute being grabbed is aaname.
The output shows that it has been grabbed successfully:
It seems your workflow is failing because the extract structured data activity needs to be more dynamic as the element you are scraping is changing quite a lot of its attributes. It will be less work to use GetAttribute as above, and redesign how you output that data to your spreadsheet which should be straight forward.
A few things have changed to make this work. I have generated the ExtractDataTable in an activity rather than just initialise it in the variable pane to allow it to accept the AddDataRow activity easily.
The GetAttribute is now used to grab the rates.
It seemed to me your workflow was also looking at the wrong tab for grabbing currency rates. So it goes to Live Market Rates to grab. If that is an issue, please review and troubleshoot.
Please ensure Google Chrome is at 50% zoom to allow the elements to be seen without need to scroll.
I have also removed the SimulateClick properties on some clicks to ensure it works. If this is an issue in terms of how you wish to use the workflow, you’ll need to troubleshoot that.
I have also used relative file paths as your workflow used personalised paths where required.
if you are using readrow this will output your row as a row object. to see the values of this object you need to output in a write line as row.item(“ColumnName”).tostring
Here I developed bot like
Am getting data from currency & to currency from excel & getting currency from web
Have you saw my flow
Open & run the bot ,check the output,See entire flow were you you haven’t understood let me know I will explain.
I think it was done ,Select the mark as solved