📊
DataPython

Merge to Sheet

by CoderWanFeng

Merge to Sheet is a Data 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 to Sheet
Copy Merge to Sheet 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/merge2sheet ~/.claude/skills/merge2sheet

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/merge2sheet/SKILL.md in CoderWanFeng/python-office
Installs to
~/.claude/skills/merge2sheet
Collection
One of 50 skills cataloged from this repository
Category
Data — 812 skills

What Merge to Sheet does

Merges multiple sheets from multiple Excel files into a single sheet. Use when combining data across spreadsheets.

Merge to Sheet is cataloged under Data on DirSkills. Merge to Sheet comes from a repository tagged office, pip, pypi, python and weixin.

Documentation

README

merge2sheet Skill

自动合并多个 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

Frequently asked about Merge to Sheet

  • What else does CoderWanFeng publish alongside Merge to Sheet?

    Merge to Sheet 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 to Sheet 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 to Sheet compare to other Data skills?

    Merge to Sheet ranks #414 by stars among the 812 Data skills in this catalog. The most-starred ones next to it are Benchmark Methodology, Jupyter Notebook and Solana. 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 to Sheet against them. Open each page to compare what they document and how they install.

More from CoderWanFeng/python-office

Merge to Sheet 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 Data skills

Merge to Sheet is one of 812 Data skills cataloged on DirSkills, ranked #414 by stars among them.

Browse all Data skills →
📊
4w ago

Benchmark Methodology

Benchmark Methodology scores competitors across nine weighted dimensions using explicit 1–5 rubrics and a tension plot. Use it after competitive-platform-analysis to produce comparable, evidence-anchored profile cards for a competitive report.
Data
239.8K36.4K
📓
4w ago

Jupyter Notebook

Jupyter Notebook provides a stateful Python REPL via a live Jupyter kernel (hamelnb) so variables persist across executions. Use it for iterative data exploration, API inspection, and complex code development.
Data
229.7K45.3K
🪙
4w ago

Solana

Solana queries wallets, token holdings, transactions, NFTs, whale transfers, and network stats on the Solana blockchain with USD pricing via CoinGecko. Use it when you need to inspect an address, verify a transaction, check token metadata or prices, or monitor network health.
Data
229.7K45.3K