skills.rest
Pinvou
PinvouOFFICIAL
Explore all skills by this author →
GitHub

wecomcli-sheet

Create, import, read, and edit WeCom online spreadsheets via the wecom-cli command line.

2.0k|291|Updated Jul 24, 2026
Search Tags:#spreadsheet#wecom#csv import#wecom-cli#enterprise wechat#online sheet#cell update
One-click install
npx skills add https://github.com/Pinvou/pinvou-agent --skill wecomcli-sheet-pinvou
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wecomcli-sheet
Source: https://github.com/Pinvou/pinvou-agent/tree/main/pinvou3-app/src-tauri/resources/common/bundle/wecom-skills/wecomcli-sheet
Command: npx skills add https://github.com/Pinvou/pinvou-agent --skill wecomcli-sheet-pinvou

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires wecom-cli, and includes references (resource) components.

What problem does it solve? Managing WeCom (Enterprise WeChat) online spreadsheets normally requires manual work in the web UI. This Skill lets an AI agent create, import, read, update, and append data to online spreadsheets at doc.weixin.qq.com directly through the wecom-cli command line, turning spreadsheet operations into automated conversations. ## Core Features & Use Cases - Create and Import Spreadsheets: Create blank or pre-filled online spreadsheets, or import local CSV/XLS/XLSX files as WeCom online sheets. - Read and Write Cell Data: Read sheet metadata and range data (structured grid or CSV), update cell regions with text, numbers, formulas, and links, and append rows to the end of a worksheet. - Worksheet Management: Add or delete sub-worksheets within an online spreadsheet, with mandatory user confirmation before destructive operations. - Use Case: A user provides a doc.weixin.qq.com/sheet/ link and asks to append this week's sales figures; the agent resolves the docid, fetches the sheet_id, and appends a properly typed row. ## Quick Start Ask the agent to read the data from your WeCom online spreadsheet link and append a new row with the values you provide.

Frequently Asked Questions about wecomcli-sheet

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I import a CSV or Excel file into a WeCom online spreadsheet?▼

Use the wecom-cli sheet import command with file_name and the local absolute file_path of your .csv, .xls, or .xlsx file. It returns the new spreadsheet's docid, access URL, and a task status such as succ.

How do I read data from a WeCom online spreadsheet?▼

First call wecom-cli sheet get with the docid to list worksheets and obtain the sheet_id, then call sheet ranges get with the docid, sheet_id, and a range like A1:A100. Use mode csv only when you need the data for statistics or aggregation.

What is the difference between WeCom online sheets and smart sheets?▼

Online spreadsheets use doc.weixin.qq.com/sheet/ links and are handled by this Skill, while smartsheet links or docids starting with s3 belong to the smart sheet product and must be handled by the wecomcli-smartsheet skill instead.

How do I get the docid for a WeCom spreadsheet?▼

Extract it from the document URL by taking the segment after /sheet/ and before the query string. If you only have a document name, search via the wecomcli-doc-manage skill and take the docid from its results.

Can I append a row to a WeCom spreadsheet without specifying a row number?▼

Yes, the sheet rows append command automatically writes to the row after the last existing row of the specified worksheet. Provide docid, sheet_id, and a row object whose values array contains typed cell_value entries.

Why must I confirm before deleting a worksheet or overwriting cells?▼

Subsheet deletion and content overwrites are destructive operations, so the Skill requires the agent to restate the affected scope and obtain explicit user confirmation before executing them.

Related Skills

Explore More Product & Management Skills→
DaTingLiDaTingLi

wecom-doc

Create and edit WeCom documents and smart sheets via MCP servers.

Community
Advanced
fengtcfengtc

wecom-doc

Automate enterprise WeChat document and smart spreadsheet management via mcporter APIs.

Community
Intermediate
gula00gula00
2

feishu-perm

List, add, and remove collaborators on Feishu documents and files.

Community
Intermediate
LiangdiLiangdi
3

wecomcli-manage-smartsheet-schema

Manage sheets and field columns in WeCom smartsheet documents via CLI.

Community
Intermediate