wecomcli-sheet

Original：🇨🇳 Chinese

Translated

WeCom Online Sheet Management Skill. Provides functions such as creating online sheets, reading content, modifying content, appending row data, and managing sub-sheets (adding/removing). Applicable scenarios: (1) Create a blank online sheet (2) Read the complete content of the sheet (Markdown) (3) Read basic information and sub-sheet list (4) Read sub-sheet data (5) Modify content in specified range (6) Append a row of data at the end (7) Add/delete sub-sheets. This skill is triggered when the user mentions 'WeCom Sheet', 'WeCom Online Sheet', 'WeCom Excel Sheet', or when the link is in the format `https://doc.weixin.qq.com/sheet/xxx`. Note: For smart sheets (`/smartsheet/*`), use `wecomcli-smartsheet`; for ordinary documents (`/doc/*`), use `wecomcli-doc`; for smart documents/smart homepage (`/smartpage/*`), use `wecomcli-smartpage`.

15installs

Sourcewecomteam/wecom-cli

Added on2026-07-02

NPX Install

npx skill4agent add wecomteam/wecom-cli wecomcli-sheet

SKILL.md Content (Chinese)

View Translation Comparison →

WeCom Online Sheet Management

wecom-cli
is a command-line program provided by WeCom, all operations are completed by executing
wecom-cli
commands.

This is a resource-based skill responsible for creating, reading/writing content, and managing sub-sheets of Online Sheets (

/sheet/*

).

Calling Method

Call via

wecom-cli

, category is

doc

:

bash

wecom-cli doc <tool_name> '<json_params>'

Interface Routing Table

Hard Rule: If the second column is a link to
references/xxx.md
, after hitting this row, first
read
the corresponding references file, then construct the command. Before writing/reading sub-sheet data, use
sheet_get_info
to get the
sheet_id
of the target sub-sheet first.

User Intent	Reference Location
Read complete content of Online Sheet (Markdown overview)	See "Read Complete Content" below
Read basic information and sub-sheet list of Online Sheet	See "Read Basic Information" below
Create an Online Sheet from scratch (blank)	See "Create Online Sheet" below
Modify content in specified range of Online Sheet	references/sheet-update-range-data.md
Append a row of data at the end of Online Sheet	references/sheet-append-data.md
Add sub-sheet to Online Sheet	references/sheet-add-sub.md
Delete sub-sheet from Online Sheet	references/sheet-delete-sub.md

Interface Details

Create Online Sheet

Create a blank WeCom Online Sheet from scratch. Returns

docid

and

url

after successful creation.

Command

bash

wecom-cli doc create_doc '<JSON parameters>'

Parameters

Parameter	Type	Required	Default Value	Description
`doc_type`	int	Yes	—	Fixed value `4` (Online Sheet)
`doc_name`	string	Yes	—	Sheet title

Notes

This interface only creates blank online sheets, and does not support carrying initial content; if you need to write data, after creation, first use
```
sheet_get_info
```
to get the sub-sheet
```
sheet_id
```
, then write via
```
sheet_update_range_data
```
/
```
sheet_append_data
```
.

Read Complete Content

Obtain the complete content data of the Online Sheet, returned uniformly in Markdown format. Uses asynchronous polling mechanism: No need to pass

task_id

for the first call, the interface returns

task_id

; if

task_done

is

false

, carry this

task_id

to call again until

task_done

is

true

, then the complete content is returned. Suitable for quick overview or reading the entire sheet content.

Command

bash

wecom-cli doc get_doc_content '<JSON parameters>'

Parameters

Field	Type	Required	Default Value	Semantics
`docid`	string	Either `docid` or `url` is required	—	docid of the Online Sheet
`url`	string	Either `docid` or `url` is required	—	Access link of the Online Sheet
`type`	int	Yes	—	Content return format, fixed value `2` (Markdown)
`task_id`	string	No	—	Task ID, not passed for the first call, fill in the `task_id` returned last time during polling

Return

Field	Type	Description
`content`	string	Complete Markdown content returned when `task_done` is `true`
`task_id`	string	Task ID, used for next polling when not completed
`task_done`	bool	Whether the task is completed; when `false` , carry `task_id` to continue polling

Usage Rules

Do not pass
```
task_id
```
for the first call; if
```
task_done
```
is
```
false
```
, record the
```
task_id
```
and carry it to call again until
```
task_done
```
is
```
true
```
to retrieve
```
content
```
.

Read Basic Information

Read the basic information of the Online Sheet, including the list of worksheets, document name and access link. The

sheet_id

of all subsequent interfaces that require

sheet_id

(such as

sheet_update_range_data

/

sheet_append_data

/

sheet_delete_sub

) is obtained from the

sheets[]

returned by this interface.

Command

bash

wecom-cli doc sheet_get_info '<JSON parameters>'

Parameters

Field	Type	Required	Default Value	Semantics
`docid`	string	Either `docid` or `url` is required	—	docid of the Online Sheet
`url`	string	Either `docid` or `url` is required	—	Access link of the Online Sheet

Return

Field	Type	Description
`sheets`	array	List of worksheets; each item contains basic information such as `sheet_id` / `title` / `row_count` / `column_count` / `data_range`
`url`	string	Document access link
`name`	string	Document name

Usage Rules

Either
```
docid
```
or
```
url
```
is required, at least one must be passed.
Read → Write Link: When you need to write content to a specific sub-sheet (
```
sheet_update_range_data
```
/
```
sheet_append_data
```
), you should first use
```
get_doc_content
```
to read and identify the title and specific data of each sub-sheet, then call this interface to get the
```
sheet_id
```
and row/column counts (
```
row_count
```
/
```
column_count
```
) of each sub-sheet in
```
sheets[]
```
; determine the target
```
sheet_id
```
by matching the sub-sheet title with
title
, and check the write area range combined with the row/column counts, thus opening up the complete "Read → Write" link.

Cross-Skill Dependencies

Dependent Skill	Typical Collaboration Scenario	Data Flow
`wecomcli-contact`	When personnel information needs to be written into the sheet, query userid by name	`get_userlist` retrieves userid → this skill writes
`wecomcli-msg`	When the user requests to send the Online Sheet link to someone/some group	This skill returns `url` after creation → `wecomcli-msg` sends the link

wecomcli-sheet

NPX Install

Tags

SKILL.md Content (Chinese)

WeCom Online Sheet Management

Calling Method

Interface Routing Table

Interface Details

Create Online Sheet

Read Complete Content

Read Basic Information

Cross-Skill Dependencies