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 merge2sheetThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Showing SKILL.md
| name | merge2sheet |
| description | 将多个 Excel 文件的多个 sheet 合并到同一个 sheet。当用户提到合并 sheet、跨表合并、汇总多个表格时使用。 |
自动合并多个 Excel 文件的多个 sheet
将多个 Excel 文件中的所有 sheet 合并到同一个 Excel 文件的同一个 sheet 中。
office/skills/excel/merge2sheet/
from skills.excel import merge2sheet
merge2sheet(
dir_path='./excels',
output_sheet_name='Sheet1',
output_excel_name='merge2sheet'
)
| 参数 | 类型 | 必填 | 默认值 | 说明 |
|---|---|---|---|---|
dir_path | str | 是 | - | 包含多个 Excel 文件的目录路径 |
output_sheet_name | str | 否 | 'Sheet1' | 合并后的 sheet 名称 |
output_excel_name | str | 否 | 'merge2sheet' | 合并后的 Excel 文件名 |
None
from skills.excel import merge2sheet
merge2sheet(dir_path='./my_excels', output_sheet_name='AllData', output_excel_name='all_merged')
office.api.excel.merge2sheet
Based on SOC occupation classification
