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