merge2sheet

A Python function that combines sheets from multiple Excel files into one sheet in a new workbook. Excel is a spreadsheet format commonly used for tables and records.

In plain words
What is it for?
Use it to merge all sheets in a folder of Excel files and choose the output sheet and file names.
Why use it?
It removes repetitive copy-and-paste work when consolidating data from several workbooks into one table.

Skill for Claude CodeCodex

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/coderwanfeng/python-office/merge2sheet
Any agent
npx skills add CoderWanFeng/python-office --skill merge2sheet
Clone the repo
git clone --depth 1 https://github.com/CoderWanFeng/python-office

Made for: Claude Code, Codex.

Per session 38 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 317 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00038 $0.00317
Opus 5 $0.00019 $0.00159
Sonnet 5 $0.00008 $0.00063
Haiku 4.5 $0.00004 $0.00032

Measured yesterday against content hash df804b938ec9, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

merge2sheet scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

The scan reads SKILL.md. This mod also ships 1 executable file (__init__.py), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/excel/merge2sheet/SKILL.md · 52 lines

What it actually says

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

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday First seen · 52 lines · 38 tokens per session scan A df804b938ec9

Subscribe to this mod's changes

merge2sheet is a skill published in the GitHub repository CoderWanFeng/python-office (1,346 stars, last pushed 12d ago), licensed Apache-2.0. It adds 38 tokens to every session and 317 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

jmcomic

Search, browse, inspect album-specific or site-wide comments, and download manga from JMComic (18comic), obtain the latest Android APK from hect0x7/JMComic-APK, and invoke the upstream jm-view-server jms command for local reading. Use for manga discovery, ranking, comment analysis, downloads, post-processing…

hect0x7/jmcomic-ai · 101 tokens

mind-mem-development

MIND-Mem Python development guide.

star-ga/mind-mem · 12 tokens

buero

Ordnet Büroaufgaben, Korrespondenz und Fristen ohne Bindung an eine bestimmte Office-App.

ellmos-ai/skills · 26 tokens

python-runtime

Use this skill when the user needs to install, upgrade, or troubleshoot Python and pip environments. Covers four-tier fallback strategy: (1) DesireCore HTTP API for in-app installation, (2) DesireCore built-in Hatch CLI for Python version management, (3) system package managers (brew/apt/dnf/winget), (4) community…

desirecore/market · 228 tokens

bump-dependency

Bumps a Python package dependency across Home Assistant Core integrations, regenerates core requirement files, runs verification tests and prek lint, and prepares a pull request with proper release/compare links.

home-assistant/core · 42 tokens

schema-exploration

Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.

langchain-ai/deepagents · 57 tokens