Actions7
Row → Append Row
AI-generatedSummary
Adds a new row to the end of the specified worksheet, either reusing the first empty row after the data or adding a new row if none exists.
Inputs
- inputMode (required) — Method for providing the Excel file: 'filePath' (file system path) or 'binaryData' (binary property name).
- filePath (required) — Absolute path to the Excel file. Required when inputMode is 'filePath'.
- binaryPropertyName (required) — Name of the binary property containing the Excel file. Required when inputMode is 'binaryData'.
- sheetName — Name of the worksheet to operate on. If not specified, the first worksheet is used.
- rowData (required) — Row data as a JSON object. Column names are automatically mapped to the worksheet headers.
- autoSave — Whether to automatically save changes to the file. Only applies when using file path mode.
Output shape
A single record containing success status, the target row number, the input data, and an optional message indicating if an empty row was reused.
In binary mode, the node returns the modified workbook in binary data format. The row is appended after the last row containing actual data, reusing the first empty row found if possible.
Examples
Example 1: Append a single new row to the end of an existing worksheet using a file path.
Input Mode: File Path, File Path: /data/sales.xlsx, Sheet Name: Q1, Row Data: {"Product": "Widget", "Revenue": 5000}
Example 2: Add data to a worksheet using binary input from a previous node.
Input Mode: Binary Data, Binary Property: data, Row Data: {"Name": "John", "Status": "Active"}