Synology Office icon

Synology Office

Synology Office / Spreadsheet helper node

Actions8

Read Range / Cells

AI-generated

Summary

Read a specific cell range from a Synology Office spreadsheet sheet.

Inputs

  • Spreadsheet File ID (required) — Specify the unique identifier of the spreadsheet file to read from.
  • Sheet ID (required) — Specify the unique identifier of the sheet within the spreadsheet file.
  • Range (A1) (required) — Define the cell range in A1 notation (e.g., 'A1:C10') to read values from.
  • Extra Params (JSON) — Optional JSON object to merge additional parameters into the underlying API call, for compatibility with customized DSM parameter names.

Output shape

a single record with JSON data containing the read cell values from the specified range

The returned data structure depends on the Synology Office API response to the range read request. The operation supports input per item and returns one output item per input.

Examples

Example 1: Reading a range of cells from a specific sheet in a spreadsheet file

Provide the Spreadsheet File ID and Sheet ID to identify the target sheet, enter the desired cell range in A1 notation (e.g., 'A1:C10'), and optionally specify extra parameters if needed.

Links

Discussion