← Back to Skills Marketplace
45
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install software-data-excel-chart-developer-helper-180322
Description
Create and troubleshoot Excel reporting workbooks with charts, dashboards, conditional formatting, print areas, PDF/image export, openpyxl or Office automati...
README (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.
Usage Guidance
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.
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install software-data-excel-chart-developer-helper-180322 - After installation, invoke the skill by name or use
/software-data-excel-chart-developer-helper-180322 - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is Excel Chart Report Developer?
Create and troubleshoot Excel reporting workbooks with charts, dashboards, conditional formatting, print areas, PDF/image export, openpyxl or Office automati... It is an AI Agent Skill for Claude Code / OpenClaw, with 45 downloads so far.
How do I install Excel Chart Report Developer?
Run "/install software-data-excel-chart-developer-helper-180322" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Excel Chart Report Developer free?
Yes, Excel Chart Report Developer is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Excel Chart Report Developer support?
Excel Chart Report Developer is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Excel Chart Report Developer?
It is built and maintained by Kyro (@kyro-ma); the current version is v0.1.0.
More Skills