NextCloud SpreadsheetInstall

Summary

Delete a specific data row from a worksheet in a spreadsheet file stored on NextCloud by specifying the file, worksheet, and row number to delete.

Inputs

• From (required) — Choose how to specify the spreadsheet file: from a list of files in a folder or by a direct path expression.
• Folder — Select the folder to filter spreadsheet files when 'From List' mode is selected.
• File — Select the spreadsheet file from the chosen folder when 'From List' mode is selected.
• File Path — Direct path to the spreadsheet file when 'By Path (Expression)' mode is selected.
• Header Row — Row number in the worksheet containing the column headers (default is 1). Adjust if headers are not on the first row.
• Sheet — Choose the worksheet to operate on, either from a list, by name expression, or the first sheet in the workbook.
• Row Number (required) — The 1-based index of the data row to delete, where 1 represents the first data row just below the header row.

Output shape

a list of JSON objects each indicating success status, the operation performed, the sheet name, and the deleted row number, one per input item.

Returns an object with success confirmation and details for each processed input item. If an error occurs and 'continue on fail' is enabled, the error message is included per item instead of stopping all processing.

Examples

Example 1: Delete the second data row from the sheet named 'Sheet1' in a file selected from the folder '/'

Set From='From List', Folder='/', File='data.xlsx', Sheet='From List' and select 'Sheet1', Row Number=2

Example 2: Delete the first data row from a spreadsheet specified by direct path

Set From='By Path (Expression)', File Path='/Documents/data.xlsx', Sheet Mode='First Sheet', Row Number=1

Links

• n8n community nodes installation guide