Actions14
- Sheet Actions
- Table Actions
- Workbook Actions
Table → Update Row
AI-generatedSummary
Update the values of a specific row within a named Excel table stored on Nextcloud by specifying the table and row number, and providing new column values.
Inputs
- From (required) — Choose how to specify the spreadsheet file: either select from a list or provide a file path expression.
- Folder — When selecting file from list, choose the folder to filter the available spreadsheet files.
- File — When selecting file from list, pick the spreadsheet file in the selected folder.
- File Path — When specifying by path, provide the full path to the spreadsheet file on Nextcloud.
- Table (required) — Select the named Excel table to update either from a list or by name expression.
- Row Number (required) — Specify the 1-based data row number within the table to update.
- Column Values (required) — Provide the column names or IDs and their new values to set in the specified row.
Output shape
a single JSON object indicating success, including the operation performed, table name, row number, and the updated data values.
Returns one output JSON object per input item with a success flag and details of the update action. If an error occurs and 'Continue On Fail' is enabled, the output will contain the error message for that item.
Examples
Example 1: Update specific columns of row 3 in a named Excel table
File selected from folder '/Data', file 'report.xlsx', table selected from list, updating row number 3 with new values for specific columns.