Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →将多个 Excel 文件的多个 sheet 合并到同一个 sheet。当用户提到合并 sheet、跨表合并、汇总多个表格时使用。
| Test case | Without → With | Effect | Δ tokens | Δ turns |
|---|---|---|---|---|
| case-01 | ✗→✓ | ▲ Improved | -65% | 0% |
| case-02 | ✗→✓ | ▲ Improved | -59% | 0% |
| case-03 | ✗→✓ | ▲ Improved | -54% | 0% |
| case-04 | ✗→✓ | ▲ Improved | -48% | 0% |
| case-05 | ✗→✓ | ▲ Improved | -45% | 0% |
> 自动合并多个 Excel 文件的多个 sheet
将多个 Excel 文件中的所有 sheet 合并到同一个 Excel 文件的同一个 sheet 中。
office/skills/excel/merge2sheet/
pythonfrom 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
pythonfrom skills.excel import merge2sheet merge2sheet(dir_path='./my_excels', output_sheet_name='AllData', output_excel_name='all_merged')
office.api.excel.merge2sheet
Other measured skills in the registry, with their headline benchmark lift.