📑
AutomationPython

Merge Excel Files

by CoderWanFeng

Merge Excel Files is an Automation skill for Claude Code, published by CoderWanFeng in python-office.

1.3K stars299 forkson CoderWanFeng/python-officeAdded 2026/07/20Repository updated 2026/08/04
View source on GitHubDownload repo ZIP
officepippypipythonweixin
Install in seconds
Install Merge Excel Files
Copy Merge Excel Files into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/CoderWanFeng/python-office/tree/develop/skills/excel/merge2excel ~/.claude/skills/merge2excel

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/CoderWanFeng/python-office.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
skills/excel/merge2excel/SKILL.md in CoderWanFeng/python-office
Installs to
~/.claude/skills/merge2excel
Collection
One of 50 skills cataloged from this repository
Category
Automation — 2226 skills

What Merge Excel Files does

Merges multiple Excel files from a directory into a single Excel workbook, with each original file placed in a separate sheet. Use it when you need to combine several spreadsheets into one file for easier management.

Merge Excel Files is cataloged under Automation on DirSkills. Merge Excel Files comes from a repository tagged office, pip, pypi, python and weixin.

Documentation

README

merge2excel Skill

将多个 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

Frequently asked about Merge Excel Files

  • What else does CoderWanFeng publish alongside Merge Excel Files?

    Merge Excel Files is one of 50 skills that DirSkills catalogs from CoderWanFeng/python-office, the repository it ships in. Its siblings there include Add Image Watermark, Add Line by Type and Add Text Watermark. Each one is a separate skill with its own page in this directory, installs the same way Merge Excel Files does, and is maintained by CoderWanFeng in that same repository. The rest of the collection is listed on the CoderWanFeng/python-office page.

  • How does Merge Excel Files compare to other Automation skills?

    Merge Excel Files ranks #661 by stars among the 2226 Automation skills in this catalog. The most-starred ones next to it are Autonomous Loops, Autonomous Agent Harness and Automation Audit Ops. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Merge Excel Files against them. Open each page to compare what they document and how they install.

More from CoderWanFeng/python-office

Merge Excel Files is one of 50 skills cataloged on DirSkills from CoderWanFeng/python-office.

See all 50 skills →
🖼️
2026/08/12

Add Image Watermark

Add Image Watermark adds an image watermark to a PDF, such as a logo. Use it when you need to brand or mark PDF pages with an image watermark.
Automation
1.3K301
📝
2026/07/20

Add Line by Type

Add configured code lines to a selected file with python-office, with an explicit warning that this historical function remains untested.
Automation
1.3K299
💧
2026/08/12

Add Text Watermark

Add Text Watermark adds text watermarks to PDF files with custom font, size, color, and position. Use it when you need to mark a PDF with labels like confidential or draft.
Automation
1.3K301
🖼️
2026/07/20

Add Watermark

Adds text watermarks to images with customizable color, size, opacity, spacing, and angle. Use when you need to batch watermark images for copyright or branding.
Automation
1.3K299
💧
2026/08/12

Add Watermark

Add Watermark adds a watermark to a PDF through an interactive, no-argument call. Use it when a user wants to apply a watermark to a PDF document.
Automation
1.3K301
🏷️
2026/07/20

Batch Add Filename Prefix

Add a specified prefix to filenames in bulk. Useful for organizing files with a common prefix, like adding 'backup_' to document names.
Automation
1.3K299

More Automation skills

Merge Excel Files is one of 2226 Automation skills cataloged on DirSkills, ranked #661 by stars among them.

Browse all Automation skills →
🔁
4w ago

Autonomous Loops

Autonomous Loops provides patterns and reference implementations for running Claude Code in autonomous loops, from simple sequential pipelines to RFC-driven multi-agent DAG systems. Retained for compatibility; use continuous-agent-loop for new guidance.
Automation
239.8K36.4K
🤖
4w ago

Autonomous Agent Harness

Autonomous Agent Harness turns Claude Code into a self-directing agent system with persistent memory, scheduled tasks, computer use, and task queuing. Use it when continuous autonomous operation, scheduled tasks, or self-directing agent loops are needed.
Automation
239.8K36.4K
🔍
4w ago

Automation Audit Ops

Automation Audit Ops audits live automations, jobs, hooks, and connectors to identify what is working, broken, redundant, or missing before any fixes are made.
Automation
239.8K36.4K