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 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。
将多个 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')
https://www.bilibili.com/video/BV1Th4y1Y7kd/
office.api.excel.merge2excel
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