XLSX icon

XLSX

Manipulate workbooks

Actions9

Append or Update (Upsert)

AI-generated

Summary

Upsert incoming rows in an XLSX worksheet: update rows whose key-column value matches, and append rows with no match. The operation returns the updated workbook as binary data.

Inputs

  • Sheet Name — Worksheet to edit; leave empty to use the first sheet. If it does not exist and Create Sheet if Missing is enabled, it is created.
  • Create Sheet if Missing — Create the target sheet when it is missing; 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.
  • Columns — Used in Define Columns Below mode. Each pair supplies a column name and value.
  • Fields to Exclude — Used in auto-map mode. Comma-separated keys to omit from the rows written.
  • Include Header Row — Defaults to true. When false, the operation removes worksheet row 1 before saving, after using headers to map fields to columns.
  • Key Column to Match On (required) — Column name used to find an existing row; defaults to id. Incoming items without this key are appended.
  • Apply Styling — Optionally apply styling after the upsert. Simple mode supports presets, cell/row/column/range targets, formatting, freeze header, and auto-fit; advanced mode accepts exceljs-compatible JSON rules.
  • Options — Input Binary Field selects the incoming XLSX binary to load (default data); if none of the input items has it, a new workbook is created. Output Binary Field names the returned XLSX binary (default data), and Output File Name sets its attached filename (default spreadsheet.xlsx).

Output shape

A single item containing the resulting XLSX workbook in binary data and JSON with success: true.

The output binary is attached under the configured Output Binary Field. Upsert updates matching rows and appends unmatched rows; matching compares values directly or by their string forms. Missing fields in an update leave existing cells unchanged. Objects written as cell values are JSON-stringified. If Include Header Row is false, row 1 is removed before the workbook is returned.

Links

Discussion