Agent skill

Merge2sheet

by CoderWanFeng in CoderWanFeng/python-office

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

Apache-2.0Auto-check passedDocuments & Office

Install Merge2sheet

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

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

GitHub CLI
$ gh skill install CoderWanFeng/python-office merge2sheet --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/merge2sheet .claude/skills/merge2sheet && 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
merge2sheet
GitHub stars
1.4k
Token cost
~226 tokens
SKILL.md length
50 words
Files
2
Skills in repo
39
Repo updated
First seen
Licence
Apache-2.0

At a glance

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

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

What it does

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

Its SKILL.md is about 230 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

  • “/merge2sheet”

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

    No URLs in SKILL.md.

    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

Merge2sheet loads about 226 tokens when it runs. Until then it costs about 19 tokens; SKILL.md has 50 words of instructions outside code blocks.

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

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). 50 words, ~226 tokens.

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

merge2sheet Skill

自动合并多个 Excel 文件的多个 sheet

功能描述

将多个 Excel 文件中的所有 sheet 合并到同一个 Excel 文件的同一个 sheet 中。

所属分类

office/skills/excel/merge2sheet/

调用方式

python
from skills.excel import merge2sheet

merge2sheet(
    dir_path='./excels',
    output_sheet_name='Sheet1',
    output_excel_name='merge2sheet'
)

参数说明

参数类型必填默认值说明
dir_pathstr是-包含多个 Excel 文件的目录路径
output_sheet_namestr否'Sheet1'合并后的 sheet 名称
output_excel_namestr否'merge2sheet'合并后的 Excel 文件名

返回值

None

使用示例

python
from skills.excel import merge2sheet
merge2sheet(dir_path='./my_excels', output_sheet_name='AllData', output_excel_name='all_merged')

原始函数

office.api.excel.merge2sheet

© 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/merge2sheet of CoderWanFeng/python-office.

  • SKILL.md
  • __init__.py

Open the folder on GitHubat commit dd6fe56

Compare with similar skills

Merge2sheet 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.

Merge2sheet compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Merge2sheet this skillCoderWanFeng/python-office1.4k—~226Automated 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 Merge2sheet

What does Merge2sheet do?

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

When should I use Merge2sheet?

Merge2sheet fits situations like: tasks that involve Excel spreadsheets.

How do I install Merge2sheet in Claude Code?

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

How do I install Merge2sheet in Codex?

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

Can I use Merge2sheet 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 merge2sheet -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/merge2sheet, .gemini/skills/merge2sheet, .github/skills/merge2sheet and .opencode/skills/merge2sheet in your project.

What does Merge2sheet need to run?

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

Does Merge2sheet access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Merge2sheet 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 Merge2sheet use?

Merge2sheet 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 Merge2sheet use?

About 226 tokens (SKILL.md is roughly 904 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 Merge2sheet?

Skills that share tags, products or a category with Merge2sheet: 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 Merge2sheet?

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.