← 返回 Skills 市场
37
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install software-data-excel-chart-developer-helper
功能描述
Create and troubleshoot Excel reporting workbooks with charts, dashboards, conditional formatting, print areas, PDF/image export, openpyxl or Office automati...
使用说明 (SKILL.md)
Excel Chart Report Developer
Use this skill for recurring Excel reports where the workbook is both a data artifact and a presentation artifact. Keep charts, formulas, formatting, print settings, and exports in sync.
Workflow
- Clarify the report target: dashboard workbook, chart pack, PDF export, image export, print-ready report, recurring refresh, or workbook template.
- Separate data, calculations, and presentation:
- Raw or imported data sheets.
- Calculation/helper sheets with formulas and named ranges.
- Output sheets with charts, summaries, conditional formatting, and print areas.
- Choose the automation layer:
- Use
openpyxlfor workbook structure, formulas, styles, charts, tables, print setup, and conditional formatting where supported. - Use Excel desktop automation only when live chart rendering, Power Query refresh, or PDF export fidelity is essential and available.
- Preserve unsupported workbook parts by editing package contents carefully.
- Use
- Design stable ranges. Prefer Excel Tables and named ranges over hard-coded row counts.
- Apply visual formatting after data writes so fills, borders, number formats, widths, and conditional formatting do not drift.
- Validate:
- Formulas point to valid ranges.
- Charts reference current data.
- Print areas, page orientation, margins, headers/footers, and page breaks match the expected export.
- Exports are reviewed for clipping, missing labels, and font substitution.
Common Fix Patterns
- Chart not updating: verify series formulas, named ranges, table expansion, and cached chart data.
- Conditional formatting drift: inspect rule ranges and priority ordering after row insertion.
- Bad PDF export: check print area, scaling, margins, page breaks, and whether a desktop Excel render is required.
- Template overwrites: write values into known input ranges, then preserve output sheets and chart objects.
- Data refresh: log source file timestamps, row counts, and validation totals for each run.
Outputs
Provide:
- A report architecture or repair diagnosis.
- Implementation steps or code for workbook generation/update.
- A validation note covering formulas, charts, formatting, and exports.
Read references/requirement-plan.md only when source evidence from the discovery run is needed.
安全使用建议
Install only if you want an agent to help create or repair Excel workbooks and reports. Keep copies of important spreadsheets before allowing edits, and confirm the exact files and outputs when the skill is invoked for broad Excel-related requests.
能力评估
Purpose & Capability
The described capabilities around XLSX workbooks, charts, dashboards, formulas, print layout, and PDF/image export fit the stated Excel reporting purpose.
Instruction Scope
Several trigger descriptions and implicit invocation metadata appear broad, so the skill could be selected for ordinary Excel questions where full workbook automation is not intended.
Install Mechanism
No supplied evidence shows a hidden installer, obfuscated setup, unrelated package installation, or unexpected runtime bootstrap.
Credentials
Workbook reading and modification are proportionate for an Excel automation skill, but users should treat workbooks as potentially sensitive business documents.
Persistence & Privilege
No supplied artifact evidence shows background persistence, privilege escalation, credential/session harvesting, or long-running workers.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install software-data-excel-chart-developer-helper - 安装完成后，直接呼叫该 Skill 的名称或使用
/software-data-excel-chart-developer-helper触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.1
- Added detailed documentation outlining the workflow for developing and maintaining Excel report workbooks with charts and dashboards.
- Clarified best practices for separating data, calculations, and presentation within workbooks.
- Specified guidance on using openpyxl versus desktop Excel automation, depending on reporting requirements.
- Listed common troubleshooting steps for issues with charts, conditional formatting, PDF exports, and recurring data refresh.
- Defined expected outputs, including architecture/diagnosis, implementation guidance, and validation notes for Excel reporting solutions.
元数据
常见问题
Software Data Excel Chart Developer Helper 是什么？
Create and troubleshoot Excel reporting workbooks with charts, dashboards, conditional formatting, print areas, PDF/image export, openpyxl or Office automati... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 37 次。
如何安装 Software Data Excel Chart Developer Helper？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install software-data-excel-chart-developer-helper」即可一键安装，无需额外配置。
Software Data Excel Chart Developer Helper 是免费的吗？
是的，Software Data Excel Chart Developer Helper 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Software Data Excel Chart Developer Helper 支持哪些平台？
Software Data Excel Chart Developer Helper 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Software Data Excel Chart Developer Helper？
由 Kyro（@kyro-ma）开发并维护，当前版本 v1.0.1。
推荐 Skills