Skip to content

Pinvou/pinvou-agent / pinvou3-app/src-tauri/resources/common/bundle/dingtalk-skills/dws

【何时用:仅当用户明确指向钉钉/DingTalk(钉钉文档、钉钉日程等)时使用;泛指做文档/表格/待办/审批默认走本地工具,不要误用钉钉】用 dws CLI 管理钉钉:AI表格/AI搜问(找人首选)/目标管理(Agoal)/组织大脑/日历/通讯录/群聊与机器人消息/待办/审批/智能合同/考勤/日志(日报周报)/DING消息/钉钉文档/云盘/Markdown文件/HTML文件/AI听记/邮箱/在线电子表格(axls)/知识库/白板/开放平台文档/个人IM与OA事件订阅。用户要求操作上述钉钉产品时使用。

FileKindSize
LICENSEother9.9 KB
NOTICEother666 B
SKILL.mdskill md38.4 KB
references/best_practices/01-messaging.mdmarkdown3.2 KB
references/best_practices/02-task.mdmarkdown2.8 KB
references/best_practices/03-meeting.mdmarkdown11.6 KB
references/best_practices/04-document.mdmarkdown11.0 KB
references/best_practices/05-reporting.mdmarkdown6.2 KB
references/best_practices/06-data-analytics.mdmarkdown5.4 KB
references/best_practices/07-minutes.mdmarkdown8.3 KB
references/best_practices/08-directory.mdmarkdown8.0 KB
references/best_practices/09-mail.mdmarkdown5.2 KB
references/best_practices/10-minutes-speaker-match.mdmarkdown9.0 KB
references/best_practices/11-minutes-speaker-correct.mdmarkdown4.4 KB
references/best_practices/_common/conventions.mdmarkdown3.4 KB
references/best_practices/_common/recipe-conventions.mdmarkdown1.8 KB
references/best_practices/lite-recipes.mdmarkdown15.7 KB
references/capability-limits.mdmarkdown2.9 KB
references/error-codes.mdmarkdown4.0 KB
references/field-rules.mdmarkdown5.4 KB
references/global-reference.mdmarkdown5.1 KB
references/intent-guide.mdmarkdown47.8 KB
references/products/agoal.mdmarkdown12.1 KB
references/products/aisearch.mdmarkdown14.1 KB
references/products/aitable-record-ops.mdmarkdown4.8 KB
references/products/aitable.mdmarkdown30.1 KB
references/products/aitable/aitable-advperm.mdmarkdown10.2 KB
references/products/aitable/aitable-api-key.mdmarkdown1.7 KB
references/products/aitable/aitable-attachment.mdmarkdown3.5 KB
references/products/aitable/aitable-best-practices.mdmarkdown3.5 KB
references/products/aitable/aitable-cell-value.mdmarkdown9.1 KB
references/products/aitable/aitable-comment.mdmarkdown2.8 KB
references/products/aitable/aitable-dashboard-chart.mdmarkdown4.5 KB
references/products/aitable/aitable-data-analysis-sop.mdmarkdown5.6 KB
references/products/aitable/aitable-error-recovery.mdmarkdown6.9 KB
references/products/aitable/aitable-export-import.mdmarkdown9.8 KB
references/products/aitable/aitable-field-properties.mdmarkdown8.5 KB
references/products/aitable/aitable-field.mdmarkdown6.6 KB
references/products/aitable/aitable-filter-sort.mdmarkdown12.4 KB
references/products/aitable/aitable-form.mdmarkdown15.1 KB
references/products/aitable/aitable-formula-guide.mdmarkdown8.2 KB
references/products/aitable/aitable-primary-doc.mdmarkdown2.3 KB
references/products/aitable/aitable-psql.mdmarkdown14.7 KB
references/products/aitable/aitable-record-create.mdmarkdown2.2 KB
references/products/aitable/aitable-record-delete.mdmarkdown582 B
references/products/aitable/aitable-record-history.mdmarkdown4.0 KB
references/products/aitable/aitable-record-name-key.mdmarkdown2.4 KB
references/products/aitable/aitable-record-query.mdmarkdown15.0 KB
references/products/aitable/aitable-record-share.mdmarkdown1.6 KB
references/products/aitable/aitable-record-stats.mdmarkdown3.8 KB
references/products/aitable/aitable-record-update.mdmarkdown3.2 KB
references/products/aitable/aitable-record-upsert.mdmarkdown3.3 KB
references/products/aitable/aitable-view-config.mdmarkdown11.8 KB
references/products/aitable/aitable-view-extras.mdmarkdown8.0 KB
references/products/aitable/aitable-workflow.mdmarkdown14.4 KB
references/products/attendance-report.mdmarkdown29.9 KB
references/products/attendance-schedule.mdmarkdown27.5 KB
references/products/attendance-vacation.mdmarkdown9.4 KB
references/products/attendance.mdmarkdown102.0 KB
references/products/calendar.mdmarkdown50.3 KB
references/products/chat-emoji-list.mdmarkdown8.4 KB
references/products/chat.mdmarkdown158.3 KB
references/products/chat/a2ui.mdmarkdown4.2 KB
references/products/contact.mdmarkdown30.5 KB
references/products/contract.mdmarkdown15.2 KB
references/products/dev.mdmarkdown14.7 KB
references/products/devdoc.mdmarkdown1.8 KB
references/products/ding.mdmarkdown9.9 KB
references/products/dingtalk-tag/capability.mdmarkdown5.7 KB
references/products/dingtalk-tag/dingtalk-tag-index.mdmarkdown3.9 KB
references/products/dingtalk-tag/manage-and-connect.mdmarkdown8.2 KB
references/products/dingtalk-tag/manage.mdmarkdown9.7 KB
references/products/dingtalk-tag/run.mdmarkdown5.4 KB
references/products/doc.mdmarkdown65.2 KB
references/products/doc/doc-block.mdmarkdown14.6 KB
references/products/doc/doc-comment.mdmarkdown9.9 KB
references/products/doc/doc-create.mdmarkdown6.6 KB
references/products/doc/doc-export.mdmarkdown3.5 KB
references/products/doc/doc-file-ops.mdmarkdown9.4 KB
references/products/doc/doc-import.mdmarkdown2.8 KB
references/products/doc/doc-info.mdmarkdown9.9 KB
references/products/doc/doc-list.mdmarkdown1.3 KB
references/products/doc/doc-media.mdmarkdown4.7 KB
references/products/doc/doc-permission.mdmarkdown4.9 KB
references/products/doc/doc-read.mdmarkdown8.5 KB
references/products/doc/doc-search.mdmarkdown1.4 KB
references/products/doc/doc-update.mdmarkdown15.5 KB
references/products/doc/doc-whiteboard.mdmarkdown3.9 KB
references/products/doc/format/doc-jsonml-cookbook.mdmarkdown25.0 KB
references/products/doc/format/doc-jsonml-schema.jsonconfig16.5 KB
references/products/doc/format/doc-jsonml-schema.mdmarkdown29.1 KB
references/products/doc/style/doc-create-workflow.mdmarkdown23.1 KB
references/products/doc/style/doc-style-guideline.mdmarkdown21.1 KB
references/products/doc/style/doc-update-workflow.mdmarkdown16.4 KB
references/products/drive.mdmarkdown65.4 KB
references/products/drive/drive-export.mdmarkdown2.6 KB
references/products/drive/drive-storage.mdmarkdown2.1 KB
references/products/drive/drive-task.mdmarkdown2.4 KB
references/products/event.mdmarkdown29.7 KB
references/products/hrbrain.mdmarkdown7.5 KB
references/products/html.mdmarkdown6.4 KB
references/products/mail.mdmarkdown88.1 KB
references/products/markdown.mdmarkdown11.4 KB
references/products/minutes.mdmarkdown173.8 KB
references/products/oa-template-write.mdmarkdown8.1 KB
references/products/oa.mdmarkdown61.7 KB
references/products/oa/oa-form-components.mdmarkdown33.7 KB
references/products/oa/oa-goout.mdmarkdown7.5 KB
references/products/oa/oa-leave.mdmarkdown7.2 KB
references/products/oa/oa-overtime.mdmarkdown10.1 KB
references/products/oa/oa-process-nodes.mdmarkdown11.6 KB
references/products/oa/oa-supply.mdmarkdown6.2 KB
references/products/oa/template/components/AddressField.mdmarkdown718 B
references/products/oa/template/components/CalculateField.mdmarkdown2.0 KB
references/products/oa/template/components/CascadeField.mdmarkdown1.1 KB
references/products/oa/template/components/ColumnLayout.mdmarkdown746 B
references/products/oa/template/components/DDAttachment.mdmarkdown586 B
references/products/oa/template/components/DDDateField.mdmarkdown857 B
references/products/oa/template/components/DDDateRangeField.mdmarkdown1.6 KB
references/products/oa/template/components/DDMultiSelectField.mdmarkdown1.3 KB
references/products/oa/template/components/DDPhotoField.mdmarkdown699 B
references/products/oa/template/components/DDSelectField.mdmarkdown1.2 KB
references/products/oa/template/components/DepartmentField.mdmarkdown789 B
references/products/oa/template/components/ExternalContactField.mdmarkdown751 B
references/products/oa/template/components/FormRelateField.mdmarkdown2.1 KB
references/products/oa/template/components/IdCardField.mdmarkdown709 B
references/products/oa/template/components/InnerContactField.mdmarkdown819 B
references/products/oa/template/components/InvoiceField.mdmarkdown1.1 KB
references/products/oa/template/components/MoneyField.mdmarkdown811 B
references/products/oa/template/components/NumberField.mdmarkdown807 B
references/products/oa/template/components/OcrIdCardField.mdmarkdown1.7 KB
references/products/oa/template/components/OcrTextField.mdmarkdown900 B
references/products/oa/template/components/PhoneField.mdmarkdown760 B
references/products/oa/template/components/RecipientAccountField.mdmarkdown746 B
references/products/oa/template/components/RelateField.mdmarkdown804 B
references/products/oa/template/components/SeqNumberField.mdmarkdown1.1 KB
references/products/oa/template/components/SignatureField.mdmarkdown722 B
references/products/oa/template/components/StarRatingField.mdmarkdown774 B
references/products/oa/template/components/TableField.mdmarkdown1.2 KB
references/products/oa/template/components/TextField.mdmarkdown775 B
references/products/oa/template/components/TextNote.mdmarkdown675 B
references/products/oa/template/components/TextareaField.mdmarkdown754 B
references/products/oa/template/components/TimeAndLocationField.mdmarkdown719 B
references/products/oa/template/example/form_components.jsonconfig7.3 KB
references/products/oa/template/example/process_config.jsonconfig22.7 KB
references/products/oa/template/form-components.mdmarkdown11.5 KB
references/products/oa/template/nodes/approver.mdmarkdown3.7 KB
references/products/oa/template/nodes/cc.mdmarkdown2.6 KB
references/products/oa/template/nodes/condition.mdmarkdown10.8 KB
references/products/oa/template/nodes/handler.mdmarkdown2.4 KB
references/products/oa/template/nodes/originator.mdmarkdown941 B
references/products/oa/template/nodes/parallel.mdmarkdown2.7 KB
references/products/oa/template/nodes/payer.mdmarkdown1.6 KB
references/products/oa/template/process-nodes.mdmarkdown8.8 KB
references/products/oa/template/rules/target_approval.mdmarkdown3.3 KB
references/products/oa/template/rules/target_connect_approval.mdmarkdown3.2 KB
references/products/oa/template/rules/target_formcomponent_approval.mdmarkdown1.2 KB
references/products/oa/template/rules/target_formula_managerOfDept.mdmarkdown1.5 KB
references/products/oa/template/rules/target_formula_reportLineManager.mdmarkdown1.5 KB
references/products/oa/template/rules/target_label.mdmarkdown3.9 KB
references/products/oa/template/rules/target_management.mdmarkdown1.3 KB
references/products/oa/template/rules/target_managers_labels.mdmarkdown1.3 KB
references/products/oa/template/rules/target_matrix_approval.mdmarkdown2.4 KB
references/products/oa/template/rules/target_originator.mdmarkdown698 B
references/products/oa/template/rules/target_select.mdmarkdown1.6 KB
references/products/openapi-explorer.mdmarkdown3.9 KB
references/products/pat.mdmarkdown1.8 KB
references/products/report.mdmarkdown29.9 KB
references/products/sheet.mdmarkdown16.2 KB
references/products/sheet/sheet-batch-operations.mdmarkdown7.7 KB
references/products/sheet/sheet-chart.mdmarkdown3.9 KB
references/products/sheet/sheet-comment.mdmarkdown7.9 KB
references/products/sheet/sheet-conditional-format.mdmarkdown4.5 KB
references/products/sheet/sheet-dimension-operations.mdmarkdown3.7 KB
references/products/sheet/sheet-dropdown.mdmarkdown6.7 KB
references/products/sheet/sheet-export.mdmarkdown8.6 KB
references/products/sheet/sheet-filter-view.mdmarkdown3.7 KB
references/products/sheet/sheet-filter.mdmarkdown10.0 KB
references/products/sheet/sheet-formula.mdmarkdown10.0 KB
references/products/sheet/sheet-import.mdmarkdown2.6 KB
references/products/sheet/sheet-media-image.mdmarkdown13.9 KB
references/products/sheet/sheet-pivot-table.mdmarkdown12.6 KB
references/products/sheet/sheet-range-operations.mdmarkdown8.7 KB
references/products/sheet/sheet-read-data.mdmarkdown4.0 KB
references/products/sheet/sheet-revision-changeset.mdmarkdown3.2 KB
references/products/sheet/sheet-search-replace.mdmarkdown6.3 KB
references/products/sheet/sheet-style-format.mdmarkdown4.5 KB
references/products/sheet/sheet-version.mdmarkdown5.0 KB
references/products/sheet/sheet-workbook.mdmarkdown4.3 KB
references/products/sheet/sheet-write-data.mdmarkdown7.8 KB
references/products/simple.mdmarkdown2.6 KB
references/products/todo.mdmarkdown21.0 KB
references/products/whiteboard.mdmarkdown19.7 KB
references/products/whiteboard/compose.mdmarkdown5.7 KB
references/products/whiteboard/diff.mdmarkdown3.7 KB
references/products/whiteboard/open-nodes-v1.mdmarkdown4.0 KB
references/products/whiteboard/open-nodes-v1/01-overview.mdmarkdown3.3 KB
references/products/whiteboard/open-nodes-v1/02-query.mdmarkdown7.3 KB
references/products/whiteboard/open-nodes-v1/03-update.mdmarkdown8.6 KB
references/products/whiteboard/open-nodes-v1/04-text-style.mdmarkdown11.8 KB

