表格精算
原名：xlsx
当电子表格文件为主要输入或输出时使用此技能。适用于打开、读取、编辑、修复或创建 .xlsx/.csv 等文件，以及清理混乱的表格数据。若主要交付物为 Word、HTML 或 Python 脚本等非表格文件，则不触发。
- 分类
- 开发提效
- 版本
- v1.0.0
- 作者
- 弈韬(@ra1nzzz)
- 下载
- 2
- 收藏
- 0
- 发布
- 2026-08-17
- 更新
- 2026-08-18
- TRACE 评分
- 3.2 / 5
内容概览
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. Script paths below are relative to this skill's directory. - Professional font (Arial, Times New Roman) throughout, unless the user says otherwise. - Zero formula errors. Never ship while recalc.py reports errors found. If you think an error predates you, prove it: load the original with data only=True and look at that cell. An error …