Dingtalk Node icon

Dingtalk Node

Interact with the Dingtalk API

表格 → 获取单元格区域

AI-generated

Summary

Retrieve the values or specific fields of a specified cell range from a workbook sheet in DingTalk AI Spreadsheet.

Inputs

  • overrideOperator — Boolean to indicate whether to override the credential's operator with a manually specified operator unionId.
  • operatorId (required) — The unionId of the operator performing the action; required if overrideOperator is true.
  • workbookId (required) — The ID of the target workbook file, obtainable via DingTalk knowledge base APIs or by resource locators (ID or URL).
  • sheetId (required) — The ID or name of the target worksheet within the workbook. Can be selected from a list or specified by ID.
  • rangeAddress (required) — The address of the cell range to retrieve, specified in Excel-like notation (e.g., A3:C3).
  • select — Comma-separated list of specific fields to return for the range. Defaults to 'values'. Other fields like formulas can be requested.

Output shape

a single object containing the requested fields of the specified cell range, typically including cell values and optionally other fields such as formulas

The response is filtered by the 'select' parameter. If no fields are specified, all available fields are returned. Only one range can be retrieved per call.

Links

Discussion