← 返回 Skills 市场
45
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install software-data-excel-chart-developer-helper-180322
功能描述
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 if you want guidance for Excel report workbook automation and repair. Expect it to be invoked for Excel chart/report/export tasks; if you only want narrow manual activation, the publisher should tighten the trigger phrases or disable implicit invocation.
能力评估
Purpose & Capability
The stated purpose is to help build and troubleshoot Excel reporting workbooks with charts, dashboards, formatting, print areas, and exports; the instructions and reference material stay within that scope.
Instruction Scope
Some trigger examples are awkward and broader than ideal, especially in README and Chinese/reference files, but they still point to Excel reporting workflows rather than unrelated capabilities.
Install Mechanism
The package contains only markdown skill files, one YAML agent metadata file, and a reference document; no scripts, binaries, package installers, or executable hooks are present.
Credentials
Suggested use of openpyxl or desktop Excel automation is proportionate to Excel workbook creation, repair, rendering, and export tasks, and no network or credential requirement is declared.
Persistence & Privilege
No background workers, persistent services, scheduled tasks, privilege escalation, broad indexing, or credential/session handling are present.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install software-data-excel-chart-developer-helper-180322 - 安装完成后，直接呼叫该 Skill 的名称或使用
/software-data-excel-chart-developer-helper-180322触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v0.1.0
- Initial release of the Excel Chart Report Developer skill.
- Enables creation and troubleshooting of sophisticated Excel reports with charts, dashboards, conditional formatting, and print/export features.
- Supports automation using openpyxl and desktop Excel, with guidance on when to use each.
- Provides best practices for separating data, calculations, and presentation layers in workbooks.
- Includes common troubleshooting patterns and validation tips for reliable, presentation-ready output.
- Output includes architecture guidance, implementation steps, and a validation checklist.
元数据
常见问题
Excel Chart Report Developer 是什么？
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 插件，目前累计下载 45 次。
如何安装 Excel Chart Report Developer？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install software-data-excel-chart-developer-helper-180322」即可一键安装，无需额外配置。
Excel Chart Report Developer 是免费的吗？
是的，Excel Chart Report Developer 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Excel Chart Report Developer 支持哪些平台？
Excel Chart Report Developer 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Excel Chart Report Developer？
由 Kyro（@kyro-ma）开发并维护，当前版本 v0.1.0。
推荐 Skills