Work with Excel Spreadsheets

Read File

Select or Upload an Excel File

When the excel module is activated, the default setting is to read a file. Reading files allows you to import columns into WayScript as variables.

Columns Appear

Once a spreadsheet is selected, the spreadsheet will populate on the page. Notes: The 'Sheet Name' selector can be used to pull in data from different tabs on a spreadsheet The 'Ignore Headers' checkbox can be used to prevent WayScript from pulling in column headers if they exist in the file. Row 1 in this image shows an example of headers that I might want to ignore.

Import Columns

In order to import a column as a variable, the column must be labelled. Then, the column will appear under variables.

Write File

Choose A File To Write Data

Pick a file to write or create a new file.

Include Headers

If this is checked, the variable name will be written as the first row of each column. This is useful for others to understand what data lies beneath it.

Write Mode

Add To File: every time the program runs, new rows of data will be added to the bottom of the spreadsheet Replace File: every time the program runs, the file will be wiped clean before the program runs.

Ignore Duplicates

The excel module allows you to ignore duplicates. In other words, if the same data already exists as a row in the spreadsheet, the file will not write it again. Ignore All Columns: If the entire row is equal to another entire row in the spreadsheet, it will not write the row again. Ignore A Specific Column (Ex: Column 1): If the selected column already contains the value about to be written to that row, the row will not be written.

Write Your Columns

You need to assign values to columns by pressing the + button under add your variables. Then the values of these variables will be written to your excel spreadsheet when your program runs. You can add as many columns as you would like.

Advanced: Sheet Name

You can add a sheet name, this can be a variable or hardcoded (as shown). This value will be assigned to the tab. Assigning a variable will create a new tab for each variable value.