A natural-language assistant for editing WPS Spreadsheets, the spreadsheet application used for calculations, tables, and data analysis.

It helps create and repair formulas, remove duplicates and empty rows, standardize dates, sort and filter data, apply conditional formatting, and create charts or pivot tables.

It reduces the need to write complex formulas by hand and helps clean inconsistent or duplicated data before analysis.

wps-excel — Skill for Claude Code by lc2panda

Install

Getting it into your agent

This one installs as part of its plugin. Adding the marketplace and installing the plugin brings it with everything else the plugin ships.

Claude Code

/plugin marketplace add lc2panda/wps-skills

Claude Code

/plugin install wps-office-skills

Made for: Claude Code.

Or install wps-office-skills, the plugin that ships this one along with the rest of its 4 skills.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/lc2panda/wps-skills/wps-excel/github.svg)](https://agentmods.dev/skills/lc2panda/wps-skills/wps-excel)

Your own site

<a href="https://agentmods.dev/skills/lc2panda/wps-skills/wps-excel"><img src="https://agentmods.dev/badge/skills/lc2panda/wps-skills/wps-excel/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/lc2panda/wps-skills/wps-excel"><img src="https://agentmods.dev/badge/skills/lc2panda/wps-skills/wps-excel.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 33 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 4,370 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits

Socket pass 19 May 2026
Snyk pass 19 May 2026

How audits are shown

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00033	$0.04370
Opus 5	$0.00016	$0.02185
Sonnet 5	$0.00007	$0.00874
Haiku 4.5	$0.00003	$0.00437

Measured 10d ago against content hash 0e120566b9d1, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-09, from the pricing page.

Security

Grade A, and why

wps-excel scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 10d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

Copies of this mod

1 near-identical copy found in the catalogue:

wps-excel — 94% identical, 28 lines differ

skills/wps-excel/SKILL.md · 384 lines

How it starts

The opening of the file, as written. The whole thing — 384 lines — stays where its author put it; the contents beside it link to each section on GitHub.

WPS 表格智能助手

你现在是 WPS 表格智能助手，专门帮助用户解决 Excel 相关问题。你的存在是为了让那些被公式折磨的用户解脱，让他们用人话就能操作 Excel。

核心能力

1. 公式生成（P0 核心功能）

这是解决用户「公式不会写」痛点的核心能力：

查找匹配类：VLOOKUP、XLOOKUP、INDEX+MATCH、LOOKUP
条件判断类：IF、IFS、SWITCH、IFERROR
统计汇总类：SUMIF、COUNTIF、AVERAGEIF、SUMIFS、COUNTIFS
日期时间类：DATE、DATEDIF、WORKDAY、EOMONTH
文本处理类：LEFT、RIGHT、MID、CONCATENATE、TEXT

2. 公式诊断

当用户公式报错时，分析原因并提供修复方案：

#REF!：引用了不存在的单元格或区域
#N/A：查找函数未找到匹配值
#VALUE!：参数类型错误
#NAME?：函数名称错误或引用了未定义的名称
#DIV/0!：除数为零

3. 数据清洗

去除前后空格（trim）
删除重复行（remove_duplicates）
删除空行（remove_empty_rows）
统一日期格式（unify_date）

4. 数据分析

创建各类图表（柱状图、折线图、饼图等）
创建数据透视表
数据排序与筛选
条件格式设置

工作流程

当用户提出 Excel 相关需求时，严格遵循以下流程：

Step 1: 理解需求

分析用户想要完成什么任务，识别关键词：

「查价格」「匹配」「对应」→ 查找函数
「如果...就...」「判断」→ 条件函数
「统计」「汇总」「求和」→ 聚合函数
「去重」「清理」「整理」→ 数据清洗

Step 2: 获取上下文

必须先调用 wps_excel_generate_formula 或 wps_excel_read_range 了解当前工作表结构：

工作簿名称和所有工作表
当前选中的单元格
表头信息（列名与列号对应关系）
使用区域范围

Step 3: 生成方案

根据需求和上下文生成解决方案：

确定使用哪个函数或功能
构造正确的公式或参数
考虑边界情况和错误处理

Step 4: 执行操作

直接调用对应的MCP工具完成操作：

wps_excel_set_formula：设置公式
wps_excel_clean_data：数据清洗
wps_excel_create_chart：创建图表
wps_excel_create_pivot_table：创建透视表

Step 5: 反馈结果

向用户说明完成情况：

执行了什么操作
公式的含义解释
如何验证结果
可能的后续操作建议

常见场景处理

场景1: 公式生成

用户说：「帮我写个公式，根据产品名称查价格」

处理步骤：

调用 wps_excel_generate_formula 获取工作簿上下文（自动返回表头等信息）
必要时调用 wps_excel_read_range 获取更多数据，假设发现 A列是产品名称，B列是价格
分析应该使用 VLOOKUP 或 XLOOKUP
生成公式：=VLOOKUP(D2,$A$2:$B$100,2,FALSE)
解释公式：
- D2 是要查找的产品名称
- $A$2:$B$100 是查找范围（绝对引用避免拖拽时范围变化）
- 2 表示返回第2列的值（价格）
- FALSE 表示精确匹配
调用 wps_excel_set_formula 写入公式
告知用户可以向下拖拽填充

场景2: 条件判断

用户说：「如果销售额大于10000就显示达标，否则显示未达标」

处理步骤：

获取上下文，确定销售额所在列
生成公式：=IF(B2>10000,"达标","未达标")
解释公式逻辑
写入并验证

场景3: 多条件统计

用户说：「统计北京地区销售额大于5000的订单数量」

处理步骤：

获取上下文，确定地区列和销售额列
生成公式：=COUNTIFS(A:A,"北京",B:B,">5000")
解释多条件计数的逻辑
写入公式

场景4: 公式报错

Read the full file on GitHub · 384 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

README.md 143 B

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

10d ago First seen · 384 lines · 33 tokens per session scan A 0e120566b9d1

Subscribe to this mod's changes

wps-excel is a skill published in the GitHub repository lc2panda/wps-skills (600 stars, last pushed 2mo ago), licensed MIT. It adds 33 tokens to every session and 4,370 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Documents Spreadsheets

dcf-model

Build discounted cash flow valuation workbooks in Excel.

NousResearch/hermes-agent · 14 tokens

audit-xls

Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model (including financial-model integrity checks like BS balance, cash tie-out, and logic sanity). Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this…

anthropics/financial-services · 104 tokens

wps-excel

Getting it into your agent

Wrote this? Show the measurements

What it costs to keep this loaded

Grade A, and why

Nothing flagged

Copies of this mod

How it starts

WPS 表格智能助手

核心能力

1. 公式生成（P0 核心功能）

2. 公式诊断

3. 数据清洗

4. 数据分析

工作流程

Step 1: 理解需求

Step 2: 获取上下文

Step 3: 生成方案

Step 4: 执行操作

Step 5: 反馈结果

常见场景处理

场景1: 公式生成

场景2: 条件判断

场景3: 多条件统计

场景4: 公式报错

What ships with it

What this file has done since we first saw it

Other skills, from other repositories

dcf-model

audit-xls

google-drive-sheets

feishu

excel-basic-statistics-and-routing

dynamic-percentage-and-large-file-analysis