Excel

Read and write to Excel files.

WayScript supports Excel Files with extension 'xlsx'

Read File

Import columns from an Excel file as WayScript variables.

Select or Upload Excel File

Excel files on your account will appear as options. Use the 'Upload File' button to add a new file.

Select Sheet

Use the 'Sheet Name' Setting to select which sheet to read from your Excel file.

Create Variables

Once a file is selected to read, a table with the file's contents will appear in the Outputs section.

Ignore Headers

Specify whether or not to ignore the first line of the file when assigning variables.

Assigning Variables

Naming a column in the table creates a List variable with that name containing all entries in that column.

Write File

Select File

Use the file dropdown to select an existing file on your account or create a new one.

Include Headers

If checked, the variable name will be written as the first row of each column.

Write Mode

  1. Add to File: Every time the program runs, new rows of data will be added to the bottom of the Excel file

  2. 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.

Ignore Duplicates

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.

Adding Variables

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.

Sheet Name

Open the 'Advanced' section at the bottom of Settings to select a specific sheet in your Excel file to write to.

Preview

As variables are added and removed, the Outputs section displays a preview of what will be written.