Excel AI icon

Excel AI

Perform CRUD operations on Excel files with AI Agent support

Actions7

Row → Delete Row

AI-generated

Summary

Deletes a specific row from an Excel worksheet, shifting subsequent rows up. Row 1 is reserved for headers and cannot be deleted.

Inputs

  • inputMode — How to provide the Excel file: 'File Path' uses a file system path, 'Binary Data' uses a binary property.
  • filePath — Absolute path to the Excel file (required when inputMode is 'File Path').
  • binaryPropertyName — Name of the binary property containing the Excel file (required when inputMode is 'Binary Data').
  • sheetNameOptions — Name of the worksheet to operate on. If not specified, the first worksheet will be used (available in file path mode).
  • sheetName — Name of the worksheet to operate on. If not specified, the first worksheet will be used (available in binary data mode).
  • rowNumber (required) — Target row number (1-based, row 1 is header). Must be greater than 1.
  • autoSave — Whether to automatically save changes to the file (available in file path mode).

Output shape

a single record object

Returns a success object containing the operation type, the row number deleted, and a status message. In binary data mode, the node outputs the modified file.

Examples

Example 1: Delete a specific row in a file on the system

Set inputMode to 'File Path', specify the filePath, select the target sheet, enter the row number to delete (e.g., 5), and ensure autoSave is enabled.

Links

Discussion