NextCloud Spreadsheet icon

NextCloud Spreadsheet

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

Actions14

Sheet → Clear

AI-generated

Summary

Clear all data rows in a specified worksheet while preserving the header row.

Inputs

  • filePathMode (required) — Choose whether to select the spreadsheet file from a list or specify the file path via expression.
  • folderPath — Select the folder to filter the file list when choosing the file from a list.
  • filePathFromList — Select the spreadsheet file from the filtered list when choosing from list.
  • filePath — Provide the exact path to the spreadsheet file when specifying by path.
  • sheetHeaderRow — Specify the row number containing the column headers (defaults to 1). Adjust if your headers are on a different row.
  • sheetMode — Select which worksheet to clear: from a list, by name expression, or the first sheet.
  • sheetFromList — Select the worksheet from the list when sheetMode is 'list'.
  • sheetName — Specify the worksheet name when sheetMode is 'name'.

Output shape

a list of JSON objects each indicating success and the cleared sheet name, including column headers preserved

The output confirms success with a JSON object containing operation details and the preserved columns. If an error occurs and 'Continue On Fail' is enabled, it reports the error per item; otherwise, execution stops with an error.

Examples

Example 1: Clear the data rows in 'Sheet1' of '/Documents/data.xlsx' while preserving the header row.

Set 'From' to 'By Path (Expression)' and provide '/Documents/data.xlsx' as the file path. Specify 'sheetHeaderRow' as 1 if headers are on the first row. Set 'Sheet' mode to 'By Name (Expression)' and enter 'Sheet1' as the sheet name. Choose the 'Clear' operation.

Links

Discussion