Skip to next index/Excel row in forLoop
I am working on a project where I am reading in excel values and storing them as global variables so that I can use those values in other automation files. My main Automation file that starts the project is reading in data, making a decision and then using that rows data to fill in form data, download and move the file. When I download the file I am writing to a column that indicates if I have downloaded the file or not. I need away to prevent duplicate downloads and to end the file on the last row of the Excel file. What I am trying to do is create logic that looks for the completed download value. If the value is "Yes" then I want to skip to the next row in the excel file. How can I skip to the next row in the excel file if the condition is "Yes"? I have all of the logic I just can not figure out how to move to the next row in the Excel file.
Accepted Solution
Updated: 25 Mar 2021 9:25 EDT
Transplace
US
I was able to resolve this. Turns out that I needed to end the script and not just break the forLoop.
Transplace
US
I am having issues with the global variables not updating after I update the column and cell for a particular report to "Yes" indicating that I have downloaded and saved the report. I have and exit in the automation file that sets the cell value as complete. The problem is if it is the last row in the excel spreadsheet the global variable that I am using does not update to "Yes" so that I can break the loop. The way that I set my logic up is I first check if the report has been downloaded by checking for "Yes" in a column, if True and the forLoop index equals the LastRow in the Excel file I break the loop. If False I am executing an empty automation file so that I can move onto the next index in the forLoop. Everything works except for the last row in the Excel file. After I download the report and set the cell value to "Yes" the global variable is not updating and the last file in the Excel report just keeps downloading over and over. How can I get the Global Variable to update on the last row so I can break the loop?
Accepted Solution
Updated: 25 Mar 2021 9:25 EDT
Transplace
US
I was able to resolve this. Turns out that I needed to end the script and not just break the forLoop.