AgentSkillsCN

xlsx

全面支持公式、格式化、数据分析与可视化,轻松完成电子表格的创建、编辑与分析。当 Claude 需要处理电子表格(.xlsx、.xlsm、.csv、.tsv 等)时,可用于:(1) 创建包含公式与格式化的全新电子表格;(2) 读取或分析数据;(3) 在保留公式的同时修改现有电子表格;(4) 在电子表格中进行数据分析与可视化;(5) 重新计算公式。

SKILL.md
--- frontmatter
version: 4.1.0-fractal
name: xlsx
description: "Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas"
license: Proprietary. LICENSE.txt has complete terms

Requirements for Outputs

All Excel files

🧠 Knowledge Modules (Fractal Skills)

1. Zero Formula Errors

2. Preserve Existing Templates (when updating templates)

3. Color Coding Standards

4. Number Formatting Standards

5. Formula Construction Rules

6. Data analysis with pandas

7. ❌ WRONG - Hardcoding Calculated Values

8. ✅ CORRECT - Using Excel Formulas

9. Creating new Excel files

10. Editing existing Excel files

11. Essential Verification

12. Common Pitfalls

13. Formula Testing Strategy

14. Interpreting recalc.py Output

15. Library Selection

16. Working with openpyxl

17. Working with pandas