Append row to Excel file

Description

Adds a row to the end of an Excel sheet.

Parameters

Path

  1. Set a value: enables you to directly write the desired path. Clicking the 'Pick' button allows you to manually choose the path.

  2. Save the previous step result: chooses the previous function result as a path.

  3. Calculate a value: enables you to use available properties and methods to form a path.

Excel sheet name

  1. Set a value: enables you to directly specify the sheet name, for example, Employees.

  2. Save the previous step result: chooses the previous function result as the sheet name.

  3. Calculate a value: enables you to use available properties and methods to form the sheet name.

Row to append

  1. Save the previous step result: chooses the previous function result as the row.

  2. Calculate a value: enables you to use available properties and methods to form the row. The format must be the following: {"Column 1": "Value 1", "Column 2": "Value 2", "Column 3": "Value 3"}. For example,

    {"Name": "Michael", "Last Name": "Smith", "Age": 30}.

Get dictionary key

  1. Use table headers: select this option if the header contains of words specified by the user (see the example above).

  2. Use column letters: select this option if the header contains of the standard 'Excel' column names: 'A', 'B', 'C' and so on.

  3. Auto: select this option to define a header by the input data automatically

Comment

Contains an annotation to the block. The input text will be displayed inside the block above the function name.