references/products/sheet/sheet-batch-operations.md

View on GitHub
# Sheet 批量原子操作

## 使用边界

`batch-update` 用于把多个已经确认参数、需要同一事务语义的 Sheet 写操作组合成一次请求;`range batch-clear` 用于跨工作表批量清空。不要把一次独立写强行拆成 batch,也不要为了减少调用把不相关风险混在同一个事务里。

默认不传 `--continue-on-error`:任一子操作失败时,已执行操作全部回滚。只有用户明确接受部分成功时才启用宽松模式,并逐项报告成功、失败和实际返回。

## 支持的 `toolName`

`toolName` 必须逐字使用下列 CLI 命令名:

- 值与区域:`range clear`、`range update`、`range fill`、`range copy-to`、`range move-to`、`range sort`、`range set-style`、`csv-put`、`replace`、`merge-cells`、`unmerge-cells`。
- 行列与分组:`add-dimension`、`insert-dimension`、`delete-dimension`、`move-dimension`、`update-dimension`、`group-dimension`、`ungroup-dimension`。
- 下拉:`set-dropdown`、`delete-dropdown`。
- 工作表:`new`、`delete-sheet`、`update`、`show-gridline`、`hide-gridline`。
- 对象删除:`chart delete`、`pivot-table delete`。
- 条件格式:`cond-format create`、`cond-format update`、`cond-format delete`。
- 筛选:`filter create`、`filter update`、`filter delete`。
- 个人筛选视图:`filter-view create`、`filter-view update`、`filter-view delete`。
- 浮动图片:`create-float-image`、`update-float-image`、`delete-float-image`。

