spreadsheet
当任务涉及使用 Python(`openpyxl`、`pandas`)创建、编辑、分析或格式化电子表格(`.xlsx`、`.csv`、`.tsv`)时使用,尤其是在需要保留并验证公式、引用和格式的情况下。
机器翻译查看英文原文
Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified.
适用对象:Excel / XLSX。自动收录 · 待核查。
原作者说明节选
从固定版本的 SKILL.md 提取,保留原文语言。以下内容属于作者说明,本站尚未验证安装、兼容或运行结果。
查看英文原文
原文涵盖的主题
- Spreadsheet Skill (Create, Edit, Analyze, Visualize)
- When to use
- Workflow
- Temp and output conventions
- Primary tooling
- Rendering and visual checks
- Dependencies (install if missing)
- Environment
Build new workbooks with formulas, formatting, and structured layouts. Read or analyze tabular data (filter, aggregate, pivot, compute metrics). Modify existing workbooks without breaking formulas or references. Visualize data with charts/tables and sensible formatting. IMPORTANT: System and user instructions always take precedence. 1. Confirm the file type and goals (create, edit, analyze, visualize). 2. Use openpyxl for .xlsx edits and pandas for analysis and CSV/TSV workflows. 3. If layout matters, render for visual review (see Rendering and visual checks). 4. Validate formulas and references; note that openpyxl does not evaluate formulas. 5. Save outputs and clean up intermediate files. Use tmp/spreadsheets/ for intermediate files; delete when done. Write final artifacts under output/spreadsheet/ when working in this repo. Keep filenames stable and descriptive. Use openpyxl for creating/editing .xlsx files and preserving formatting. Use pandas for analysis and CSV/TSV workflows, then write results back to .xlsx or .csv. If you need charts, prefer openpyxl.chart for native Excel charts. If LibreOffice (soffice) and Poppler (pdftoppm) are available, render sheets for visual revie
这里只展示节选,请以完整原文和当前要求为准。
- 来源仓库
- davila7/claude-code-templates
- 源文件
- cli-tool/components/skills/document-processing/spreadsheet/SKILL.md
- 固定版本
- 21be197f100a12b8d0dd9a211cc244c8179f84d3
来源与内容状态
本条为自动发现的元数据,尚未完成人工文档核查;适用性与运行结果待核查。
原作者:davila7/claude-code-templates · 原作者仓库元数据。文档核查:未核查。最近来源检查:2026-11-09T15:01:39.318Z。
分类由名称、说明与路径规则生成,分类不代表已核实适配。
许可与权利归属
MIT。第三方内容及版权归原作者,使用条件以原文为准。
许可原文 ↗本站没有因同步、复制或用户自报成功而将资源标为运行验证通过。
限制与注意事项
- 元数据收录不代表本站已经安装、适配、实测或进行安全审查。