Office Automation

科特船长 - 办公自动化脚本，Excel/Word/文件批量处理

Security Scan

The skill appears to do what it claims (local office-file processing) and requests only Python, but the docs and code have minor mismatches you should check before use.

Purpose & Capability

Name/description (office automation: Excel/Word/PDF/rename/email) align with the included Python script which implements Excel merge, PDF merge, Word replace, and file rename. However SKILL.md advertises additional operations (email-send, excel-split, pdf-split, word-batch) and example CLI flags that do not clearly match the functions visible in the provided code excerpt — this mismatch should be verified (the file was truncated in the listing). No unrelated credentials or cloud services are requested.

Instruction Scope

Runtime instructions in SKILL.md direct the agent to operate on local files/folders and provide CLI examples; the Python code likewise scans local directories, reads/writes files, and writes local reports. There are no instructions or code paths shown that read unrelated system config, environment secrets, or send data to external endpoints. Note: SKILL.md includes an 'email-send' example that would imply network/email access; that functionality was not obvious in the visible code and should be confirmed before running.

Install Mechanism

No install spec is present (instruction-only at registry level). The skill requires only python3 on PATH; runtime optional Python packages (pandas, openpyxl, pypdf, python-docx) are imported if available and instructions tell users how to pip-install them. There are no downloads/archives or third‑party install URLs in the package.

Credentials

The skill declares no required environment variables, credentials, or config paths. SKILL.md and the script accept local config/file paths (e.g., --config for email) but do not demand secrets from the environment. This is proportionate to the stated file-processing purpose.

Persistence & Privilege

always is false and the skill is user-invocable with normal autonomous invocation allowed. The skill does not request persistent system-wide privileges or modify other skills. This level of persistence and privilege is appropriate for a local utility script.

Assessment

This package looks coherent for local office-file tasks, but before installing or running it: 1) Verify whether the email-send and other operations advertised in SKILL.md are actually implemented (the provided Python file listing was truncated and the examples don't exactly match visible function names). 2) Run it on sample/test directories first and back up real files before bulk rename/replace or merge operations. 3) Review the full office_automation.py for any network/email-sending code (if you intend to use email-send) and inspect any email-config files for secrets. 4) Install required Python packages in a virtualenv to avoid affecting system Python. If you want, I can scan the entire office_automation.py (complete file) for any hidden network calls or behavior not shown in the excerpt.

办公自动化脚本 - 科特船长版

功能说明

提供常用办公自动化脚本，包括：

• Excel 自动汇总
• Word 批量处理
• 文件批量重命名
• PDF 合并/拆分
• 邮件自动发送

使用场景

财务/会计

• 多表格自动汇总
• 发票数据提取
• 银行流水整理

HR/行政

• 员工信息整理
• 考勤数据汇总
• 合同批量处理

销售/运营

• 客户信息整理
• 订单数据汇总
• 报表自动生成

通用场景

• 文件批量重命名
• 文件夹整理
• 数据格式转换

使用方法

# Excel 汇总
clawhub run ke-office-automation --action excel-merge --input ./data/ --output ./merged.xlsx

# Word 批量处理
clawhub run ke-office-automation --action word-batch --input ./docs/ --action-type replace --old "旧文本" --new "新文本"

# 文件批量重命名
clawhub run ke-office-automation --action rename --input ./files/ --pattern "{date}_{original}"

# PDF 合并
clawhub run ke-office-automation --action pdf-merge --input ./pdfs/ --output ./merged.pdf

# 邮件自动发送
clawhub run ke-office-automation --action email-send --config ./email-config.json --data ./recipients.xlsx

参数说明

参数	说明	必填
--action	操作类型	是
--input	输入文件/文件夹路径	是
--output	输出文件路径	条件必填
--pattern	重命名模式	条件必填
--config	配置文件路径	条件必填

可用操作

操作	说明	适用场景
excel-merge	合并多个 Excel 文件	多表格汇总
excel-split	拆分 Excel 文件	数据分发
word-batch	Word 批量处理	合同/通知批量修改
rename	文件批量重命名	文件整理
pdf-merge	PDF 合并	报告合并
pdf-split	PDF 拆分	报告拆分
email-send	邮件批量发送	通知/营销

定制服务

需要定制自动化脚本？

服务类型

• 简单脚本: ¥500-1000（单一功能）
• 中等复杂: ¥1000-3000（多步骤）
• 系统级: ¥3000+（完整流程）

典型案例

• 财务日报自动生成：¥1500
• 客户信息自动整理：¥1200
• 合同批量处理：¥2000
• 邮件营销自动化：¥1800

服务流程

1. 需求沟通（免费）
2. 方案确认
3. 开发测试（1-3 天）
4. 交付培训
5. 售后支持（30 天免费）

联系：私信获取报价

免费资源

提供以下免费脚本模板：

• Excel 汇总脚本
• 文件重命名脚本
• PDF 合并脚本

GitHub: 待开源

常见问题

Q: 需要编程基础吗？ A: 不需要，按说明使用即可。

Q: 支持 Mac/Windows 吗？ A: 都支持，需要安装 Python 3.8+

Q: 数据安全吗？ A: 所有处理在本地完成，数据不会上传。

---

作者: 科特船长 更多技能: https://clawhub.ai/@xiaoheizp 定制咨询: 私信获取报价