以下能力不进入 `batch-update`:`range read`、`csv-get`、`table-get`、`table-put`、`write-image`、`media-upload`、`range batch-set-style`、`find`、`copy`、`chart create/update`、`pivot-table create/update`、`export`、`sheet list/info`、嵌套 batch,以及需要立即折叠的 `group-dimension`。结构化 table 用独立 `table-put`;批量样式入口用独立 `range batch-set-style`;本地图片先执行 `media-upload`。

## 批量清空

```bash
dws sheet range batch-clear \
  --node <NODE_ID> \
  --ranges '["Sheet1!A1:B3","Sheet2!C1:D5"]' \
  --type content --format json
```

每个范围必须带工作表前缀。`type` 为 `content`、`format` 或 `all`;`all` 会同时删除值和格式。执行前确认精确目标;默认原子,任一区域失败时整批回滚。

## `batch-update` 请求结构

```bash
dws sheet batch-update --node <NODE_ID> --operations '[
  {"toolName":"range clear","input":{"sheet-id":"Sheet1","range":"A1:B3","type":"content"}},
  {"toolName":"range update","input":{"sheet-id":"Sheet1","range":"A1","values":[[{"type":"text","text":"hello"}]]}},
  {"toolName":"merge-cells","input":{"sheet-id":"Sheet1","range":"A1:B1","merge-type":"mergeAll"}},
  {"toolName":"csv-put","input":{"sheet-id":"Sheet1","start-cell":"E1","csv":"001,2026/8/1,=1+1,'=1+1","auto-convert":false}}
]' --format json
```

