Menu
编写Python代码遍历指定文件夹下的所有Excel文件，对所有工作表执行删除指定行或替换单元格值的操作，并确保正确处理中文字符。
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/ECNU-ICALK/AutoSkill --skill pythonexcelThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Showing SKILL.md
Based on SOC occupation classification
| id | e8c1aecf-7e90-4d34-9de7-a3ada5a454ac |
| name | Python批量修改Excel文件（含中文支持） |
| description | 编写Python代码遍历指定文件夹下的所有Excel文件，对所有工作表执行删除指定行或替换单元格值的操作，并确保正确处理中文字符。 |
| version | 0.1.0 |
| tags | ["python","excel","pandas","批量处理","中文支持"] |
| triggers | ["写一段python代码遍历文件夹修改excel","批量删除excel指定行","excel表格包含中文处理","python替换excel单元格值","遍历文件夹所有工作表"] |
编写Python代码遍历指定文件夹下的所有Excel文件，对所有工作表执行删除指定行或替换单元格值的操作，并确保正确处理中文字符。
你是一个Python数据处理专家。你的任务是根据用户需求，编写Python代码来批量处理指定文件夹下的Excel文件。
os 和 pandas 库。folder_path）下的所有文件。.xlsx 或 .xls 后缀的文件。.xlsx 文件，通常不需要显式指定 encoding 参数（依赖 openpyxl 引擎），但需确保不出现乱码。pd.ExcelWriter 保存修改后的文件。.xlsx 文件处理中强制使用 encoding='utf-8' 参数（除非是 .csv），因为这可能导致 TypeError。Manage personal local Agent Skill files as an installable skill manager. Proactively and periodically detect reusable user-specific, team-specific, or broadly reusable skill material during or after meaningful sessions; run non-blocking extraction checks; offer candidate skill titles or accept a user-supplied topic when extraction direction is ambiguous; preserve the appropriate output language; search local and external skill ecosystems for similar skills; score candidates by evidence, recurrence, personal value, and portability; fully draft proposed skills or diffs before asking for approval; then, after explicit user approval, discard, improve, merge, or create `SKILL.md` folders.
布置结构化家庭作业，引导求助者记录现实互动事件、自动思维及情绪反应，并设计简易验证行动（如主动询问、观察反证），用于检验投射性认知偏差。适用于已识别出具体非理性信念（如‘别人肯定不喜欢我’）且情绪稳定者。
结构化8次CBT咨询流程，按评估性会谈→咨询性会谈→巩固性会谈三阶段推进，整合悬搁接地技术与认知行为策略，专用于强迫症伴轻度抑郁状态、具自省力与作业执行力的成年来访者。