XLSXInstall

Summary

Update rows in an XLSX worksheet by matching each incoming row against an existing row using a key column. Matching rows receive the supplied field values, and the resulting workbook is returned as an XLSX binary file.

Inputs

• Sheet Name — Worksheet to update. Leave empty to use the workbook’s first sheet; if no matching sheet exists, the default Create Sheet if Missing setting creates it.
• Create Sheet if Missing — Create the selected sheet when it does not exist; defaults to true.
• Data to Send — Choose Auto-Map Input Data to use each input item’s JSON as a row, or Define Columns Below to supply column/value pairs for each item.
• Fields to Exclude — In auto-map mode, comma-separated field names to omit from incoming rows.
• Columns — In Define Columns Below mode, specify column names and their values.
• Include Header Row — Defaults to true. When disabled, the operation removes row 1 from the worksheet immediately before writing the output file.
• Key Column to Match On (required) — Column used to find existing rows; defaults to id. Incoming rows without this field or with no matching value are not updated.
• Apply Styling — Optionally apply simple preset or cell styling rules, or advanced ExcelJS-compatible rules, after processing.
• Style Mode — Select simple styling controls or advanced JSON rules when styling is enabled.
• Freeze Header Row — In simple styling mode, freeze the first row while scrolling.
• Auto-Fit Columns — In simple styling mode, estimate column widths from cell contents.
• Style Rules — In simple styling mode, choose presets and target rows, columns, ranges, or the sheet, and configure formatting.
• Style Rules (JSON) — In advanced styling mode, provide an array of rules with a range and supported style, merge, conditions, or colorScale settings.
• Input Binary Field — Name of the binary field containing the existing XLSX workbook. Defaults to data; if no input item has this field, a new workbook is created.
• Output Binary Field — Binary field for the resulting XLSX file; defaults to data.
• Output File Name — Filename attached to the output workbook; defaults to spreadsheet.xlsx.

Output shape

A single item containing a success flag and the resulting XLSX workbook in a binary field.

For each incoming row, the node finds the first existing row whose key-column value matches (values are compared directly or as strings) and overwrites only the supplied fields. Rows without a key or without a match are skipped; this operation does not append them. The binary output field and filename are configurable. If Include Header Row is false, row 1 is removed before serialization.

Links

• n8n community nodes installation guide