Menu
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/CoderWanFeng/python-office --skill split-excel-by-columnThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Based on SOC occupation classification
Showing SKILL.md
| name | split_excel_by_column |
| description | 按指定列的内容拆分 Excel 文件，每个唯一值一个文件。当用户提到按列拆分 Excel、按字段拆分表格时使用。 |
按指定列的内容拆分 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