PlugWiki

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. 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. 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

  1. 适用范围
  2. 适用
  3. 不适用
  4. 接口路由表
  5. 表格操作准则(动手前先过一遍,所有任务生效)
  6. 通用规则
  7. 跨技能依赖
  8. docid 使用规则
  9. 安全提示(最高优先级)
  10. 交互规范

Key facts

Installs on skills.sh
11,933 (Nov 2, 2026)

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-sheets

  • Read 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 data

  • Write 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 cells

  • Test formulas before writing them.

    Reference: sheet-formulas.md.

    Network · Formula pre-check

  • Insert, 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 columns

  • Fonts, 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 styles

  • Find cells or rows by text, and replace text in one sub-sheet at a time.

    Reference: sheet-search-replace.md.

    Write · Search and replace

  • Dropdowns, conditional formatting rules and filters.

    References: sheet-validation.md, sheet-conditional-formatting.md and sheet-filter.md.

    Delete · Validation, formatting and filters

  • Add, read, update or delete protected ranges to lock headers or formula areas.

    Reference: sheet-protection.md.

    Delete · Protected ranges

  • Create, bulk insert, query, replace or delete floating images.

    Reference: sheet-float-image.md.

    Delete · Floating images

  • Read 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 rollback

  • Read, 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
  • wecom-cli

  • WeCom online spreadsheets

  • local spreadsheet files

  • python3

  • LibreOffice

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

Folder
skills/wecomcli-sheet

wecomteam/wecom-cliskills.sh

Sources

Docs, issue trackers and discussions this page is built from.

Show all 9
  1. wecom-cli README · github.com
  2. wecomcli-shared SKILL.md · github.com
  3. wecomcli-sheet SKILL.md · github.com
  4. xlsx-process.md · github.com
  5. wecomcli-sheet on skills.sh · skills.sh
  6. wecomteam/wecom-cli · github.com
  7. sheet-history.md · github.com
  8. wecom-cli data collection notice · github.com
  9. recalc.py · github.com

Updated Nov 2, 2026.