xlsx
面向高频表格任务,规范输出与零公式错误要求体现专业度。
处理、修复与生成 .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.
帮我安装这个 skill:https://raw.githubusercontent.com/anthropics/skills/main/skills/xlsx/SKILL.mdcurl -fsSL "https://raw.githubusercontent.com/anthropics/skills/main/skills/xlsx/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