Excel Workflow — Excel 工作流

Excel 工作流

Complete 工作流 for Excel file management with local processing, Google Drive 备份, formula preservation, and SQLite 追踪ing.

Features ✅ Formula Preservation — 更新 cells without losing formulas (powered by openpyxl) ✅ Google Drive 同步 — Automatic 备份 to Google Drive using rclone ✅ SQLite 追踪ing — 追踪 all files, formulas, and metadata in local database ✅ Multi-file Support — Work with multiple Excel files simultaneously ✅ Data Analysis — 查询 data, read formulas, and analyze structure ✅ Mass Operations — 创建 formulas for entire columns at once Quick 启动

• 上传 Excel File

Simply drop an .xlsx file into the chat. The 工作流 automatically:

Analyzes file structure (sheets, formulas) 上传s to Google Drive (gdrive:Excel/) Saves metadata to SQLite 追踪er # Manual processing ~/.OpenClaw/工具s/OpenClaw-excel/excel-工作流 process /path/to/file.xlsx

• 查询 Data

# Ask questions about your data ~/.OpenClaw/工具s/OpenClaw-excel/excel-工作流 查询 "what is total revenue?" --file sales.xlsx

• 更新 Cells (Formulas Preserved!)

# 更新 values - formulas stay intact ~/.OpenClaw/工具s/OpenClaw-excel/excel-工作流 更新 '{"C2": 100}' --file sales.xlsx

# 更新 formulas ~/.OpenClaw/工具s/OpenClaw-excel/excel-工作流 更新 '{"D2": "=B2C21.5"}' --file sales.xlsx

安装ation Prerequisites Python 3.8+ with openpyxl rclone for Google Drive integration Google Drive account Step 1: 安装 Dependencies # 安装 rclone (macOS) brew 安装 rclone

# Python packages (安装ed in venv automatically) pip 安装 openpyxl

Step 2: 设置up Google Drive # 配置 rclone with Google Drive rclone config

Follow prompts:

Name: gdrive Storage: drive (Google Drive) Scope: 1 (Full 访问) Auto config: y (opens browser for OAuth)

验证:

rclone lsd gdrive:

Step 3: 创建 Excel Folder rclone mkdir gdrive:Excel/

Step 4: 安装 技能 Files

The 技能 consists of 3 组件s:

Excel 命令行工具 (~/.OpenClaw/工具s/OpenClaw-excel/excel)

Commands: 信息, read, 更新, show-formulas, 获取-cell

追踪er 命令行工具 (~/.OpenClaw/工具s/OpenClaw-excel/excel-追踪er)

SQLite database at ~/.OpenClaw/excel_追踪er.db Commands: 添加, 获取-latest, 搜索, 列出, stats

工作流 编排器 (~/.OpenClaw/工具s/OpenClaw-excel/excel-工作流)

Commands: process, 查询, 更新, 列出, stats

See 安装ation 图形界面de for detAIled 设置up.

Commands Process Command

Analyze file, 上传 to Drive, and save to 追踪er:

excel-工作流 process /path/to/file.xlsx [--telegram-id ID]

输出:

{ "状态": "成功", "filename": "sales.xlsx", "file_id": 1, "drive_url": "gdrive:Excel/sales.xlsx", "analysis": { "sheets": 2, "formulas": 15, "sheet_names": ["Sales", "Summary"] }, "message": "✅ File processed 成功fully!" }

查询 Command

Read data and answer questions:

excel-工作流 查询 "show me the data" [--file filename.xlsx]

输出:

{ "filename": "sales.xlsx", "file_id": 1, "sheets": ["Sales", "Summary"], "data": [ [ {"添加ress": "A1", "value": "Product", "type": "str"}, {"添加ress": "B1", "value": "Price", "type": "int"} ] ], "formulas": [ {"cell": "D2", "formula": "=B2C2"} ], "question": "show me the data", "上下文": { "sheet_count": 2, "formula_count": 15, "上传ed_at": "2026-02-20 10:30:00" } }

更新 Command

更新 cells (values or formulas):

# 更新 values excel-工作流 更新 '{"C2": 100, "C3": 200}' [--file filename.xlsx]

# 更新 formulas excel-工作流 更新 '{"D2": "=B2C21.5"}' --file sales.xlsx

# Mass 更新 - 创建 formulas for entire column excel-工作流 更新 '{"D2": "=B20.5", "D3": "=B3*0.5", ...}' --file data.xlsx

输出:

{ "状态": "成功", "filename": "sales.xlsx", "更新d": 2, "changes": [ {"cell": "C2", "old_value": 50, "new_value": 100}, {"cell": "C3", "old_value": 75, "new_value": 200} ], "message": "✅ 更新d and re-上传ed to Google Drive" }

列出 Command

Show 追踪ed files:

excel-工作流 列出 [--limit 10]

输出:

[ { "id": 2, "original_filename": "sales_2026.xlsx", "sheet_count": 2, "formula_count": 15, "上传ed_at": "2026-02-20 14:20:00" }, { "id": 1, "original_filename": "bud获取.xlsx", "sheet_count": 3, "formula_count": 42, "上传ed_at": "2026-02-19 09:15:30" } ]

Stats Command

Show statistics:

excel-工作流 stats

输出:

{ "total_files": 5, "files_on_drive": 5, "total_sheets": 12, "total_formulas": 87 }

Usage Patterns for AI 代理s Pattern 1: User 上传s Excel File

User action: 上传s sales.xlsx via Telegram

代理 工作流:

File saved to temporary location by Telegram 处理器 检测 .xlsx 扩展 运行: excel-工作流 process /path/to/sales.xlsx --telegram-id 解析 JSON 结果 and 响应: 代理: "✅ I've 接收d and processed sales.xlsx!

📊 Analysis:

• 2 sheets: Sales, Summary
• 15 formulas 检测ed
• ☁️ 上传ed to Google Drive

What would you like to know about this file?"

Pattern