A powerful automation skill for generating production-ready, formula-driven Excel reports with professional financial styling.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-report
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install excel-report using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Excel Visual Report Generator?
The Excel Visual Report Generator is a high-performance component of the Openclaw Skills ecosystem designed to transform raw data into sophisticated, board-room ready workbooks. Unlike traditional exports, this skill utilizes native Excel formulas instead of hardcoded values, ensuring that KPIs and summaries update automatically when underlying data changes. It implements a rigorous financial design system, featuring deep-blue headers, zebra-striped rows, and standardized currency formatting, making it ideal for manufacturing, retail, and financial services.
Excel Visual Report Generator Use Cases
- Generating automated daily production capacity and quality control reports for manufacturing.
- Creating professional retail sales dashboards with monthly performance analysis.
- Producing financial revenue summaries and banking asset reports with precise number formatting.
- Automating internet app DAU tracking and e-commerce order summaries.
- Batch processing large data directories into standardized reports for stakeholder distribution.
How Excel Visual Report Generator Works
- The user selects an industry-specific template from the 12 available options using the CLI.
- Input data in XLSX, CSV, or JSON format is ingested through a smart mapping engine that identifies columns like Date and Sales automatically.
- The engine applies professional themes, including frozen panes, auto-filters, and double-line borders.
- KPIs are calculated using dynamic Excel formulas (e.g., SUM, AVG, IFERROR) to maintain data integrity.
- The tool generates a multi-sheet workbook containing raw data, a visual dashboard, and detailed breakdowns.
- Optionally, the generated reports are dispatched via the integrated SMTP email module.
Excel Visual Report Generator Setup
To integrate this capability into your environment, install the necessary Python dependencies and move the skill files into your local directory:
pip install openpyxl pandas
mkdir -p ~/.qclaw/skills/excel-report/
# Transfer skill files to the directory
For email automation, configure your environment variables:
export SMTP_HOST=smtp.gmail.com
export [email protected]
export SMTP_PASSWORD=your_app_password
Excel Visual Report Generator Data Schema & Taxonomy
The skill organizes output into a structured workbook format to maximize readability:
| Sheet Name | Content Details | Formatting |
|---|---|---|
| Raw Data | Original data rows | Deep blue headers, zebra stripes, frozen top row |
| Analysis Dashboard | KPI Cards and Charts | Large blue fonts, IFERROR protected formulas |
| Detailed Data | Itemized breakdowns | Professional borders and auto-fit columns |
Data mapping supports multiple input formats and intelligently identifies localized column names for dates and currency amounts.
Excel Visual Report Generator Advanced Features
- Dynamic Formula Engine: Replaces static values with live Excel formulas for real-time updates.
- Multi-Industry Template Library: Pre-configured layouts for manufacturing, finance, medical, and retail sectors.
- Batch Processing: Command-line support for processing entire directories of data files simultaneously.
- Automated SMTP Delivery: Trigger report generation and email distribution in a single workflow using Openclaw Skills.
- Visual Theme Customization: Centralized JSON theme configuration for brand-specific color palettes and border styles.
SKILL.md
Loading
Related Openclaw Skills
Enterprise Car Service Skill
A professional AI agent skill for managing corporate car bookings, real-time ride-hailing, and automated airport transfers.
Tencent COS Operations
A comprehensive tool for managing Tencent Cloud Object Storage (COS) featuring automated monthly file organization and high-performance concurrent uploads.
fb-car-service-skill
An enterprise-grade car service assistant for booking immediate rides, scheduling airport transfers, and managing corporate vehicle logistics.
Web3 Crypto Ops
A high-performance Web3 operating skill for AI agents that integrates 60+ API endpoints across 12 domains for comprehensive crypto trading and market intelligence.
Tianyancha Bidding Collector
An automated browser-based tool designed to batch query and export structured bidding, tender, and award notifications from the Tianyancha platform into CSV reports.
Bambuddy
A comprehensive integration for managing Bambu Lab 3D printers and print archives through a self-hosted Bambuddy REST API.
Featured*
