Agent skill

Wps Excel

WPS 表格智能助手，通过自然语言操控 Excel，解决公式编写、数据清洗、图表创建等痛点问题. An agent skill from lc2panda/wps-skills.

Install Wps Excel

skills CLI

$ npx skills add lc2panda/wps-skills --skill wps-excel -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install lc2panda/wps-skills wps-excel --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/lc2panda/wps-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/wps-excel .claude/skills/wps-excel && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "wps-excel" agent skill from https://github.com/lc2panda/wps-skills/tree/main/skills/wps-excel into .claude/skills/wps-excel/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wps-excel", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/lc2panda/wps-skills/tree/main/skills/wps-excel

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add lc2panda/wps-skills --skill wps-excel -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install lc2panda/wps-skills wps-excel --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/lc2panda/wps-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/wps-excel .agents/skills/wps-excel && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "wps-excel" agent skill from https://github.com/lc2panda/wps-skills/tree/main/skills/wps-excel into .agents/skills/wps-excel/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wps-excel", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add lc2panda/wps-skills --skill wps-excel -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install lc2panda/wps-skills wps-excel --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/lc2panda/wps-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/wps-excel .cursor/skills/wps-excel && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "wps-excel" agent skill from https://github.com/lc2panda/wps-skills/tree/main/skills/wps-excel into .cursor/skills/wps-excel/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wps-excel", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/lc2panda/wps-skills.git --path skills/wps-excel

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add lc2panda/wps-skills --skill wps-excel -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install lc2panda/wps-skills wps-excel --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/lc2panda/wps-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/wps-excel .gemini/skills/wps-excel && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "wps-excel" agent skill from https://github.com/lc2panda/wps-skills/tree/main/skills/wps-excel into .gemini/skills/wps-excel/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wps-excel", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install lc2panda/wps-skills wps-excel

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add lc2panda/wps-skills --skill wps-excel -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/lc2panda/wps-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/wps-excel .github/skills/wps-excel && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "wps-excel" agent skill from https://github.com/lc2panda/wps-skills/tree/main/skills/wps-excel into .github/skills/wps-excel/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wps-excel", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add lc2panda/wps-skills --skill wps-excel -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install lc2panda/wps-skills wps-excel --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/lc2panda/wps-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/wps-excel .opencode/skills/wps-excel && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "wps-excel" agent skill from https://github.com/lc2panda/wps-skills/tree/main/skills/wps-excel into .opencode/skills/wps-excel/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "wps-excel", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: wps-excel
GitHub stars: 635
Token cost: ~2.3k tokens
SKILL.md length: 467 words
Files: 2
Skills in repo: 4
Repo updated: Jun 30, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

WPS 表格智能助手，通过自然语言操控 Excel，解决公式编写、数据清洗、图表创建等痛点问题. An agent skill from lc2panda/wps-skills.

Works in 9 steps: 公式生成（P0 核心功能） → 公式诊断 → 数据清洗 → …
Tasks that involve Excel spreadsheets
SKILL.md covers 核心能力, 工作流程, 常见场景处理 and 公式编写规范, plus 2 more sections
Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Wps Excel is an agent skill from lc2panda/wps-skills. WPS 表格智能助手，通过自然语言操控 Excel，解决公式编写、数据清洗、图表创建等痛点问题

Its SKILL.md is about 2.3k tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `README.md`).

It sits in Documents & Office, covering Excel spreadsheets. It works with Microsoft Excel. The repository describes itself as: WPS Skills | WPS Office 智能助手 | WPS Office AI Assistant. The licence is MIT.

When your agent uses it

Tasks that involve Excel spreadsheets

Example prompts

“/wps-excel”

Workflow steps

9 steps, taken from the step headings in SKILL.md.

公式生成（P0 核心功能）
公式诊断
数据清洗
数据分析
理解需求
获取上下文
生成方案
执行操作
反馈结果

What it can do on your machine

Read from SKILL.md and the folder at commit a825336. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are excel and javascript).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Wps Excel loads about 2.3k tokens when it runs. Until then it costs about 14 tokens; SKILL.md has 467 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~14
When it runs · the whole SKILL.md, loaded when a task matches: ~2.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from lc2panda/wps-skills at commit a825336, republished under its MIT licence (© lc2panda). 467 words, ~2,328 tokens.