每项必须是 `{"toolName":"...","input":{...}}`:

- `input` 的键使用对应 CLI flag 名去掉 `--`,例如 `sheet-id`、`start-index`、`merge-type`。
- `node` 只在批次顶层传一次,禁止放入子操作。
- 子操作按数组顺序执行,单批最多 20 条。
- 所有 `sheet-id`、范围、对象 ID 都必须来自当前任务的真实返回;不能猜 `Sheet1`、`0` 或历史 ID。
- 不确定字段时只读取对应 standalone leaf 的 compact Schema,不要批量读取全部 Help。

用户侧始终传 `--operations`,不新增 `--operations-json`。CLI 在本地解析、严格校验和翻译后,只把最终 MCP 操作数组编码到远端 `operationsJson` string,避免平台把 JSON 中的 number/boolean 改成字符串。`--dry-run` 的 `arguments.operationsJson` 会显示为带转义的 JSON 字符串,这就是实际请求形态;CLI 不同时发送旧 `operations`,写失败后也不会换入口自动重试。

新增操作会在发请求前拒绝未知字段和错误 JSON 类型:整数、布尔值不能写成字符串。`operations[N]` 中的 `N` 是 0-based 的错误/结果索引,仅用于对应 `--operations` 数组项,不是 Sheet 的行列坐标。

