Agent skill

Merge2excel

by CoderWanFeng in CoderWanFeng/python-office

将多个 Excel 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。

Apache-2.0Auto-check passedDocuments & Office

Install Merge2excel

skills CLI
$ npx skills add CoderWanFeng/python-office --skill merge2excel -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install CoderWanFeng/python-office merge2excel --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/CoderWanFeng/python-office.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/excel/merge2excel .claude/skills/merge2excel && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
merge2excel
GitHub stars
1.4k
Token cost
~216 tokens
SKILL.md length
45 words
Files
2
Skills in repo
39
Repo updated
First seen
Licence
Apache-2.0

At a glance

将多个 Excel 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。

  • Tasks that involve Excel spreadsheets
  • SKILL.md covers 功能描述, 所属分类, 调用方式 and 参数说明, plus 4 more sections
  • Runs Python scripts from its folder

What it does

Merge2excel is an agent skill from CoderWanFeng/python-office. 将多个 Excel 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。

Its SKILL.md is about 220 tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `__init__.py`).

It sits in Documents & Office, covering Excel spreadsheets. It works with Microsoft Excel. The repository describes itself as: pip install python-office 自动化办公专用库. The licence is Apache-2.0.

When your agent uses it

  • Tasks that involve Excel spreadsheets

Example prompts

  • “/merge2excel”

Requirements

  • Python 3

What it can do on your machine

Read from SKILL.md and the folder at commit dd6fe56. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships script files (Python), which the agent can run.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • bilibili.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Merge2excel loads about 216 tokens when it runs. Until then it costs about 21 tokens; SKILL.md has 45 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~21
When it runs · the whole SKILL.md, loaded when a task matches
~216

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from CoderWanFeng/python-office at commit dd6fe56, republished under its Apache-2.0 licence (© CoderWanFeng). 45 words, ~216 tokens.

Download SKILL.mdSave it as .claude/skills/merge2excel/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
merge2excel
description
将多个 Excel 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。

merge2excel Skill

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

功能描述

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

所属分类

office/skills/excel/merge2excel/

调用方式

python
from skills.excel import merge2excel

merge2excel(
    dir_path='./excel_files',
    output_file='./merge2excel.xlsx'
)

参数说明

参数类型必填默认值说明
dir_pathstr是-包含多个 Excel 文件的目录路径
output_filestr否'merge2excel.xlsx'合并后的 Excel 文件路径

返回值

None

使用示例

python
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

© CoderWanFeng, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file in skills/excel/merge2excel of CoderWanFeng/python-office.

  • SKILL.md
  • __init__.py

Open the folder on GitHubat commit dd6fe56

Compare with similar skills

Merge2excel next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Merge2excel compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Merge2excel this skillCoderWanFeng/python-office1.4k—~216Automated safety check: PassApache-2.0
MarkitdownImCa0/just-laws78114 repos~3.2kAutomated safety check: NotesMIT
Data Table Managern8n-io/n8n207k—~2.3kAutomated safety check: PassCustom licence
Docx4jplutext/docx4j2.4k—~2.5kAutomated safety check: PassNone
Instrument Data To Allotropeaws-samples/amazon-bedrock-agents-healthcare-lifesciences2742 repos~2.7kAutomated safety check: PassApache-2.0
Cyber Pptcrazyykhllc-bit/CyberPPT1.8k—~10kAutomated safety check: PassMIT

Similar skills

  • Markitdown

    ImCa0/just-laws

    Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.

    781 GitHub starsUsed in 14 repos~3.2k tokens
    Documents & OfficeAuto-check: notes
  • Official

    Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.

    207k GitHub stars~2.3k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Docx4j

    plutext/docx4j

    A skill your agent uses when writing Java code that creates, reads or edits Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) files with docx4j — including generating documents, editing existing…

    2.4k GitHub stars~2.5k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Instrument Data To Allotrope

    aws-samples/amazon-bedrock-agents-healthcare-lifesciences

    Official

    Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.

    274 GitHub starsUsed in 2 repos~2.7k tokens
    Documents & OfficeAuto-check passed
  • Cyber Ppt

    crazyykhllc-bit/CyberPPT

    当用户需要把 DOCX、PDF、TXT、XLSX、研究报告、业务材料或原始数据转成高密度、可编辑、咨询风格 PPTX 时使用;也适用于需要 SCR 论证、视觉风格探索、详细图表和渲染质检的 PPT。

    1.8k GitHub stars~10k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • Markit

    shift-labs-ai/markit

    Convert files and URLs to Markdown. An agent skill from shift-labs-ai/markit.

    1.3k GitHub stars~299 tokensUpdated 1 mo ago
    Documents & OfficeAuto-check passed

