Synology Office icon

Synology Office

Synology Office / Spreadsheet helper node

Actions8

Write Range / Cells

AI-generated

Summary

Overwrite a specified range of cells in a Synology Office spreadsheet with provided values.

Inputs

  • Spreadsheet File ID (required) — The identifier of the Synology Office spreadsheet file to modify.
  • Sheet ID (required) — The identifier of the sheet within the spreadsheet where the cells will be written.
  • Range (A1) (required) — The A1 notation of the cell range to overwrite, e.g., 'A1:C10'.
  • Values (2D JSON Array) (required) — A two-dimensional JSON array representing the cell values to write into the specified range.
  • Extra Params (JSON) — Optional additional parameters merged into the API call to accommodate different DSM parameter naming conventions.

Output shape

a single record representing the API response to the write operation

The output is the JSON response from Synology DSM's API call indicating success or failure of writing the specified range. This typically includes operation status and any error information if applicable.

Examples

Example 1: Write a 3x3 block of cells starting at A1 in a sheet.

Set 'Spreadsheet File ID' to the target file, 'Sheet ID' to the target sheet, 'Range (A1)' to 'A1:C3', and 'Values (2D JSON Array)' to the values to write in that range.

Links

Discussion