ONLYOFFICE Docs icon

ONLYOFFICE Docs

Consume ONLYOFFICE Document Server API (Conversion, Document Builder)

Actions21

Document Builder → Generate Spreadsheet

AI-generated

Summary

Creates a new XLSX spreadsheet from an array of row objects, using the first object’s keys as bold column headers. Optionally names the worksheet tab and returns the file as binary data or as a Document Server URL.

Inputs

  • Table Data (JSON Array) (required) — Array of row objects; object keys from the first row define the column headers, and each row’s matching values are written beneath them. Use an expression such as {{ $json.records }} to pass records from Extract Tables.
  • Table Title — Optional worksheet tab name.
  • Output Mode — Choose File Data (default) to download the XLSX into the configured binary field, or URL Only to return the Document Server URL without downloading.
  • Output File Name — Base name for the output file; the node adds the .xlsx extension. Hidden when Output Mode is URL Only.
  • Put Output File in Field — Binary field name for the downloaded XLSX; defaults to data. Hidden when Output Mode is URL Only.

Output shape

One item per input item, with spreadsheet details in JSON and, in File Data mode, the XLSX in a binary field.

The JSON contains fileName, operation (generateSpreadsheet), and outputUrl. URL Only returns these JSON fields without binary data. An empty data array still creates an XLSX, but the source does not write headers or cell values.

Links

Discussion