NextCloud Spreadsheet icon

NextCloud Spreadsheet

Read and write spreadsheet files (.xlsx, .ods, .csv) stored on Nextcloud — includes named Excel table support

Actions14

Table → Delete Row

AI-generated

Summary

Deletes a specific data row from a named Excel table in a Nextcloud spreadsheet file and shrinks the table's range.

Inputs

  • filePathMode — How to specify the spreadsheet file: 'list' (select folder and file from dropdowns) or 'path' (provide file path string/expression).
  • folderPath — Folder path used to filter the list of available spreadsheet files when filePathMode is set to 'list'.
  • filePathFromList — The target spreadsheet file chosen from the folder list when filePathMode is 'list'.
  • filePath — The Nextcloud file path to the spreadsheet file (e.g. '/Documents/data.xlsx') when filePathMode is 'path'.
  • tableMode — How to specify the table: 'list' (select from available tables) or 'name' (specify table name directly).
  • tableFromList — The selected named Excel table when tableMode is set to 'list'.
  • tableName — The name of the Excel table when tableMode is set to 'name'.
  • tableRowNumber — The 1-based data row number within the table to delete (1 represents the first row of data below the table header).

Output shape

a single record

Returns a status object confirming successful deletion, including success, operation, tableName, and deletedRow.

Examples

Example 1: Delete the first data row of a named table chosen from a list

Set From to 'From List', pick Folder and File, set Table to 'From List', pick table, and set Row Number to 1.

Example 2: Delete a specific row dynamically using expressions

Set From to 'By Path (Expression)' with File Path '=/Documents/sales.xlsx', Table to 'By Name (Expression)' with Table Name 'OrdersTable', and Row Number to '={{ $json.__rowNumber }}'.

Links

Discussion