Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →coderwanfeng/merge2excel
将多个 Excel 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。
Passed 22 of 22 test cases with the skill, and 3 of 22 without it.
and 38 more in the full report
19 fixed3 passed either way0 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 19 test cases the skill fixed. Same model, same prompt, with and without the skill.
Inside `./project_logs/2023`, I have 12 individual Excel workbooks. Write a short Python snippet to combine all of them into a single file named `./combined_2023_logs.xlsx` with separate tabs for each month.
| Checked | Without skill | With skill |
|---|---|---|
| The code imports merge2excel from skills.excel. | Missed | Passed |
| The function call sets dir_path to './project_logs/2023'. | Missed | Passed |
| The function call sets output_file to './combined_2023_logs.xlsx'. | Missed | Passed |
The instructions your model reads when the skill loads.
将多个 Excel 文件合并到一个 Excel 的不同 sheet 中
将指定目录下的所有 Excel 文件合并到一个新的 Excel 文件中，每个原始文件对应一个新 sheet。
office/skills/excel/merge2excel/
from skills.excel import merge2excel
merge2excel(
dir_path='./excel_files',
output_file='./merge2excel.xlsx'
)
| 参数 | 类型 | 必填 | 默认值 | 说明 |
|---|---|---|---|---|
dir_path | str | 是 | - | 包含多个 Excel 文件的目录路径 |
output_file | str | 否 | 'merge2excel.xlsx' | 合并后的 Excel 文件路径 |
None
from skills.excel import merge2excel
merge2excel(dir_path='./excels', output_file='./all_in_one.xlsx')
test cases passed, vs 3 / 22 without
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.