skills.rest
YanHaidao
YanHaidaoCOMMUNITY
Explore all skills by this author →
GitHub

wecomcli-sheet

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

287|46|Updated Feb 5, 2026
Search Tags:#spreadsheet#wecom#csv import#wecom-cli#append rows#online sheet#subsheet
One-click install
npx skills add https://github.com/YanHaidao/wecom --skill wecomcli-sheet-yanhaidao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wecomcli-sheet
Source: https://github.com/YanHaidao/wecom/tree/main/skills/wecomcli-sheet
Command: npx skills add https://github.com/YanHaidao/wecom --skill wecomcli-sheet-yanhaidao

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Managing WeCom (Enterprise WeChat) online spreadsheets requires navigating multiple APIs for creation, import, reading, and editing. This Skill consolidates those operations into guided wecom-cli commands so you can manipulate online sheets without memorizing API details. ## Core Features & Use Cases - Create and Import Sheets: Build a new blank or pre-populated online spreadsheet, or import local CSV/XLS/XLSX files into WeCom online sheets. - Read and Write Data: Retrieve sheet metadata and sub-sheet data (structured grid data or CSV), update cell ranges, and append rows to the end of a worksheet. - Sub-sheet Management: Add or delete worksheets within an online spreadsheet. - Use Case: A user provides a link like https://doc.weixin.qq.com/sheet/xxx and asks to append a new sales record row; the Skill extracts the docid, fetches the sheet_id, and appends the row with matching cell formatting. ## Quick Start Ask the assistant to read the data from your WeCom online spreadsheet link, or to import a local Excel file as a new online sheet.

Frequently Asked Questions about wecomcli-sheet

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

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

Use the sheet import command with the file_name and absolute file_path of your .csv, .xls, or .xlsx file. It returns a docid, access URL, and task status once the import completes.

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

First call sheet get with the docid to obtain the sheet_id list, 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 sheets use URLs like doc.weixin.qq.com/sheet/xxx and are handled by this Skill. Smart sheets use /smartsheet/ URLs or docids starting with s3, 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 to retrieve the docid.

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

Yes, the sheet rows append command automatically writes to the row after the last existing row in the specified sub-sheet. Provide docid, sheet_id, and a row object with ordered cell values.

Related Skills

Explore More Product & Management Skills→
PinvouPinvou
2.0k

wecomcli-sheet

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

Official
Intermediate
wuyyyyyouwuyyyyyou

recipe-backup-sheet-as-csv

Export a Google Sheets spreadsheet to a CSV file for local backup.

Community
Intermediate
PinvouPinvou
2.0k

wecomcli-doc-manage

Search, rename, and manage member permissions for WeCom documents via wecom-cli.

Official
Intermediate
wukangcheng2944wukangcheng2944

wecomcli-doc

Manage WeChat Work documents and smart tables via command-line using wecom-cli doc.

Community
Advanced