ONLYOFFICE Docs icon

ONLYOFFICE Docs

Consume ONLYOFFICE Document Server API (Conversion, Document Builder)

Actions21

Document Builder → Append Rows to Spreadsheet

AI-generated

Summary

Append rows from a JSON array to the active worksheet in an existing XLSX file, then save the result as XLSX. The Document Server must be able to reach the required File URL; pass row objects whose keys match the spreadsheet’s column headers.

Inputs

  • File URL (required) — URL of the input XLSX file, reachable from the ONLYOFFICE Document Server. Can use {{ $json.outputUrl }} from a previous Document Builder step.
  • Table Data (JSON Array) (required) — Array of row objects. Values are written under matching headers from the first row of the active worksheet; missing or null values become empty cells. If the worksheet has no headers, object values are written in each row’s key iteration order.
  • Output Mode — Choose File Data (default) to download the resulting XLSX as binary, or URL Only to return its Document Server URL without downloading.
  • Output File Name — Output filename without extension; used for the binary file and defaults to output. The saved file has an .xlsx extension.
  • Put Output File in Field — Binary output field name; defaults to data. Applies when Output Mode is File Data.

Output shape

One output item per input item, containing JSON fields fileName, operation, and outputUrl; File Data mode also includes the XLSX in the configured binary field.

URL Only mode returns the JSON fields without binary data. Rows are added to the active worksheet in the input workbook, and the operation saves an XLSX output.

Links

Discussion