AGENT SKILL
xlsx
Create, read, edit Excel .xlsx workbooks and CSVs.
- License 许可
- MIT
- 最近更新
- 2026-11-15
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- xlsx
- author
- Nous Research
- license
- MIT
- version
- 1.1.0
- metadata
- { "hermes": { "tags": [ "excel", "spreadsheet", "xlsx", "csv", "openpyxl", "productivity" ], "category": "office", "related_skills": [ "docx", "pdf", "pptx" ] } }
- platforms
- [ "linux", "macos", "windows" ]
- description
- Create, read, edit Excel .xlsx workbooks and CSVs.
- when-to-use
- Use when creating, reading, editing, or recalculating Excel .xlsx workbooks and CSVs — styled multi-sheet reports, formulas, tables, charts, data validation, and CSV interop — with openpyxl.
- argument-hint
- create <spec.json> <out.xlsx>|read <file.xlsx> [--sheets|--json|--csv|--formulas|--notes|--names] --sheet NAME [--data-only] [--encoding ENC] [--out PATH]|edit <file.xlsx> --set CELL=VALUE|edit --append ROWJSON|edit --add-table NAME:RANGE[:STYLE]|edit --table-append NAME=ROWJSON|edit --list-tables|edit --define-name NAME=REF|edit --delete-name NAME|edit --hyperlink CELL=URL[|TEXT]|edit --note CELL=TEXT[|AUTHOR]|edit --clear-note CELL|edit --protect [PASSWORD]|edit --unlock RANGE|edit --recalc|edit --copy-sheet SRC:NEW|edit --rename-sheet OLD:NEW|restructure <file.xlsx> --sheet NAME --insert-rows IDX[:N]|restructure --sheet NAME --delete-rows IDX[:N]|restructure --sheet NAME --insert-cols COL[:N]|restructure --sheet NAME --delete-cols COL[:N]|recalc <file.xlsx> [--out PATH] [--timeout N]|csv_to_xlsx <in.csv> <out.xlsx> [--sheet-name NAME] [--encoding ENC] [--delimiter DEL]|xlsx_to_csv <file.xlsx> <out.csv> [--sheet NAME] [--encoding ENC] [--delimiter DEL] [--data-only]
02 资源文件 11
- 许可证LICENSE1.0 KB
- 参考文档references/restructuring.md3.6 KB
- 参考文档references/usage.md9.0 KB
- 脚本scripts/csv_to_xlsx.py3.4 KB
- 脚本scripts/xlsx_create.py9.6 KB
- 脚本scripts/xlsx_edit.py10.6 KB
- 脚本scripts/xlsx_read.py5.7 KB
- 脚本scripts/xlsx_recalc.py4.1 KB
- 脚本scripts/xlsx_restructure.py13.4 KB
- 脚本scripts/xlsx_to_csv.py2.3 KB
- 脚本tests/test_xlsx_skill.py21.0 KB
03 SKILL.md 正文
Xlsx Skill
Work with Excel .xlsx workbooks using Python and openpyxl: build styled multi-sheet workbooks with formulas and charts, inspect or dump existing files, edit cells and structure, and convert to/from CSV. All helper scripts are argparse CLIs that print JSON and use explicit UTF-8 I/O.
Global rules
- openpyxl does not calculate formulas. Formula results appear only via
load_workbook(path, data_only=True)and only when the file was previously saved by a real spreadsheet app; otherwise cached values areNone. Add--recalc/"full_calc_on_load": trueso Excel/LibreOffice recompute on open, then runxlsx_recalc.pyheadlessly ifsofficeis available. - Use
xlsx_restructure.pyfor insert/delete operations on sheets with formulas, merges, tables, or filters — it rewrites references across all sheets; plainxlsx_edit.pyinsert/delete does not shift references. - Sheet protection is not security.
--protectsets a standard xlsx sheet-protection hash that well-behaved apps honor; anyone can strip it by editing the zip's XML. Never present it as confidentiality or integrity protection.
Routing
| Step | Reference | Purpose |
|---|---|---|
| Commands, procedure, pitfalls, verification | references/usage.md |
When to Use, prerequisites, quick-reference command table, end-to-end procedure, PDF conversion, full pitfall list, and the post-edit verification checklist. |
| Reference-aware row/column insert/delete | references/restructuring.md |
Exact rewrite rules and honest limits for xlsx_restructure.py — what it shifts, what it cannot shift (charts, images, conditional-format rule formulas), and the JSON report it prints. |
04 同仓库更多 Skills
github-workflow
Umbrella for GitHub auth, repo management, issues, PRs, Mergify, and releases. Subsumes github-auth and repo-manager.
★ 0
brave-automation
baa CLI: Brave profiles, Google sessions, credentials.
★ 0
aes
AES docs, layers, rule fixes, and legacy migration.
★ 0
pretext
Build creative browser demos with DOM-free text layout.
★ 0
popular-web-designs
54 real design systems (Stripe, Linear, Vercel) as HTML/CSS.
★ 0
p5js
p5.js sketches: gen art, shaders, interactive, 3D.
★ 0