Agent Skills › mindscale-noah/MindMemOS › xlsx

xlsx

GitHub

提供处理Excel文件(.xlsx/.xls/.csv)的能力，涵盖读写数据、公式计算、单元格操作、格式化及自动化任务。支持openpyxl和pandas工具，并提示常见陷阱如索引基性和空行统计问题。

resources/skill_evolve/spreadsheetbench_init_skill/xlsx/SKILL.md mindscale-noah/MindMemOS

触发场景

用户需要读取或写入Excel文件涉及电子表格数据处理、公式更新或格式调整

安装

npx skills add mindscale-noah/MindMemOS --skill xlsx -g -y

更多选项

非标准路径

npx skills add https://github.com/mindscale-noah/MindMemOS/tree/main/resources/skill_evolve/spreadsheetbench_init_skill/xlsx -g -y

不安装直接使用

npx skills use mindscale-noah/MindMemOS@xlsx

指定 Agent (Claude Code)

npx skills add mindscale-noah/MindMemOS --skill xlsx -a claude-code -g -y

安装 repo 全部 skill

npx skills add mindscale-noah/MindMemOS --all -g -y

预览 repo 内 skill

npx skills add mindscale-noah/MindMemOS --list

SKILL.md

Frontmatter

{
    "name": "xlsx",
    "description": "Use this skill whenever the user wants to do anything with Excel spreadsheet files (.xlsx, .xls, .csv). This includes reading data, writing formulas, manipulating cells, formatting, filtering, creating charts, pivot tables, and any spreadsheet automation tasks."
}

Excel Spreadsheet Processing

Use openpyxl to read and write .xlsx files.

Quick Start

from openpyxl import load_workbook

wb = load_workbook("input.xlsx")
ws = wb["Sheet1"]

value = ws["A1"].value
ws["B2"] = 42
ws["C2"] = "=SUM(A2:B2)"

wb.save("output.xlsx")

Use this for direct cell edits, formula updates, and simple workbook changes.

Reading Data with pandas

import pandas as pd

df = pd.read_excel('file.xlsx')                          # First sheet
all_sheets = pd.read_excel('file.xlsx', sheet_name=None) # All sheets as dict

Common Pitfalls

Cell indices are 1-based: ws.cell(row=1, column=1) is A1.
data_only=True destroys formulas on save: Use a separate workbook object for reading calculated values.
ws.max_row overcounts: May include formatted-but-empty rows. Scan the column to find the last non-empty cell when you need the true data range.