xlsx
高频办公任务自动化利器，适合数据清洗与报表生成。
处理与生成 .xlsx/.csv 等表格文件，支持公式、格式化、清洗与图表。
处理和生成 .xlsx/.csv 等表格文件，能添加公式、格式、图表，清洗脏数据或进行列行重整与汇总分析。会在需要做批量计算、生成报表、把糟糕的表格整理成可用数据或在不同表格格式间转换时用到。特点是同时支持精细单元格操作（公式与样式）和批量数据处理，既能做视觉化也能做数据清洗。
▸ 展开 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/Await-d/OpenAWork/main/packages/resources/resources/skills/reference/xlsx/SKILL.mdcurl -fsSL "https://raw.githubusercontent.com/Await-d/OpenAWork/main/packages/resources/resources/skills/reference/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