splitexcelbycolumn Skill
SkillFiles & storageSplits an Excel file by the contents of a specified column, producing one file per unique value. Use when the user mentions splitting Excel by column or splitting a table by field.
Use splitexcelbycolumn Skill in Claude, ChatGPT or Ahel Desktop
Free. Sign in, add splitexcelbycolumn Skill and connect your AI. About a minute.
Also: Claude Code · Cursor · Codex
Then ask your AI: use the splitexcelbycolumn Skill skill
Details
Instructions available. Your AI can read the instructions. Execution depends on the setup they require.
Account requirements not reviewed. Check the skill instructions before use; ahel provides instructions and does not run this skill.
No other account needed.
Add ahel to your AI once: Claude, ChatGPT, Cursor, Claude Code or Codex. Then ask it to use this.
What this skill tells your AI
The instructions your AI receives, as published by coderwanfeng/python-office in skills/excel/split_excel_by_column/SKILL.md and read by ahel’s review.
按指定列的内容拆分 Excel 文件
功能描述
根据指定列的内容，将一个 Excel 文件拆分为多个 Excel 文件，每个唯一值对应一个新文件。
所属分类
office/skills/excel/split_excel_by_column/
调用方式
from skills.excel import split_excel_by_column
split_excel_by_column(
filepath='./data.xlsx',
column=0,
worksheet_name=None
)
参数说明
| 参数 | 类型 | 必填 | 默认值 | 说明 |
|---|---|---|---|---|
filepath | str | 是 | - | 需要拆分的 Excel 文件路径 |
column | int | 是 | - | 按哪一列的内容进行拆分（列索引） |
worksheet_name | str | 否 | None | 指定工作表名称。默认处理第一个工作表 |
返回值
None
使用示例
from skills.excel import split_excel_by_column
# 按第 0 列拆分
split_excel_by_column(filepath='./orders.xlsx', column=0)
原始函数
office.api.excel.split_excel_by_column
Signals
- GitHub stars
- 1k
- Forks
- 303
- Last commit
- Aug 2026
Advanced
- Item type
- skill
- Key
split-excel-by-column- Source
- github.com/coderwanfeng/python-office
github.com/coderwanfeng/python-office