I put three different URLs in excel in column A, rows 2,3,4 respectively, and I want to read the three URLs in sequence by looping through the forLoop tool to get him to transfer the URLs from the second row onwards each time he adds an extra row. However, the logic I wrote in AUTOMATION should not be a problem, but each time the loop starts it can only read the first URL, what is the situation? Can you tell me about this?
You need to delete your “Loopstart” jump label. The loop runs automatically, so when you reach then end of a loop, the next execution will be the “Yielded” execution point.
Incidentally, your automation will probably not work as you intend as shown even after removing the jump label. This is because when you can navigate, it will happen asynchronously. That method will return before you’ve reached the page you are navigating to. I suspect this will almost instantly process all your records and ultimately your browser will be loading whatever your last URL was.
I also notice you are using multiple Excel connectors. The MicrosoftExcelConnector is mainly used when you need to see the Excel document in operation. Use the ExcelConnector for almost all operations as it is more robust and operates much faster.
Below is an example of how I would recreate the functionality you were going for.
@ThomasSasnett
I will further try the moves offered from your side，Thanks for your help.