Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →coderwanfeng/split_excel_by_column
按指定列的内容拆分 Excel 文件，每个唯一值一个文件。当用户提到按列拆分 Excel、按字段拆分表格时使用。
Passed 20 of 22 test cases with the skill, and 3 of 22 without it.
and 16 more in the full report
17 fixed3 passed either way2 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 17 test cases the skill fixed. Same model, same prompt, with and without the skill.
How do I split `./user_logs.xlsx` by the very first column (index 0) on the default worksheet using the office excel skill?
| Checked | Without skill | With skill |
|---|---|---|
| Calls split_excel_by_column(filepath='./user_logs.xlsx', column=0). | Missed | Passed |
The instructions your model reads when the skill loads.
按指定列的内容拆分 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
test cases passed, vs 3 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.