# Actions

NOTES:
Move the Foxtrot window to the right side of the screen


NOTES:
Foxtrot saves the Excel workbook to the destination defined in the variable "FileDestination" and with the name defined in the variable "FileName"


NOTES:
Move the Excel window to the left side of the screen


NOTES:
This is simply a loop that populates a random number of rows in column A


NOTES:
Foxtrot will repeat a random number of times


NOTES:
Foxtrot writes the current loop number to the current row
IMPORTANT: Notice how we use the formula "Add" to use the row current-loop-number + 1 as the column contains a header. Therefore, first loop must write in row 2, second loop in row 3, etc.


NOTES:
Create a variable to store the total number of rows to loop through


NOTES:
Retrieve the total number of rows in the workbook
IMPORTANT: You have to make sure that you use the right approach when retrieving the total number of rows. You can use the "Workbook" or "Table" target, and then you have to select the appropriate item


NOTES:
Decrease the variable with one as we do NOT need to loop through the column header


NOTES:
Foxtrot will for the total number of rows in the workbook


NOTES:
Create a variable to keep track of the current Excel row number while looping
IMPORTANT: Notice how we use the formula "Add" to use the row current-loop-number + 1 as the column contains a header. Therefore, first loop must write in row 2, second loop in


NOTES:
Create a variable to keep track of the current Excel row number while looping
IMPORTANT: Notice how we set the starting number to 2 as that is the starting point


NOTES:
Foxtrot will repeat forever - until it makes the decision to exit the loop below


NOTES:
Foxtrot evaluates whether the cell is blank. If it is blank, Foxtrot knows that it has reached the end of the table, and must therefore exit the loop


NOTES:
Foxtrot exits the loop, when the end of the table is reached


NOTES:
Increase the variable to go to the next row


# Variables_Str

VAR_NOTE:
Indicates the destination of the Excel file


