URL - List of URLS in Excel. I need to cycle through 1 at a time and run
B
Brett Smith
started a topic
8 months ago
I have a list of URLS
I want to start at the top. Open that URL, Copy the path, delete the row so its no longer on the sheet and then do the job i have programed then close and get the next one and continue on.....
HOW?
Best Answer
C
Christos Millas
said
8 months ago
Hello Brett,
Please do the following:
-Use the Launch Excel Action , to instantiate the excel file that you want to use.
-Use Get First Free Column and Row Action.
-Use Read From excel Worksheet (the range of cells that contain the urls).
-Use Launch New Chrome (or other browser) Action
-Use the For Each Action (to iterate through each website)
-Use Go to Web Page Action (and use the variable of "For Each" Action)
Brett Smith
I have a list of URLS
I want to start at the top. Open that URL, Copy the path, delete the row so its no longer on the sheet and then do the job i have programed then close and get the next one and continue on.....
HOW?
Hello Brett,
Please do the following:
-Use the Launch Excel Action , to instantiate the excel file that you want to use.
-Use Get First Free Column and Row Action.
-Use Read From excel Worksheet (the range of cells that contain the urls).
-Use Launch New Chrome (or other browser) Action
-Use the For Each Action (to iterate through each website)
-Use Go to Web Page Action (and use the variable of "For Each" Action)
-Lastly, add your functionality!
Does this works for you?
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstChristos Millas
Hello Brett,
Please do the following:
-Use the Launch Excel Action , to instantiate the excel file that you want to use.
-Use Get First Free Column and Row Action.
-Use Read From excel Worksheet (the range of cells that contain the urls).
-Use Launch New Chrome (or other browser) Action
-Use the For Each Action (to iterate through each website)
-Use Go to Web Page Action (and use the variable of "For Each" Action)
-Lastly, add your functionality!
Does this works for you?
Brett Smith
Hi There.
Can you please see attached and let me know where I am going wrong.
My excel has a list of URLS in Column A and starting from row 1. There is about 500 of them. I want it to get them and just work the way through
Christos Millas
Hello Brett,
In action #3 you need to read a range of cells, so as to grab multiple data and iterate through them. Please see image below for reference:
Brett Smith
Christos Millas
You are welcome!
Keep on automating :)
-
Best Practise Developer Guide
-
New V8 has cookie problem
-
excel update
-
Example using multipart/form-data to upload a file
-
Connect to Exchange OWA
-
How to use Get Data With ABBYY FlexiCapture
-
Viewing support tickets raised by all users
-
Excel columns sorting
-
Need help reading values from ini file
-
Image in Email Body
See all 390 topics