Download SKILL.mdSave it as .claude/skills/wps-excel/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.

name: wps-excel
description: WPS 表格智能助手，通过自然语言操控 Excel，解决公式编写、数据清洗、图表创建等痛点问题

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: 公式报错

用户说：「这个公式报 #REF! 错误，帮我看看」

处理步骤：

调用 wps_excel_diagnose_formula (参数: {cell: "出错单元格"}) 获取诊断信息
分析错误原因（可能删除了被引用的行/列）
提供修复建议：检查引用范围，更新公式

场景5: 数据清洗

用户说：「把这个表格整理一下，有很多重复数据和空行」

处理步骤：

确认要清洗的范围
调用 wps_excel_clean_data 执行：
- trim：去除空格
- remove_empty_rows：删除空行
- remove_duplicates：删除重复行
报告清洗结果（处理了多少条数据）

公式编写规范

绝对引用 vs 相对引用

相对引用 A1：拖拽时会自动变化
绝对引用 $A$1：拖拽时保持不变
混合引用 $A1 或 A$1：固定列或固定行

建议：查找范围通常使用绝对引用，避免拖拽时出错

常用公式模板

excel

# 精确查找
=VLOOKUP(查找值, 查找范围, 返回列号, FALSE)
=XLOOKUP(查找值, 查找列, 返回列, "未找到")

# 条件判断
=IF(条件, 真值, 假值)
=IFS(条件1, 值1, 条件2, 值2, TRUE, 默认值)
=IFERROR(公式, 错误时返回值)

# 条件统计
=SUMIF(条件范围, 条件, 求和范围)
=COUNTIF(范围, 条件)
=SUMIFS(求和范围, 条件范围1, 条件1, 条件范围2, 条件2)

# 日期处理
=DATEDIF(开始日期, 结束日期, "Y")  # 计算年数
=WORKDAY(开始日期, 工作日数)        # 计算工作日
=EOMONTH(日期, 0)                   # 获取月末日期

注意事项

安全原则

确认范围：操作前确认数据范围，避免误操作重要数据
备份提醒：大规模操作前建议用户备份
验证结果：操作后验证结果是否符合预期

沟通原则

先理解后执行：不确定需求时先询问
解释说明：公式要附带解释，让用户理解原理
提供选项：多种方案时让用户选择
错误友好：出错时提供详细分析和修复建议

性能考虑

避免全列引用：A:A 可能导致性能问题，尽量用具体范围
简化公式：能用简单公式解决的不用复杂公式
批量操作：需要处理大量数据时分批进行

可用MCP工具

本Skill通过以下已注册MCP工具与WPS Office交互（共80个）：

工作簿管理工具（10个）

MCP工具	功能描述
`wps_excel_open_workbook`	打开指定路径的Excel工作簿文件
`wps_excel_get_open_workbooks`	获取当前所有已打开的Excel工作簿列表
`wps_excel_switch_workbook`	切换到指定名称的Excel工作簿
`wps_excel_close_workbook`	关闭指定的Excel工作簿，可选是否保存
`wps_excel_create_workbook`	新建一个空白Excel工作簿
`wps_excel_get_cell_value`	获取Excel指定单元格的值
`wps_excel_set_cell_value`	设置Excel指定单元格的值
`wps_excel_get_formula`	获取Excel指定单元格的公式
`wps_excel_get_cell_info`	获取单元格的详细信息（值、公式、格式等）
`wps_excel_clear_range`	清除指定范围的内容、格式或全部

公式工具（6个）

MCP工具	功能描述
`wps_excel_set_formula`	在指定单元格设置Excel公式（必须以=开头）
`wps_excel_generate_formula`	根据自然语言描述生成Excel公式
`wps_excel_diagnose_formula`	诊断公式错误，分析原因并提供修复建议
`wps_excel_evaluate_formula`	计算并返回公式结果
`wps_excel_set_print_area`	设置打印区域
`wps_excel_zoom`	设置工作表缩放比例

数据处理工具（12个）

MCP工具	功能描述
`wps_excel_read_range`	读取Excel指定范围的单元格数据
`wps_excel_write_range`	向Excel指定范围写入二维数组数据
`wps_excel_clean_data`	数据清洗工具，支持多种清洗操作的组合
`wps_excel_remove_duplicates`	删除指定范围内的重复行
`wps_excel_sort_range`	对Excel选定区域按指定列排序
`wps_excel_find_replace`	在Excel中查找并替换内容
`wps_excel_insert_row`	在Excel中插入行
`wps_excel_add_comment`	给单元格添加批注
`wps_excel_protect_sheet`	保护或取消保护工作表
`wps_excel_set_conditional_format`	设置条件格式
`wps_excel_protect_workbook`	保护或取消保护工作簿，防止结构被修改
`wps_excel_set_zoom`	设置当前工作表的缩放比例（10-400%）

Show full SKILL.md (182 more words)Show less

高级数据工具（7个）

MCP工具	功能描述
`wps_excel_auto_filter`	对Excel指定范围应用自动筛选
`wps_excel_copy_range`	复制Excel指定范围到目标位置
`wps_excel_paste_range`	粘贴已复制的内容到指定位置
`wps_excel_fill_series`	自动填充序列数据
`wps_excel_transpose`	转置数据（行列互换）
`wps_excel_text_to_columns`	将文本按分隔符拆分到多列
`wps_excel_subtotal`	创建分类汇总

图表工具（4个）

MCP工具	功能描述
`wps_excel_create_chart`	在Excel中创建图表（柱状图/折线图/饼图/散点图等）
`wps_excel_update_chart`	更新Excel图表的属性（标题/颜色/图例/数据标签等）
`wps_excel_export_chart_as_image`	将工作表中的图表导出为 PNG/JPG/GIF/BMP 位图（Chart.Export 原生 API，1:1 像素级还原，替代 pdf2image 中转）
`wps_excel_export_range_as_image`	将指定区域（如 A1:F20）导出为 PNG/JPG/GIF/BMP 位图（CopyPicture + 临时图表经典做法，1:1 还原表格视觉）

支持的图表类型：column_clustered, column_stacked, bar_clustered, line, line_markers, pie, doughnut, scatter, area, radar

图表导出示例：wps_excel_export_chart_as_image({ chartName: "Chart 1", outputPath: "/Users/me/Downloads/chart1.png", format: "PNG" }) — 适用于"把销售柱状图导成 PNG""把图表保存成高清图片用于报告"等场景。

区域导出示例：wps_excel_export_range_as_image({ range: "A1:F20", outputPath: "/Users/me/Downloads/table.png", format: "PNG" }) — 适用于"把表格区域保存为图片""导出数据区贴到 PPT"等场景。注意此方法依赖剪贴板，headless 模式下可能失败。

透视表工具（2个）

MCP工具	功能描述
`wps_excel_create_pivot_table`	创建Excel透视表，用于数据汇总和分析
`wps_excel_update_pivot_table`	更新已有透视表的配置（添加/移除字段、修改聚合方式等）

工作表管理工具（16个）

MCP工具	功能描述
`wps_excel_create_sheet`	在当前工作簿中创建新的工作表
`wps_excel_delete_sheet`	删除当前工作簿中的指定工作表（不可撤销）
`wps_excel_rename_sheet`	重命名当前工作簿中的指定工作表
`wps_excel_copy_sheet`	复制当前工作簿中的指定工作表
`wps_excel_get_sheet_list`	获取当前工作簿的所有工作表列表
`wps_excel_switch_sheet`	切换到指定的工作表
`wps_excel_move_sheet`	移动指定工作表到新的位置
`wps_excel_get_selection`	获取当前Excel中选中区域的信息
`wps_excel_delete_row`	删除指定行（可指定起始行号和删除行数）
`wps_excel_insert_column`	在指定位置插入列（可指定起始列号和插入列数）
`wps_excel_delete_column`	删除指定列（可指定起始列号和删除列数）
`wps_excel_freeze_panes`	冻结/取消冻结窗格
`wps_excel_auto_fill`	自动填充单元格区域（根据源区域数据模式自动填充）
`wps_excel_set_named_range`	设置命名范围（为指定单元格区域创建或更新命名范围）
`wps_excel_hide_column`	隐藏或显示指定列
`wps_excel_auto_sum`	对指定范围的列或行自动求和

格式化工具（10个）

MCP工具	功能描述
`wps_excel_set_cell_format`	设置Excel单元格格式（字体/颜色/背景色/粗体/斜体/字号等）
`wps_excel_set_cell_style`	应用预定义样式到Excel单元格（标题/强调/输入/输出等）
`wps_excel_set_border`	设置Excel单元格边框样式（支持不同粗细、位置和颜色）
`wps_excel_set_number_format`	设置Excel单元格的数字格式
`wps_excel_merge_cells`	合并Excel指定范围的单元格
`wps_excel_unmerge_cells`	拆分Excel中已合并的单元格
`wps_excel_set_column_width`	设置Excel指定列的列宽（支持单列或连续多列）
`wps_excel_set_row_height`	设置Excel指定行的行高
`wps_excel_hide_row`	隐藏或显示Excel指定行（可一次操作连续多行）
`wps_excel_set_data_validation`	设置Excel单元格的数据验证规则（下拉列表/数值范围/日期范围等）

行列工具（8个）

MCP工具	功能描述
`wps_excel_insert_rows`	在Excel中指定位置插入一行或多行
`wps_excel_insert_columns`	在Excel中指定位置插入一列或多列
`wps_excel_delete_rows`	删除Excel中指定位置的一行或多行
`wps_excel_delete_columns`	删除Excel中指定位置的一列或多列
`wps_excel_hide_rows`	隐藏Excel中指定范围的行
`wps_excel_show_rows`	显示Excel中已隐藏的行
`wps_excel_show_columns`	显示Excel中已隐藏的列
`wps_excel_group_rows`	对Excel中指定范围的行进行分组（便于折叠/展开管理）

批注保护工具（7个）

MCP工具	功能描述
`wps_excel_delete_cell_comment`	删除Excel单元格上的批注
`wps_excel_get_cell_comments`	获取Excel指定范围内的所有批注
`wps_excel_unprotect_sheet`	取消保护当前工作表
`wps_excel_lock_cells`	锁定或解锁Excel指定范围的单元格（需配合工作表保护使用）
`wps_excel_set_array_formula`	为Excel指定范围设置数组公式（CSE数组公式）
`wps_excel_insert_excel_image`	在Excel中插入图片到指定位置
`wps_excel_set_hyperlink`	为Excel单元格设置超链接

调用示例

javascript

// 创建图表（直接调用MCP工具）
wps_excel_create_chart({
  data_range: "A1:B10",
  chart_type: "line",
  title: "销售趋势"
})

// 数据清洗
wps_excel_clean_data({
  range: "A1:D100",
  operations: ["trim", "remove_duplicates", "remove_empty_rows"]
})

// 创建透视表
wps_excel_create_pivot_table({
  sourceRange: "A1:E100",
  destinationCell: "G1",
  rowFields: ["部门"],
  valueFields: [{ field: "销售额", aggregation: "SUM" }]
})

// 设置单元格格式
wps_excel_set_cell_format({
  range: "A1:D1",
  format: { bold: true, fontSize: 14, bgColor: "#4472C4", fontColor: "#FFFFFF" }
})

// 获取工作表列表
wps_excel_get_sheet_list()

Skill by lc2panda - WPS MCP Project

<!-- 审计记录：2026-03-21 T18 同步工具列表 65→80个MCP工具（+行列工具8个、+批注保护工具7个，与代码100%同步） -->

Files

SKILL.md and 1 other file in skills/wps-excel of lc2panda/wps-skills.

SKILL.md
README.md

Open the folder on GitHubat commit a825336

Compare with similar skills

Wps Excel next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Wps Excel compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Wps Excel this skilllc2panda/wps-skills	635	—	~2.3k	Automated safety check: Pass	MIT	3 mo ago
MarkitdownImCa0/just-laws	781	14 repos	~3.2k	Automated safety check: Notes	MIT	today
Data Table Managern8n-io/n8n	207k	—	~2.3k	Automated safety check: Pass	Custom licence	today
Docx4jplutext/docx4j	2.4k	—	~2.5k	Automated safety check: Pass	None	today
Instrument Data To Allotropeaws-samples/amazon-bedrock-agents-healthcare-lifesciences	274	2 repos	~2.7k	Automated safety check: Pass	Apache-2.0	6 days ago
Cyber Pptcrazyykhllc-bit/CyberPPT	1.8k	—	~10k	Automated safety check: Pass	MIT	2 mo ago

Similar skills

Markitdown
ImCa0/just-laws
Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.
781 GitHub starsUsed in 14 repos~3.2k tokens
Documents & OfficeAuto-check: notes
Data Table Manager
n8n-io/n8n
Official
Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.
207k GitHub stars~2.3k tokensUpdated today
Documents & OfficeAuto-check passed
Docx4j
plutext/docx4j
A skill your agent uses when writing Java code that creates, reads or edits Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) files with docx4j — including generating documents, editing existing…
2.4k GitHub stars~2.5k tokensUpdated today
Documents & OfficeAuto-check passed
Instrument Data To Allotrope
aws-samples/amazon-bedrock-agents-healthcare-lifesciences
Official
Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.
274 GitHub starsUsed in 2 repos~2.7k tokens
Documents & OfficeAuto-check passed
Cyber Ppt
crazyykhllc-bit/CyberPPT
当用户需要把 DOCX、PDF、TXT、XLSX、研究报告、业务材料或原始数据转成高密度、可编辑、咨询风格 PPTX 时使用；也适用于需要 SCR 论证、视觉风格探索、详细图表和渲染质检的 PPT。
1.8k GitHub stars~10k tokensUpdated 2 mo ago
Documents & OfficeAuto-check passed
Markit
shift-labs-ai/markit
Convert files and URLs to Markdown. An agent skill from shift-labs-ai/markit.
1.3k GitHub stars~299 tokensUpdated 1 mo ago
Documents & OfficeAuto-check passed

Questions about Wps Excel

What does Wps Excel do?

WPS 表格智能助手，通过自然语言操控 Excel，解决公式编写、数据清洗、图表创建等痛点问题. An agent skill from lc2panda/wps-skills. Wps Excel is an agent skill from lc2panda/wps-skills.

When should I use Wps Excel?

Wps Excel fits situations like: tasks that involve Excel spreadsheets.

How do I install Wps Excel in Claude Code?

Run `npx skills add lc2panda/wps-skills --skill wps-excel -a claude-code`. Or copy the skill folder (skills/wps-excel in lc2panda/wps-skills) into .claude/skills/wps-excel in your project. Claude Code loads it when a task matches its description.

How do I install Wps Excel in Codex?

Run `npx skills add lc2panda/wps-skills --skill wps-excel -a codex`. Or copy the skill folder (skills/wps-excel in lc2panda/wps-skills) into .agents/skills/wps-excel in your project. Codex loads it when a task matches its description.

Can I use Wps Excel in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add lc2panda/wps-skills --skill wps-excel -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/wps-excel, .gemini/skills/wps-excel, .github/skills/wps-excel and .opencode/skills/wps-excel in your project.

What does Wps Excel need to run?

SKILL.md names no scripts, command-line tools or credentials: Wps Excel is instructions for the agent only.

Does Wps Excel access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Wps Excel safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Wps Excel use?

Wps Excel is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Wps Excel use?

About 2.3k tokens (SKILL.md is roughly 9.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Wps Excel?

Skills that share tags, products or a category with Wps Excel: Markitdown (ImCa0/just-laws, 781 stars), Data Table Manager (n8n-io/n8n, 207k stars), Docx4j (plutext/docx4j, 2.4k stars) and Instrument Data To Allotrope (aws-samples/amazon-bedrock-agents-healthcare-lifesciences, 274 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Wps Excel?

lc2panda (a GitHub user) maintains it in lc2panda/wps-skills, which has 635 GitHub stars. The repository holds 4 skills in this directory. The repository was last updated on June 30, 2026.

Source: lc2panda/wps-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Wps Excel

Facts

At a glance

What it does

When your agent uses it

Example prompts

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

WPS 表格智能助手

核心能力

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

2. 公式诊断

3. 数据清洗

4. 数据分析

工作流程

Step 1: 理解需求

Step 2: 获取上下文

Step 3: 生成方案

Step 4: 执行操作

Step 5: 反馈结果

常见场景处理

场景1: 公式生成

场景2: 条件判断

场景3: 多条件统计

场景4: 公式报错

场景5: 数据清洗

公式编写规范

绝对引用 vs 相对引用

常用公式模板

注意事项

安全原则

沟通原则

性能考虑

可用MCP工具

工作簿管理工具（10个）

公式工具（6个）

数据处理工具（12个）

高级数据工具（7个）

图表工具（4个）

透视表工具（2个）

工作表管理工具（16个）

格式化工具（10个）

行列工具（8个）

批注保护工具（7个）

调用示例

Files

Compare with similar skills

Similar skills

More from lc2panda/wps-skills

Related

Questions about Wps Excel