Skip to content
Automation
Skill

/sheet2excel

将同一个 Excel 文件的多个 sheet 拆分为独立文件。当用户提到拆分 sheet、Excel 按表拆分、拆 sheet 时使用。

BOOST
From plugin
python-office
1.4k74 skills
Install
$ npx -y skills add coderwanfeng/python-office --skill sheet2excel --agent claude-code

How it fires

How this skill gets triggered: by you, by Claude, or both.

  • Fires itselfAuto-invocation. Claude auto-loads it when your prompt matches the work.Auto-invocation is when the right skill fires by itself at the right moment, driven by a FLOW.md router and a hook, instead of you invoking it by name. It is the difference between a skill being installed and a skill actually getting used.Read the full definition →
  • You can call itInvoke it directly when you want it.
  • Slash command/sheet2excel

Context preview

The summary Claude sees to decide when to auto-load this skill.

将同一个 Excel 文件的多个 sheet 拆分为独立文件。当用户提到拆分 sheet、Excel 按表拆分、拆 sheet 时使用。

SKILL.md

sheet2excel.SKILL.md
name: sheet2excel
description: 将同一个 Excel 文件的多个 sheet 拆分为独立文件。当用户提到拆分 sheet、Excel 按表拆分、拆 sheet 时使用。

sheet2excel Skill

> 将同一个 Excel 里的不同 sheet 拆分为不同的 Excel 文件

功能描述

将一个包含多个 sheet 的 Excel 文件,按 sheet 拆分为多个独立的 Excel 文件。

所属分类

`office/skills/excel/sheet2excel/`

调用方式

from skills.excel import sheet2excel

sheet2excel(
    file_path='./multi_sheet.xlsx',
    output_path='./output/'
)

参数说明

| 参数 | 类型 | 必填 | 默认值 | 说明 | |------|------|------|--------|------| | `file_path` | str | 是 | - | 需要拆分的 Excel 文件路径 | | `output_path` | str | 否 | `'./'` | 拆分后文件的输出目录 |

返回值

`None`

使用示例

from skills.excel import sheet2excel
sheet2excel(file_path='./data.xlsx', output_path='./split_output/')

视频教程

https://www.bilibili.com/video/BV1714y147Ao/

原始函数

`office.api.excel.sheet2excel`

Ships withpython-office

pip install python-office 自动化办公专用库

Get the whole plugin
Stats
1,358
Stars
303
Forks
Maintained
Maintenance
Python
Language
Apache-2.0
License
1mo ago
Last commit
4y ago
Created
1d ago
Added

Repo: coderwanfeng/python-office

Other skills on python-office.