Agent Skills › XiaomingX/mimofan › spreadsheets

spreadsheets

GitHub

处理电子表格文件（XLSX, CSV等）的创建、编辑、清洗、分析及转换，支持公式、图表和格式化。

crates/tui/assets/skills/spreadsheets/SKILL.md XiaomingX/mimofan

触发场景

需要生成或修改Excel/CSV文件数据清洗与统计分析表格格式转换

安装

npx skills add XiaomingX/mimofan --skill spreadsheets -g -y

更多选项

非标准路径

npx skills add https://github.com/XiaomingX/mimofan/tree/main/crates/tui/assets/skills/spreadsheets -g -y

不安装直接使用

npx skills use XiaomingX/mimofan@spreadsheets

指定 Agent (Claude Code)

npx skills add XiaomingX/mimofan --skill spreadsheets -a claude-code -g -y

安装 repo 全部 skill

npx skills add XiaomingX/mimofan --all -g -y

预览 repo 内 skill

npx skills add XiaomingX/mimofan --list

SKILL.md

Frontmatter

{
    "name": "spreadsheets",
    "description": "Create, edit, analyze, clean, or convert spreadsheets including XLSX, CSV, TSV, formulas, charts, and tabular reports."
}

Spreadsheets

Use this skill when the input or deliverable is a spreadsheet: .xlsx, .xlsm, .csv, .tsv, or a table that should become one of those formats.

Workflow

Identify whether the task is cleaning, analysis, formatting, charting, or workbook generation.
Preserve source files. Write a new output workbook unless the user asked for an in-place edit.
Use appropriate tools:
- Python csv or pandas for data cleaning and analysis
- openpyxl for XLSX formulas, styles, tables, filters, freeze panes, and charts
- LibreOffice only when conversion or recalculation is needed and available
Keep raw data separate from summary sheets when that helps auditability.
Use formulas when the workbook should remain interactive; use fixed values when the result must be stable and reproducible.
Verify by loading the workbook, checking sheet names, row/column counts, formulas, and representative cell values. For CSV/TSV, check delimiters, quoting, headers, and row widths.

If dependencies are missing, ask before installing packages. Never silently drop rows, change date/time semantics, or coerce IDs with leading zeroes into numbers.