Actions14
- Sheet Actions
- Table Actions
- Workbook Actions
Table → Append Row
AI-generatedSummary
Append a new row with specified column values to a named Excel table in a spreadsheet file stored on Nextcloud, extending the table range accordingly.
Inputs
- filePathMode (required) — Select whether to specify the spreadsheet file from a list within a folder ('From List') or by entering a dynamic file path expression ('By Path (Expression)').
- folderPath — When 'From List' is chosen for filePathMode, select the Nextcloud folder to filter and list spreadsheet files from (default is the root folder '/').
- filePathFromList — When 'From List' is chosen for filePathMode, select the spreadsheet file in the specified folder to modify.
- filePath — When 'By Path (Expression)' is chosen for filePathMode, provide the full path to the spreadsheet file on Nextcloud.
- tableMode (required) — Choose how to specify the named table: from a selectable list ('From List') or by entering the table name via expression ('By Name (Expression)').
- tableFromList — When 'From List' is chosen for tableMode, select the named Excel table within the workbook.
- tableName — When 'By Name (Expression)' is chosen for tableMode, provide the name of the named Excel table to append the row to.
- tableColumnValues (required) — Add one or more column-value pairs indicating which columns to write and the corresponding values for the new row.
Output shape
a single JSON object indicating success containing the operation name, target table name, and the appended row data.
The operation appends the new row at the end of the table by extending the table range and uploads the updated spreadsheet file back to Nextcloud. The result JSON confirms success and echoes back the target table name and row data. Errors in locating file or table cause the node to throw unless 'Continue On Fail' is enabled.
Examples
Example 1: Append a row to a named Excel table in a Nextcloud spreadsheet
Select the spreadsheet file from a list in a folder or specify its path; choose the target named table from a list or provide its name; specify column names and values to append as a new row.