## 关键参数语义

- `csv-put` 子操作用 `"auto-convert":false` 关闭非公式字段自动转换,向 MCP 透传为 `autoConvert:false`。首字符为 `=` 的字段仍按公式解析;`'=...` 是普通文本并保留前置单引号。缺省或 `true` 保持现有自动类型转换行为。
- `delete-dimension` / `move-dimension` 与独立命令一致:`ROWS` 使用 1-based 行号,`COLUMNS` 使用列字母;DWS 负责转换成 batch API 的 0-based 索引,调用方不要提前减 1。其他子操作也应沿用对应 standalone 命令的公开坐标契约。
- `set-dropdown` 的 Inline 模式使用 `options`;SourceRange 模式使用 `source-sheet-id` 与 `source-range`,两种模式必须且只能选一个。Inline 颜色写在 `options[].color`;顶层 `colors` / `source-colors` 和 SourceRange 颜色不支持。
- `source-range` 按 `toolName` 解释:在 `set-dropdown` 中是候选项来源,在 `range fill` / `range copy-to` / `range move-to` 中是数据源区域。
- `create-float-image` / `update-float-image` 在 batch 中只接受 `src` URL,不接受 `file`;本地文件必须先上传。
- `group-dimension` 在 batch 中只适合默认展开分组;需要 `group-state=fold` 时调用独立命令。

