Actions56
- 自定义 API 请求 Actions
- 应用授权 Actions
- 文档 Actions
- AI表格 Actions
- 机器人 Actions
- 待办任务 Actions
- 用户管理 Actions
- 表格 Actions
- OA审批 Actions
表格 → 获取单元格区域
AI-generatedSummary
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.