More from CoderWanFeng/python-office

All 39 skills in this repo
  • Audio2txt

    CoderWanFeng/python-office

    从音频文件中提取文字(语音转文字),需要腾讯云 API 凭据。当用户提到音频转文字、语音识别、ASR、音频转字幕时使用。

    1.4k GitHub stars~230 tokensUpdated 1 mo ago
    Auto-check passed
  • Decrypt4pdf

    CoderWanFeng/python-office

    对加密的 PDF 文件进行解密。当用户提到 PDF 解密、解除 PDF 密码、解 PDF 时使用. An agent skill from CoderWanFeng/python-office.

    1.4k GitHub stars~242 tokensUpdated 1 mo ago
    Auto-check passed
  • Del4pdf

    CoderWanFeng/python-office

    删除 PDF 文件中指定的页面。当用户提到 PDF 删除页、PDF 删页、删 PDF 页 时使用. An agent skill from CoderWanFeng/python-office.

    1.4k GitHub stars~209 tokensUpdated 1 mo ago
    Auto-check passed
  • Doc2docx

    CoderWanFeng/python-office

    将旧版 Word 文档(.doc)转换为新版(.docx)。当用户提到 doc 转 docx、旧 Word 转新 Word 时使用。

    1.4k GitHub stars~269 tokensUpdated 1 mo ago
    Auto-check passed
  • Docx2doc

    CoderWanFeng/python-office

    将新版 Word 文档(.docx)转换为旧版(.doc)。当用户提到 docx 转 doc、新 Word 转旧 Word 时使用。

    1.4k GitHub stars~196 tokensUpdated 1 mo ago
    Auto-check passed
  • Docx2pdf

    CoderWanFeng/python-office

    将 Word 文档(.docx)转换为 PDF,支持单文件和整个文件夹批量转换。当用户提到 Word 转 PDF、docx 转 PDF 时使用。

    1.4k GitHub stars~197 tokensUpdated 1 mo ago
    Auto-check passed

Works with

Questions about Merge2excel

What does Merge2excel do?

将多个 Excel 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。. Merge2excel is an agent skill from CoderWanFeng/python-office.

When should I use Merge2excel?

Merge2excel fits situations like: tasks that involve Excel spreadsheets.

How do I install Merge2excel in Claude Code?

Run `npx skills add CoderWanFeng/python-office --skill merge2excel -a claude-code`. Or copy the skill folder (skills/excel/merge2excel in CoderWanFeng/python-office) into .claude/skills/merge2excel in your project. Claude Code loads it when a task matches its description.

How do I install Merge2excel in Codex?

Run `npx skills add CoderWanFeng/python-office --skill merge2excel -a codex`. Or copy the skill folder (skills/excel/merge2excel in CoderWanFeng/python-office) into .agents/skills/merge2excel in your project. Codex loads it when a task matches its description.

Can I use Merge2excel in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add CoderWanFeng/python-office --skill merge2excel -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/merge2excel, .gemini/skills/merge2excel, .github/skills/merge2excel and .opencode/skills/merge2excel in your project.

What does Merge2excel need to run?

Going by SKILL.md and its folder, Merge2excel needs Python for the scripts in its folder. Our summary lists: Python 3.

Does Merge2excel access the network?

SKILL.md names 1 domain. As links in the text: bilibili.com. This is read from the text; nothing was executed.

Is Merge2excel safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Merge2excel use?

Merge2excel is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Merge2excel use?

About 216 tokens (SKILL.md is roughly 864 characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Merge2excel?

Skills that share tags, products or a category with Merge2excel: Markitdown (ImCa0/just-laws, 781 stars), Data Table Manager (n8n-io/n8n, 207k stars), Docx4j (plutext/docx4j, 2.4k stars) and Instrument Data To Allotrope (aws-samples/amazon-bedrock-agents-healthcare-lifesciences, 274 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Merge2excel?

CoderWanFeng (a GitHub user) maintains it in CoderWanFeng/python-office, which has 1,359 GitHub stars. The repository holds 39 skills in this directory. The repository was last updated on August 19, 2026.

Source: CoderWanFeng/python-office on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.