ONLYOFFICE Docs icon

ONLYOFFICE Docs

Consume ONLYOFFICE Document Server API (Conversion, Document Builder)

Actions21

Document Builder → Update Row in Spreadsheet

AI-generated

Summary

Finds rows in the active worksheet of an XLSX file whose selected column matches a value, updates specified cells in those rows, and saves a generated XLSX file. The input URL must be reachable from the ONLYOFFICE Document Server.

Inputs

  • File URL (required) — URL of the XLSX file to update; it must be accessible to the Document Server.
  • Search Column (required) — Exact, case-sensitive column header to match. The implementation falls back to the first column if the header is not found.
  • Search Value (required) — Value to match in the search column. Every matching row is updated.
  • Updates (JSON) (required) — Object mapping exact column headers to new cell values. Only keys matching existing headers are applied; other keys are ignored.
  • Output Mode — Choose File Data (default), which downloads the generated file as binary data, or URL Only, which returns its Document Server URL without downloading.
  • Output File Name — Output filename without extension; the generated file uses the .xlsx extension.
  • Put Output File in Field — Binary property name for the generated file when Output Mode is File Data.

Output shape

A single n8n item containing JSON fields fileName, operation, and outputUrl, plus the generated XLSX in a binary field when Output Mode is File Data.

With URL Only, the item contains fileName, operation, and outputUrl without binary data. The script scans header cells from the first column until the first blank (up to 200 columns), then scans data rows from row 2 until the first blank in the first column (up to 100,000 rows). If no row matches, it still saves and returns the generated file.

Links

Discussion