anthropics/skills✦ 精选0°

xlsx

仓库创建 2025年9月22日最近提交 2 天前SkillHot 收录 20 天前
▸ 精选理由

面向高频表格任务,规范输出与零公式错误要求体现专业度。

这个 Skill 做什么

处理、修复与生成 .xlsx/.xlsm/.csv/.tsv 等电子表格文件的能力。

专门处理 .xlsx/.xlsm/.csv/.tsv 一类的表格工作:能打开、读取、编辑、修复、清洗脏数据、加公式、改格式、做图或相互转换。只要你提到某个表格文件或想把数据变成电子表格就该用。它既能做快速预览,也能用 pandas/openpyxl 做批量和复杂改动,注意保留公式和结构不随意丢数据。

▸ 展开 SKILL.md 英文原文

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

办公文档Excel数据清洗表格处理通用
16.4w
Stars
2.0w
Forks
18
仓库内 Skill
+5.6k
7 日增星
安装 / 使用
给你的 Agent 一句话(通用)
帮我安装这个 skill:https://raw.githubusercontent.com/anthropics/skills/main/skills/xlsx/SKILL.md
或 curl 直取 SKILL.md
curl -fsSL "https://raw.githubusercontent.com/anthropics/skills/main/skills/xlsx/SKILL.md"
SKILL.MD 节选查看完整文件 ↗
# XLSX creation, editing, and analysis

| Task | Approach |
|---|---|
| **Create** or **edit** with formulas/formatting | `openpyxl` — see gotchas below |
| **Bulk data** in or out | `pandas` (`read_excel`, `to_excel`) |
| **Quick look** at a sheet | `markitdown file.xlsx` — `## SheetName` per sheet; reads `.xlsm` too. No cell coordinates, so don't plan edits from it |
| **Read** a model (formulas *and* values) | two `load_workbook` passes — see gotchas |

> `openpyxl`, `pandas`, and `markitdown` are preinstalled — do not run `pip install` first; write the script and import directly. Only if an import fails (or the `markitdown` command is missing): `pip install` the missing package.

> Scrip
via SKILL·HOT · 数据来自 GitHub 公开信息 · 原文版权归作者所有