Feature Description
Provides commonly used office automation scripts, including:
- Excel automatic consolidation
- Word batch processing
- File batch renaming
- PDF merge/split
- Automatic email sending
Use Cases
Finance/Accounting
- Automatic consolidation of multiple spreadsheets
- Invoice data extraction
- Bank statement organization
HR/Administration
- Employee information organization
- Attendance data consolidation
- Contract batch processing
Sales/Operations
- Customer information organization
- Order data consolidation
- Automatic report generation
General Use Cases
- File batch renaming
- Folder organization
- Data format conversion
How to Use
# 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
Parameter Description
| Parameter | Description | Required |
|---|---|---|
--action |
Operation type | Yes |
--input |
Input file/folder path | Yes |
--output |
Output file path | Conditionally required |
--pattern |
Rename mode | Conditionally required |
--config |
Configuration file path | Conditionally required |
Available Operations
| Operation | Description | Applicable Scenario |
|---|---|---|
| excel-merge | Merge multiple Excel files | Multi-spreadsheet consolidation |
| excel-split | Split Excel files | Data distribution |
| word-batch | Word batch processing | Contract/notice batch modification |
| rename | File batch renaming | File organization |
| pdf-merge | PDF merge | Report merge |
| pdf-split | PDF split | Report split |
| email-send | Email batch sending | Notification/marketing |
Custom Services
Need a custom automation script?
Service Types
- Simple script: ¥500-1000 (single function)
- Medium complexity: ¥1000-3000 (multi-step)
- System-level: ¥3000+ (complete workflow)
Typical Cases
- Automatic daily finance report generation: ¥1500
- Automatic customer information organization: ¥1200
- Contract batch processing: ¥2000
- Email marketing automation: ¥1800
Service Process
- Requirements discussion (free)
- Solution confirmation
- Development and testing (1-3 days)
- Delivery and training
- After-sales support (30 days free)
Contact: send a private message for a quote
Free Resources
Provides the following free script templates:
- Excel consolidation script
- File renaming script
- PDF merge script
GitHub: to be open-sourced
Frequently Asked Questions
Q: Do I need a programming background? A: No, just follow the instructions.
Q: Does it support Mac/Windows? A: Both are supported, Python 3.8+ is required
Q: Is the data secure? A: All processing is done locally, and data is not uploaded.
Author: Captain Ke Te More skills: https://clawhub.ai/@xiaoheizp Custom consulting: DM for a quote