wecomcli-sheet Skill for Claude: Edit WeCom Online Sheets and Excel Files
Lets Claude create, read and edit WeCom (企业微信) online spreadsheets, and analyze or edit local Excel and CSV files.
- Installs
- 11.9K
- on skills.sh
- Stars
- 3.3K
- on GitHub
- Files
- 19
- besides SKILL.md
- Updated
- Oct 2026
- last repo commit
wecomcli-sheet makes Claude work on WeCom online spreadsheets through the wecom-cli command. It can create or import a sheet, read and write cells, manage sub-sheets, rows, columns and ranges, set styles and number formats, search and replace, and manage data validation, conditional formatting, filters, protected ranges, floating images and version history. For local .xlsx, .xlsm, .xls, .csv and .tsv files it reads, analyzes and edits them with Python.
It needs the wecom-cli command and the wecomcli-shared skill, which SKILL.md says must be read and its checks completed before any wecom-cli command. Those checks install or update the CLI and ask you to scan a QR code with WeCom the first time. SKILL.md says it does not support online charts, and it refuses to export an online sheet to a local file. SKILL.md is written in Chinese.
Good for
- WeCom users who keep data in online spreadsheets and want Claude to read or update them
- Teams who need Claude to analyze, format or fix local .xlsx, .csv and .tsv files
- Admins who want formatting, validation, filters and sheet protection set up from a prompt
Install wecomcli-sheet
Claude Code
- 1
Copy this prompt.
Install the wecomcli-sheet skill in Claude Code. Run this command: npm install -g @wecom/cli Then check that it loaded and tell me how to use it.
- 2
Paste it into Claude Code. It shows the change and asks before running it.
Requires Node.js 18+.
Run the first three in order. The README marks the skill install as required, and installs all 15 skills for every agent with -y -g. The last command installs only this skill and wecomcli-shared; add wecomcli-doc-manage if you want Claude to find a sheet by name, since SKILL.md hands document search to it. wecom-cli auth init shows a link and a QR code to scan with WeCom.
From the project README. Source.
What's in the skill
When it loads
企业微信在线表格与本地表格文件处理技能。用于创建或导入在线表格,读写单元格,管理子表、区域、行列、样式、搜索替换、数据验证、条件格式、筛选器和版本历史,以及读取、分析、编辑 .xlsx/.xlsm/.xls/.csv/.tsv 文件。当用户提到“在线表格”“Excel/CSV”“写入/追加表格”、提供 https://doc.weixin.qq.com/sheet/ 链接,或要求处理本地表格文件时应使用本技能。文档搜索、权限、重命名或成员管理使用 wecomcli-doc-manage;智能表格(smartsheet 链接或 s3_ 开头 docid)使用 wecomcli-smartsheet。
Sections in SKILL.md
- 适用范围
- 适用
- 不适用
- 接口路由表
- 表格操作准则(动手前先过一遍,所有任务生效)
- 通用规则
- 跨技能依赖
- docid 使用规则
- 安全提示(最高优先级)
- 交互规范
Key facts
- License
- MIT (repo README)
- Installs on skills.sh
- 11,933 (Nov 2, 2026)
- GitHub stars
- 3,275 (repo, Nov 2, 2026)
- Local files need
- openpyxl, pandas and LibreOffice (soffice), installed on demand
- Last commit
- Oct 19, 2026 (repo)
What it includes
Create or import a sheet; add, delete, rename, copy, hide or move sub-sheets.
Reference: sheet-workbook.md.
Delete ·
Workbook and sub-sheetsRead cells, then count, group, sum, sort and compare across sub-sheets.
Reference: sheet-read-data.md. Searching for a known value uses cells find, one sub-sheet at a time.
Network ·
Read and analyze dataWrite values, formulas, links, rich text, cell images or styles into a range.
Reference: sheet-write-cells.md. After writing, it reads the range back to check.
Write ·
Write cellsTest formulas before writing them.
Reference: sheet-formulas.md.
Network ·
Formula pre-checkInsert, delete, move, sort, auto-fill, copy or cut ranges; resize, hide and merge.
References: sheet-range-operations.md and sheet-structure-operations.md. SKILL.md says to preview the affected range before delete, clear or move.
Delete ·
Ranges, rows and columnsFonts, fill, alignment, number formats, borders, and reusable table styles.
References: sheet-style.md, sheet-table-style.md and sheet-visual-standards.md.
Write ·
Styles and table stylesFind cells or rows by text, and replace text in one sub-sheet at a time.
Reference: sheet-search-replace.md.
Write ·
Search and replaceDropdowns, conditional formatting rules and filters.
References: sheet-validation.md, sheet-conditional-formatting.md and sheet-filter.md.
Delete ·
Validation, formatting and filtersAdd, read, update or delete protected ranges to lock headers or formula areas.
Reference: sheet-protection.md.
Delete ·
Protected rangesCreate, bulk insert, query, replace or delete floating images.
Reference: sheet-float-image.md.
Delete ·
Floating imagesRead the current version and history, or roll the whole workbook back.
Reference: sheet-history.md. Rollback applies to the whole workbook, creates a new version and needs an explicit yes.
Write ·
Version history and rollbackRead, analyze, create or edit .xlsx, .xlsm, .xls, .csv and .tsv files.
Reference: xlsx-process.md. It first runs scripts/collect.py to inspect the structure, and scripts/recalc.py recalculates formulas through LibreOffice.
Runs code ·
Local spreadsheet files
From the official docs
Permissions
Medium risk
It can change, delete and roll back real spreadsheets in your WeCom account, and it can install Python packages and LibreOffice for local files. Use it first on a copy of an important sheet, and approve each destructive step yourself.
What it can do
- Read your data
- Create and change things
- Delete things
- Read-only mode
Watch out for
It can edit, delete and roll back online sheets
The skill's references cover deleting sub-sheets and ranges, removing protections, and rolling a whole workbook back to an older version. SKILL.md says to preview the affected range first. Ask for the preview and confirm. github.com
It installs the CLI and may install more software
The shared check runs npm install -g @wecom/cli when the CLI is missing or old. For local files, xlsx-process.md says to install openpyxl, pandas or LibreOffice if needed. Review those commands before approving. github.com
recalc.py changes your LibreOffice setup
recalc.py writes a macro into the LibreOffice user profile and runs soffice headless. In a sandbox without AF_UNIX sockets it compiles a small shim with gcc into the temp folder. github.com
The CLI reports the calling agent's name
The wecom-cli data-collection notice says the prebuilt npm version sends the name of the calling agent program and its call chain to WeCom's cloud with each request. It can be turned off only by building from source. github.com
Technical details
| Scopes |
|
|---|
Questions
What does wecomcli-sheet do?
It lets Claude create, read and edit WeCom online spreadsheets with the wecom-cli command. It also reads, analyzes and edits local Excel, CSV and TSV files.
How do I install wecomcli-sheet?
Use the install box above. You need the wecom-cli command, the skill, the wecomcli-shared skill and a WeCom sign-in by QR code. The README's skills command installs all 15 WeCom skills.
Do I need the wecomcli-shared skill?
Yes. SKILL.md says to read it and complete its checks before running any wecom-cli command. Those checks confirm the CLI is installed and at least version 1.2.1, and that you are signed in.
Does it need an API key?
SKILL.md names no API key. Access comes from signing in to WeCom with wecom-cli auth init, which shows a QR code to scan. The README mentions an optional Bot ID and secret for a smart robot.
Can it edit local Excel files without WeCom?
Local files are in scope, but the skill still tells Claude to finish the wecomcli-shared checks before any wecom-cli command. For local files it uses Python with openpyxl or pandas, and LibreOffice to recalculate formulas.
Can it export an online sheet to a file or make charts?
No to both. SKILL.md says online charts are not supported and tells Claude to refuse a request to export an online sheet to a local file. It may read a copy internally to analyze data.
Is it safe to use on my company sheets?
It can write to, delete from and roll back real WeCom sheets, and may install software. Try it on a copy first. The CLI also reports the calling agent's name to WeCom, per its data-collection notice.
Information
updated Nov 2, 2026
- Repository
- wecomteam/wecom-cli
- Folder
skills/wecomcli-sheet
Sources
Docs, issue trackers and discussions this page is built from.
Show all 9Hide
- wecom-cli README · github.com
- wecomcli-shared SKILL.md · github.com
- wecomcli-sheet SKILL.md · github.com
- xlsx-process.md · github.com
- wecomcli-sheet on skills.sh · skills.sh
- wecomteam/wecom-cli · github.com
- sheet-history.md · github.com
- wecom-cli data collection notice · github.com
- recalc.py · github.com