Skywork Excel
Skywork Excel (skywork) - Use for ANY task involving Excel, spreadsheets, tables, data analysis, or file conversion. Has BUILT-IN web search for real-time da...
技能说明
name: Skywork Excel description: "Skywork Excel (skywork) - Use for ANY task involving Excel, spreadsheets, tables, data analysis, or file conversion. Has BUILT-IN web search for real-time data (stocks, rates, stats). Pass user's original query directly without rewriting. Capabilities: (1) Create Excel/CSV with formulas, charts, pivots; (2) Analyze Excel/CSV/PDF/Image files - dashboards, visualizations; (3) Fetch live web data; (4) HTML reports; (5) Convert formats (PDF-to-Excel, image-to-table); (6) Financial models, budgets. Trigger on Excel/CSV/PDF/Image uploads or structured-output requests. Keywords: 'create Excel', 'spreadsheet', 'analyze data', 'chart', 'pivot table', 'dashboard', 'PDF to Excel', 'stock price', 'forecast', '创建Excel', '做表格', '数据分析', '生成图表', '数据透视表', '股价查询', 'Excelを作成', 'データ分析', 'グラフ作成', 'Excel 만들기', '데이터 분석', '차트', 'crear Excel', 'analizar datos', 'créer Excel', 'Excel erstellen', 'Datenanalyse', 'создать Excel', 'анализ данных', 'إنشاء Excel', 'Excel बनाओ', 'สร้าง Excel', 'tạo Excel', 'buat Excel', 'creare Excel'." metadata: openclaw: requires: bins: - python3 env: - SKYWORK_API_KEY primaryEnv: SKYWORK_API_KEY
Excel Generator
Generate professional Excel files and data analysis reports using the Skywork Excel backend service.
Prerequisites
API Key Configuration (Required First)
This skill requires a SKYWORK_API_KEY to be configured before use.
If you don't have an API key yet, please visit: https://skywork.ai
For detailed setup instructions, see: references/apikey-fetch.md
🚫 CRITICAL: Pass Query As-Is, Do NOT Read User Files
- NEVER use the
readtool on user-provided files (Excel, PDF, CSV, images, etc.). Pass file paths via--filesand let the backend handle reading. - Do NOT rewrite, expand, or reinterpret the user's query. Pass it as-is. The backend agent has its own understanding capabilities.
- Only two modifications are allowed:
- Time info: For time-sensitive queries, prepend current time:
[Current time: 2026-03-14] User request: ... - File paths: Replace absolute paths with filenames only (e.g.,
/Users/xxx/report.xlsx→report.xlsx)
- Time info: For time-sensitive queries, prepend current time:
Workflow
Excel tasks take 5-25 minutes. Run the script in background and poll the log every 60 seconds.
Step 1: Start Task
EXCEL_LOG=/tmp/excel_$(date +%s).log
python3 scripts/excel_api_client.py "user's query" \
--files "/path/to/file1.xlsx" "/path/to/file2.pdf" \
--language zh-CN \
--log-path "$EXCEL_LOG" \
> /dev/null 2>&1 &
echo "Task started. Log: $EXCEL_LOG"
--files: Upload user-provided files (Excel, CSV, PDF, Image). Omit if no files.--language:zh-CN(default) oren-US— match the user's language.--session <id>: For follow-up tasks — see Multi-Turn Sessions.
Step 2: Monitor Progress
Execution pattern (required):
- Run the Step 1 start command in background and note the
EXCEL_LOGpath from the output. - Then execute the Step 2 monitor command separately every 60 seconds (do not use a while loop).
$EXCEL_LOGdoes not persist between exec calls — Step 2 MUST recover the path (see monitor command below).
Rules — no exceptions:
- Poll every 60 seconds by calling exec tool repeatedly. Do NOT use a while loop.
- Show only the last TASK PROGRESS UPDATE block. Do not output full log (
tail -50, etc.) or summarize/interpret it. - Never restart the task. The agent handles errors internally and auto-recovers.
- Ignore transient errors in the log (
❌,Missing parameter, heartbeat pings, etc.) — the agent retries automatically. - Use heartbeat as liveness signal: check heartbeat lines every poll to confirm the task is still running, but do NOT output raw heartbeat lines to the user.
Every 60 seconds, run:
# Recover log path: use the path printed by Step 1, or find the most recent log
EXCEL_LOG=$(ls -t /tmp/excel_*.log 2>/dev/null | head -1)
if [ -z "$EXCEL_LOG" ] || [ ! -f "$EXCEL_LOG" ]; then
echo "ERROR: Log not found. Ensure Step 1 ran with --log-path."; exit 1
fi
sleep 60
echo "=== Progress Update ==="
grep -A8 "TASK PROGRESS UPDATE" "$EXCEL_LOG" | tail -10
grep -E "\[HEARTBEAT\]" "$EXCEL_LOG" | tail -1
grep -E "\[DONE\]|All done" "$EXCEL_LOG" | tail -1
What to report to user
CRITICAL: Output ONLY the current status. Do NOT repeat or accumulate previous status messages. Each update should be a single, fresh line.
After each log read, output ONLY ONE LINE showing the current status:
[Main stage] | [current action] | Elapsed: Xs
Example (output only this single line, nothing else):
Data Processing | Generating charts | Elapsed: 120s
| Progress contains | Main stage |
|---|---|
| "读取" / "read" / "load" | Loading data |
| "分析" / "analysis" | Data analysis |
| "图表" / "chart" / "visualization" | Generating charts |
| "Excel" / "xlsx" | Creating Excel file |
| "HTML" / "报告" / "report" | Generating report |
| "保存" / "save" / "output" | Saving output |
Stop polling when log contains [DONE] or ✅ All done! → read final output:
tail -30 "$EXCEL_LOG"
- If NOT done → report progress to user, then call
execagain after 60 seconds with the same monitor command. - Repeat until done — keep calling
execevery 60 seconds until[DONE]orAll doneappears. - Do NOT stop after a single poll.
Step 3: Deliver Result
After completion, provide the user with both:
- OSS download URL — cloud link for sharing (show as a clickable hyperlink)
- Local file path — absolute path on their machine
Example reply:
✅ Report generated!
📥 Download: https://picture-search.skywork.ai/skills/upload/2026-03-14/xxx.xlsx
💾 Local: /Users/xxx/.openclaw/workspace/report.xlsx
Do NOT use sandbox:// or [filename](sandbox://...) format — these are not clickable. If oss_url is unavailable, provide the local path only.
Multi-Turn Sessions
To continue a previous task, use --session with the ID printed at the end of the previous run:
# First turn — no --session needed; session ID is printed at end
python3 scripts/excel_api_client.py "Create a sales report" \
--language zh-CN --log-path "$EXCEL_LOG" > /dev/null 2>&1 &
# Output: 💡 To continue this conversation, use: --session abc123def456
# Follow-up turn — add --session
python3 scripts/excel_api_client.py "Add a pie chart" \
--session abc123def456 \
--language zh-CN --log-path "$EXCEL_LOG" > /dev/null 2>&1 &
When to use --session: User says "continue", "modify", "add a chart", "change colors", "based on the previous...", or references prior output.
⛔ Without --session, the agent starts fresh and loses all previous context.
Error Handling
| Error | Solution |
|---|---|
Unauthorized (401) | SKYWORK_API_KEY is missing, invalid, or expired — set or rotate the key in OpenClaw skill env |
Connection timeout | Use --timeout 1500 for complex tasks (default: 900s) |
Agent produces wrong output | Be more specific; use multi-turn to refine iteratively |
| Insufficient benefit | See below |
When benefit is insufficient
Script output may show: Insufficient benefit. Please upgrade your account at {url}
Reply in the user's language:
- Convey: "Sorry, Excel/report generation failed. This skill requires upgrading your Skywork membership."
- Format: One short sentence +
[Upgrade now →](url)(or equivalent in user's language) - URL: Extract from the
at https://...part of the log output
Security Notes
- Never commit
SKYWORK_API_KEYto version control - Set the key in OpenClaw skill
envor as an environment variable - Tokens expire — the client will auto-refresh when needed
如何使用「Skywork Excel」?
- 打开小龙虾AI(Web 或 iOS App)
- 点击上方「立即使用」按钮,或在对话框中输入任务描述
- 小龙虾AI 会自动匹配并调用「Skywork Excel」技能完成任务
- 结果即时呈现,支持继续对话优化