merge2sheet
将多个 Excel 文件的多个 sheet 合并到同一个 sheet。当用户提到合并 sheet、跨表合并、汇总多个表格时使用。
65
Quality
77%
Does it follow best practices?
Run evals on this skill
Adds up to 20 points to the overall score
View guide
Securityby
Passed
No findings from the security scan
Fix and improve this skill with Tessl
tessl review fix ./skills/excel/merge2sheet/SKILL.mdmerge2sheet Skill
自动合并多个 Excel 文件的多个 sheet
功能描述
将多个 Excel 文件中的所有 sheet 合并到同一个 Excel 文件的同一个 sheet 中。
所属分类
office/skills/excel/merge2sheet/
调用方式
from office.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 office.skills.excel import merge2sheet
merge2sheet(dir_path='./my_excels', output_sheet_name='AllData', output_excel_name='all_merged')原始函数
office.api.excel.merge2sheet
- Repository
- CoderWanFeng/python-office
- Commit
2b1996b
- Last updated
- First committed
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.