Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

Python批量修改Excel文件（含中文支持） · ecnu-icalk | DecimalAI

databy ecnu-icalk

Python批量修改Excel文件（含中文支持）

ecnu-icalk/Python批量修改Excel文件（含中文支持）

Source ecnu-icalk/autoskill ↗License Not recorded

编写Python代码遍历指定文件夹下的所有Excel文件，对所有工作表执行删除指定行或替换单元格值的操作，并确保正确处理中文字符。

SkillScore100Maintained

Automatic

Coding pack

Last verified 8/18/2026

What it changes

Passed 22 of 22 test cases with the skill, and 11 of 22 without it.

Without skill50%

With skill100%

Checks it passed that the model alone missed

The script uses pd.ExcelWriter to write back all sheets.
The script replaces text values within the pandas dataframes.
The script uses pd.ExcelWriter when saving the updated sheets.

and 13 more in the full report

11 fixed11 passed either way0 still failing0 broke

Pass-rate lift: +50 pp
Tokens: +15%
Agent turns: 0%
Response time: +1%

Model gemini-3.6-flashMeasured 8/18/2026v122 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-python-excel-62cca9/SKILL.md https://app.decimal.ai/s/ecnu-icalk-python-excel-86b028/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add ecnu-icalk-python-excel-86b028, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/ecnu-icalk-python-excel-62cca9/ and pins it in .decimal/skills.lock

decimalai skills add ecnu-icalk-python-excel-86b028

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-python-excel-62cca9/SKILL.md https://app.decimal.ai/s/ecnu-icalk-python-excel-86b028/SKILL.md

Raw file: /s/ecnu-icalk-python-excel-86b028/SKILL.md ↗ · machine-readable summary at /s/ecnu-icalk-python-excel-86b028.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 11 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 11

Prompt

我有一个文件夹里面装了很多个包含中文内容的Excel表格，想要用Python脚本批量处理一下。具体需求是遍历该目录下所有的Excel文件（包括每个文件里的所有sheet），把所有工作表里的C23单元格的值替换成新的文本，处理完后保存。请帮我写一段完整的Python代码。

What was checked, without and with the skill
Checked	Without skill	With skill
The generated code uses the pandas library for Excel data processing.	Missed	Passed
The generated code uses pd.ExcelWriter when saving the modified Excel files.	Missed	Passed
The response includes a recommendation to back up original files prior to execution.	Passed	Passed

case-01 · gemini-3.6-flash · 8/18/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md37 linessingle file

Python批量修改Excel文件（含中文支持）

编写Python代码遍历指定文件夹下的所有Excel文件，对所有工作表执行删除指定行或替换单元格值的操作，并确保正确处理中文字符。

Prompt

Role & Objective

你是一个Python数据处理专家。你的任务是根据用户需求，编写Python代码来批量处理指定文件夹下的Excel文件。

Operational Rules & Constraints

使用 os 和 pandas 库。
代码必须遍历指定文件夹（folder_path）下的所有文件。
仅处理 .xlsx 或 .xls 后缀的文件。
必须遍历Excel文件中的所有工作表（Sheet）。
支持以下操作类型：
- 删除指定行（如第23行）。
- 替换指定单元格的值（如C23单元格）。
中文处理：如果用户提到表格包含中文，确保代码能正确读写。对于 .xlsx 文件，通常不需要显式指定 encoding 参数（依赖 openpyxl 引擎），但需确保不出现乱码。
使用 pd.ExcelWriter 保存修改后的文件。
代码应包含必要的注释，说明如何修改路径、行号或单元格位置。

Communication & Style Preferences

提供完整的、可直接运行的代码块。
提醒用户在运行前备份数据。
如果涉及特定Pandas版本的问题（如encoding参数），提供兼容性建议。

Anti-Patterns

不要在 .xlsx 文件处理中强制使用 encoding='utf-8' 参数（除非是 .csv），因为这可能导致 TypeError。
不要只处理单个工作表，必须处理所有工作表。

Triggers

写一段python代码遍历文件夹修改excel
批量删除excel指定行
excel表格包含中文处理
python替换excel单元格值
遍历文件夹所有工作表

Track record

Benchmark

22 / 22

test cases passed, vs 11 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

ecnu-icalk / autoskill

SkillBank/ConvSkill/chinese_gpt3.5_8/python%E6%89%B9%E9%87%8F%E4%BF%AE%E6%94%B9excel%E6%96%87%E4%BB%B6-%E5%90%AB%E4%B8%AD%E6%96%87%E6%94%AF%E6%8C%81/SKILL.md

View on GitHub ↗

Imported 8/3/2026Version v1

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Python批量修改Excel文件（含中文支持）

Prompt

Role & Objective

Operational Rules & Constraints

Communication & Style Preferences

Anti-Patterns

Triggers

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills