Read and edit PDFs: extract text and tables, merge, split, rotate, and fill forms.
ANanthropics/skills181k1,119 new stars in the last 7 days
将多个 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
Read and edit PDFs: extract text and tables, merge, split, rotate, and fill forms.
ANanthropics/skills181k1,119 new stars in the last 7 days
Create posters and visual art as PNG or PDF, guided by a design philosophy.
ANanthropics/skills181k1,119 new stars in the last 7 days
Create and edit Word docs with TOC, page numbers, headers and more.
ANanthropics/skills181k1,119 new stars in the last 7 days
Co-write specs, proposals and decision docs through a structured, iterative workflow.
ANanthropics/skills181k1,119 new stars in the last 7 days
Read and edit spreadsheets: add columns, compute formulas, format, and clean messy data.
ANanthropics/skills181k1,119 new stars in the last 7 days
Create and edit slide decks, generate slides from templates, and extract text.
ANanthropics/skills181k1,119 new stars in the last 7 days