← Back to Skills Marketplace
andyrenxu7255

Office Automation Toolkit

by Andy Ren · GitHub ↗ · v1.1.0 · MIT-0
cross-platform ⚠ suspicious
54
Downloads
0
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install office-automation-toolkit
Description
办公自动化工具注册表:零配置可用的 CLI/Python 工具清单。 当 sop-extractor 生成 Skill 需要工具时,从这里查找。 触发词:「工具清单」「有哪些工具」「toolkit」「安装工具」。
README (SKILL.md)

办公自动化工具注册表

核心原则:零配置可用。需要账号授权的工具列为"扩展工具",按需配置。

基础工具(零配置,安装即用)

Office 文档

工具 安装 能力 WPS
openpyxl pip install openpyxl Excel 读写,公式/图表/样式
pandas pip install pandas 数据分析/透视表/筛选
python-docx pip install python-docx Word 读写,段落/表格/样式
python-pptx pip install python-pptx PPT 创建/编辑
markitdown pip install markitdown Office 全格式→Markdown
pywpsrpc pip install pywpsrpc 直接调用本地 WPS(Linux) ✅原生

PDF

工具 安装 能力
pymupdf pip install pymupdf 读取/提取文字图片表格
pypdf pip install pypdf 合并/拆分/加密
pdfplumber pip install pdfplumber 精确表格提取
reportlab pip install reportlab 生成 PDF

浏览器 & 网络

工具 安装 能力
playwright pip install playwright && playwright install chromium 无头浏览器自动化
requests pip install requests HTTP 请求
beautifulsoup4 pip install beautifulsoup4 HTML 解析
httpx pip install httpx 异步 HTTP

系统 CLI

工具 安装 能力
jq apt/brew install jq JSON 处理
pandoc apt/brew install pandoc 万能格式转换
ffmpeg apt/brew install ffmpeg 音视频处理
tesseract apt/brew install tesseract OCR 文字识别

飞书(已配置 ✅)

工具 能力
lark-cli 飞书官方 CLI,200+ 命令,覆盖消息/文档/表格/日历/邮件/任务/审批
lark-oapi Python SDK

凭证由 Hermes 预配,lark-cli 通过 config bind --source hermes 自动绑定。

企业微信 & 钉钉

平台 工具 配置
企业微信 Webhook 机器人 🟡 仅需 Webhook URL
企业微信 wecom-cli 🟡 需 Corp ID
钉钉 dingtalk-cli 🟡 需 App Key

扩展工具(需 IT 配置 Token/Key)

工具 需要配置
消息 lark-oapi / wecom / dingtalk App ID + Secret
日历 gcalcli / msal / lark-oapi OAuth2 或 App 凭证
邮件 himalaya / google-api IMAP 账号或 OAuth2
数据库 mysql/psql/redis-cli 连接信息

工具选择速查

  • Excel → openpyxl(读写)/ pandas(分析)/ csvkit(CLI)
  • Word → python-docx(读写)/ markitdown(提取)/ pywpsrpc(控制WPS)
  • PPT → python-pptx / powerpoint skill
  • PDF → pymupdf(提取)/ pypdf(合并)/ reportlab(生成)
  • 浏览器 → Playwright(零配置,首次有头扫码→保存 auth.json 后续无头)
  • 发消息 → 飞书 lark-cli / 企微 Webhook / 钉钉
  • 抓网页 → 动态页面 Playwright / 静态页面 requests+BS4

工具能力矩阵详见 references/tool-quick-reference.md

Usage Guidance
Review and limit the Feishu/Lark credentials before installing or using this skill. If you run the bootstrap script, do so in a controlled environment and verify the package list. Treat any saved browser auth.json file as a sensitive login credential.
Capability Assessment
Purpose & Capability
The office automation registry purpose is coherent, but the Feishu/Lark entry describes 200+ credentialed enterprise commands across messages, documents, calendars, mail, tasks, and approvals, which is broader than a simple tool catalog.
Instruction Scope
The artifacts do not define approval boundaries for high-impact credentialed actions such as sending messages, editing cloud documents, mail/calendar operations, or approval workflows.
Install Mechanism
There is no install spec, but a bundled bootstrap script can manually install many Python and system packages and download Playwright Chromium; this is purpose-aligned but materially changes the local environment if run.
Credentials
Most package and CLI recommendations fit office automation, though the bootstrap script installs a broad set of required, recommended, and optional tools rather than a narrow task-specific subset.
Persistence & Privilege
The skill references persistent Feishu/Lark credential binding and saved Playwright auth state, both of which can preserve account access beyond a single task.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install office-automation-toolkit
  3. After installation, invoke the skill by name or use /office-automation-toolkit
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.1.0
**Simplified and reorganized skill documentation for clarity and easier reference.** - 精简目录结构,把多级分节浓缩到核心高频工具,并以“基础工具”和“扩展工具”两大类展示。 - 删除冗长说明、代码样例和部分具体用法,聚焦常用办公自动化工具清单及快速选择指引。 - 工具表格内容合并优化,例如 Word/Excel/PDF/PPT/浏览器/CLI 各用途直观对比,便于查找和决策。 - 更新部分安装命令统一为 `pip install` 简写,提高跨平台一致性。 - 飞书工具使用预配置说明更简洁,突出一键绑定体验,明确企业微信/钉钉需 IT 介入配置的区别。 - 新增“工具选择速查”一栏,给出各典型场景下推荐工具,方便直接选型。
v1.0.0
Initial release of office-automation-toolkit: comprehensive, zero-configuration registry of automation tools for office workflows. - Catalog of CLI/Python tools for Office/WPS, PDF, browser automation, WPS local APIs, Feishu/Lark, WeCom, DingTalk, and more - All base tools require no pre-configured token or API key—ready to use after install - Clear tool categories: zero-config base tools vs. IT-managed extension tools needing credentials - Detailed command, install, and capability guide for each tool - Includes sample code snippets for browser and WPS automation - One-command bootstrap script for batch installation across platforms
Metadata
Slug office-automation-toolkit
Version 1.1.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 2
Frequently Asked Questions

What is Office Automation Toolkit?

办公自动化工具注册表:零配置可用的 CLI/Python 工具清单。 当 sop-extractor 生成 Skill 需要工具时,从这里查找。 触发词:「工具清单」「有哪些工具」「toolkit」「安装工具」。 It is an AI Agent Skill for Claude Code / OpenClaw, with 54 downloads so far.

How do I install Office Automation Toolkit?

Run "/install office-automation-toolkit" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Office Automation Toolkit free?

Yes, Office Automation Toolkit is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Office Automation Toolkit support?

Office Automation Toolkit is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Office Automation Toolkit?

It is built and maintained by Andy Ren (@andyrenxu7255); the current version is v1.1.0.

💬 Comments