## 返回值与批内依赖

batch 不支持 `$ref`,后序子操作不能引用前序 create 的返回。`new`、`cond-format create`、`filter create`、`filter-view create`、`create-float-image` 等创建类操作成功时,对应 `results[].data` 会保留服务端返回(包括可用的 ID);调用方只能在下一次请求中使用这些 ID。

`update` 改名或 `delete-sheet` 删除工作表后,后序子操作若仍按旧名称定位会失败:严格模式整批回滚,宽松模式保留此前已成功操作。跨操作关联优先使用稳定的 `sheet-id`;同一静态批次内不能依赖前序新建对象的 ID。

## 严格与宽松模式

| 模式 | flag | 子操作失败时 | 结果判断 |
|---|---|---|---|
| 严格事务(默认) | 不传 | 整批回滚,后续不再执行 | 顶层错误包含失败的 `operations[N]` |
| 宽松模式 | `--continue-on-error` | 保留已执行操作并继续 | 逐项检查 `results[].success`、`errorCode`、`errorMsg` 和 `data` |

顶层请求成功不代表宽松模式下每个子操作都成功。必须按原输入索引解析全部结果,不能让成功项掩盖失败项。

## 预检与安全

发送前检查:

- 操作数与数组长度一致且不超过 20;
- 工作表、范围和对象 ID 真实,范围没有意外重叠;
- 操作顺序满足依赖,删除、清空、移动和覆盖的影响已确认;
- 不包含 unsupported toolName、嵌套 batch、`$ref` 或子操作 `node`;
- 非幂等 create/insert/move 没有在状态未知时被重放。

超时或返回状态不确定时先回读目标。原子模式先判断整批是否落地;宽松模式只为已证明缺失且可安全重试的项构造新批次。不要盲目重发整个批次。

## 写后验证

合并相同类型的验证,避免逐操作全表读取:

- 值和公式:回读覆盖受影响值的最小范围;公式先读文本,再按需执行 `formula-verify`。
- 样式、合并、网格线、行列和分组:使用 `sheet info` 或对应结构读取;分组加 `--include groups`。
- dropdown、条件格式、筛选、筛选视图、图表、透视表、浮动图片:调用对应 `list/get`。
- 创建类:除了检查 `results[].data`,还要用对象读取确认持久化状态。

预期条数、结果条数或关键状态不一致即失败。只读验证可做有界退避,不得通过重复写“碰碰运气”。最终说明使用的是原子还是部分模式、成功项、失败项及已验证范围。
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall