skills/standard/office-xlsx/SKILL.md
真实 .xlsx/.csv 读写;tools.run + pandas/openpyxl,无专用 doc MCP
npx skillsauth add sunflowermm/XRK-AGT office-xlsxInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
用户给出或索要 Excel 文件(.xlsx/.xlsm/.csv),而非仅聊天里的 Markdown 表。
tools 工作流 run + pandas/openpyxl:
import pandas as pd
df = pd.DataFrame([{"姓名": "张三", "部门": "研发"}])
df.to_excel("台账.xlsx", index=False)
多 sheet 用 pd.ExcelWriter。
import pandas as pd
df = pd.read_excel("input.xlsx", sheet_name=0)
print(df.head(20).to_markdown())
df.to_csv("export.csv", index=False, encoding="utf-8-sig")
CSV 用 utf-8-sig 便于 Excel 打开中文。
#REF! #DIV/0! 等错误| 场景 | 技能 | |------|------| | 聊天里整理表格、轻量对比 | office-sheet | | 要生成/修改 xlsx 文件 | office-xlsx | | 纯 CSV 清洗、多文件合并 | office-csv |
read / write / run(tools 工作流)pandas openpyxl(run + pip 按需安装)无 pandas → office-sheet / office-csv 文本表或 CSV;见 office-env-setup
development
统一回复版式:短、结构化、可复制;减少空话
tools
MCP 工具地图:默认工作流、web_search、何时启用 desktop/browser/memory
development
检索栈:web_search(13 提供商 + parallel-free 免费通道)、web_fetch、与 office-research 分工
data-ai
工作区 Markdown 记忆 + memory 工作流向量记忆的使用边界