If checked, the variable name will be written as the first row of each column.
Add to File: Every time the program runs, new rows of data will be added to the bottom of the Excel file
Replace File: Every time the program runs, the file will be cleared before writing new data.
Headers will only be written when the file is blank.
If 'Include Headers' is selected, changing a variable name when adding to an existing and non-empty file will not replace the header row.
The Ignore Duplicates Setting makes it easier to avoid writing redundant data to your file.
When you select 'All Columns' or a specific column, the Excel Module will compare the new data to be written against the rows already in the file. If there is a match according to your selection, the new data will not be written.
Each time the Excel Module executes in Write Mode, one row of data is added.
To write each entry of list to a new row, use a Loop.
Open the 'Advanced' section at the bottom of Settings to select a specific sheet in your Excel file to write to.
As variables are added and removed, the Outputs section displays a preview of what will be written.