I know it's possible to scrape data from a website and put it into excel, but is it possible to take data from excel, put it into an input (IE a search bar), then once the results are returned to the page automate the clicks needed to navigate to a certain page within that returned data, and then select a specific element and push that back into a different excel column?
Basic flow would be
Column 1 = "Name" > Credentialed Chrome Web Page input > Click Search > Wait > If data is returned click on designated tab > query select specific data "Location" > Store that data in a variable and return to Column 2 = "Location" in excel
I know how to scrape a page but I'm not sure how to export data to that page, store it, and then return it to another column in excel.
This would also be for multiple "Names" in the excel sheet so it would have to go one at a time. I'm not sure where to start with this so any guidance would be appreciated.
Aucun commentaire:
Enregistrer un commentaire