XLSX icon

XLSX

Manipulate workbooks

Actions9

Delete Rows

AI-generated

Summary

Deletes a contiguous range of rows from the selected worksheet and shifts the rows below upward. Set the 1-based Start Row and Number of Rows; the defaults delete one row starting at row 2, preserving the header row.

Inputs

  • Sheet Name — Worksheet to modify. Leave empty to use the first sheet.
  • Start Row — 1-based row number to begin deleting at; defaults to 2.
  • Number of Rows — How many consecutive rows to delete; defaults to 1.
  • Options — Input Binary Field selects the existing XLSX file (default data); if no input item has that binary field, a new workbook is created. Output Binary Field (default data) and Output File Name (default spreadsheet.xlsx) configure the resulting file.

Output shape

A single item containing JSON and the resulting XLSX binary file.

The JSON contains success: true and copies JSON from the first input item when present. The workbook is serialized to the configured output binary field. Deletion uses ExcelJS row splicing; an empty sheet name selects the first worksheet, and a missing selected sheet causes an error.

Links

Discussion