Install in seconds

Install this skill

Copy the command and run it in your terminal. You can review the source before installing.

terminal

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

Works with Git. The repository opens in your current directory.

📊

DataPython

Merge Excel Files

by CoderWanFeng

Merges all Excel files in a directory into a single Excel file, with each original file becoming a separate sheet. Useful for consolidating multiple Excel workbooks.

1.3K stars297 forksAdded 2026/07/20

View source on GitHub Download ZIP

officepippypipythonweixin

Documentation

README

From the original repository

merge2excel Skill

将多个 Excel 文件合并到一个 Excel 的不同 sheet 中

功能描述

将指定目录下的所有 Excel 文件合并到一个新的 Excel 文件中，每个原始文件对应一个新 sheet。

所属分类

office/skills/excel/merge2excel/

调用方式

from office.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 office.skills.excel import merge2excel
merge2excel(dir_path='./excels', output_file='./all_in_one.xlsx')

视频教程

https://www.bilibili.com/video/BV1Th4y1Y7kd/

原始函数

office.api.excel.merge2excel

More from CoderWanFeng

Other Claude Code skills by this author in the directory.

Excel to PDF

Converts a specified worksheet from an Excel file to a PDF file. Use when you need to export Excel data as a PDF document.

Fake2Excel

Automatically creates Excel files filled with mock data for testing. Supports multiple column types (name, phone, address) and Chinese/English locales.

Find Excel Data

Search for a specified keyword across all Excel files in a directory and return the matching file names, row numbers, and content details.

Merge to Sheet

A Python utility that merges all sheets from multiple Excel files into a single sheet. Useful for consolidating data from various workbooks into one unified table.

Sheet2Excel

Splits multiple sheets of a single Excel file into separate individual Excel files. Use when you need to split an Excel workbook by sheet.

Split Excel by Column

Splits an Excel file into multiple files based on the contents of a specified column, creating one file per unique value. Use when you need to split Excel data by a column field.

More Data skills

Merge Excel Files is one of 44 Data skills cataloged on DirSkills.

Browse all Data skills →

A/B Test Setup

A structured step-by-step guide for setting up valid A/B tests, enforcing hypothesis locking, statistical power, and metric definition before implementation. Use when you need a rigorous experimentation framework to avoid peeking and invalid results.

Ad Campaign Analyzer

Analyze cross-channel campaign data, quantify uncertainty, and propose evidence-labeled budget tests without overstating causality.

Analytics Tracking

Implements event tracking scripts and validates data collection for marketing analytics. Use when setting up analytics on websites or applications.