Unitalk Microsoft Excel 365Install

Summary

Update rows in a Microsoft Excel worksheet by specifying a range and providing new data values in different mapping modes.

Inputs

• Workbook (required) — Select the workbook to update sheets in, either from list or by ID.
• Sheet (required) — Select the worksheet (sheet) to update, either from list or by ID.
• Select a Range — Optionally choose to specify a sheet cell range to update.
• Range — The A1-style cell range in the sheet to update. First row of the range must contain column headers for mapping modes; leave blank to use the whole used range in the sheet.
• Data Mode (required) — Specify how the input data maps to the sheet columns: autoMap (input keys must match columns), define (manually define values per column), or raw (provide raw JSON array of arrays for the range).
• Data (for Raw Mode) (required) — Raw JSON array of arrays containing values to update, matching the specified range.
• Column to match on (for autoMap and define modes) (required) — Column used to find rows to update; this column's value is matched but not changed.
• Value of Column to Match On (define mode) (required) — Value in the match column to identify the row to update.
• Values to Send (define mode) (required) — Specify column-value pairs to update in the matching row.
• Options — Additional options including whether to return raw data, the data property name, fields to include in response, and whether to update all matching rows or only the first.

Output shape

a list of updated row objects or raw data according to options

Returns updated rows filtered by matching criteria. Supports pagination implicitly based on API. If rawData option enabled, returns data under the specified data property instead of mapped objects. Errors for missing ranges or incorrect data mappings are thrown; multiple matches can be updated if configured.

Links

• n8n community nodes installation guide