XLSXInstall

Summary

Clear cell values in a chosen worksheet range or across its data rows, then return the updated workbook as an XLSX binary. Choose a sheet by name or leave it blank to use the first sheet; clearing a whole sheet preserves row 1 by default, while an explicit range is cleared exactly as specified.

Inputs

• Sheet Name — Worksheet to clear. Leave blank to use the first sheet.
• Range — A1-style range such as A2:C100. When set, clears every cell value in that range; Keep Header Row does not limit this range.
• Keep Header Row — Used when Range is blank. Defaults to true, clearing rows from row 2 onward; set false to also clear row 1. The operation nulls cell values and does not delete rows.
• Apply Styling — Defaults to false. When enabled, applies the configured simple or advanced styles after clearing; simple mode can also freeze row 1 or auto-fit columns.
• Style Mode and rules — With styling enabled, choose simple presets and per-target formatting rules, or provide advanced ExcelJS-compatible JSON rules.
• Options — Input Binary Field selects the existing XLSX binary (default data); if no input item has it, a new workbook is created. Output Binary Field names the result binary (default data), and Output File Name sets its filename (default spreadsheet.xlsx).

Output shape

A single item containing the updated XLSX file in the configured output binary field and JSON with success: true, merged with the first input item's JSON when present.

The node loads the first input item carrying the configured input binary field, if any. The operation returns a cleared cell count internally, but the emitted output does not include that count. An invalid A1 range raises an operation error.

Links

• n8n community nodes installation guide