Excel

Seamlessly integrate Microsoft Excel files with your favorite APIs, databases, and programming languages, using WayScript.
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.