A professional spreadsheet generator for creating automated data tables, financial reports, and visual charts in Excel format.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-studio
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-studio 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 Studio?
Excel Studio is a high-performance automation tool designed for the Openclaw Skills ecosystem, enabling developers and AI agents to programmatically generate complex Excel workbooks. It provides a robust Python-based framework to handle everything from simple data exports to sophisticated financial modeling with multi-sheet support.
By leveraging industrial-grade libraries like openpyxl, this skill ensures that generated files are fully compatible with Microsoft Excel, WPS Office, and LibreOffice. It eliminates the manual effort of data entry and formatting, allowing for consistent, professional-grade output including localized content in multiple languages such as Chinese and English.
Excel Studio Use Cases
- Automated generation of quarterly sales and financial reports with built-in growth formulas.
- Creating inventory management systems with conditional formatting and data validation.
- Transforming raw data exports into visual dashboards using bar, line, and pie charts.
- Building personal budget trackers and project schedules with cross-sheet references.
- Batch processing data into SEO-friendly CSV or Excel formats for business intelligence.
How Excel Studio Works
- The agent receives a trigger command or natural language request to create a spreadsheet.
- Excel Studio analyzes the requirements, including document type, desired format (.xlsx, .xls, or .csv), and data structure.
- A localized Python script is initialized using the ExcelGenerator class to define sheets, styles, and data positioning.
- Data is injected into cells with specific formatting types applied (e.g., currency, percentage, or custom headers).
- Advanced elements like Excel formulas (SUM, VLOOKUP) and visual charts are dynamically added based on the data ranges.
- The final workbook is saved to the local workspace and delivered to the user.
Excel Studio Setup
To use this within the Openclaw Skills environment, ensure you have Python 3 installed and the required dependencies:
pip install openpyxl xlwt
The skill executes locally using the python3 binary and saves outputs to the OPENCLAW_WORKSPACE directory.
Excel Studio Data Schema & Taxonomy
Excel Studio organizes data through a structured hierarchy of Workbooks, Sheets, and Cells. Metadata is handled via standard Openclaw Skills taxonomy:
| Level | Data Handled | Examples |
|---|---|---|
| Workbook | File Format & Metadata | .xlsx, .xls, .csv |
| Worksheet | Named Data Segments | Sales Data, Summary, Pivot |
| Cell | Values & Styles | Strings, Floats, Formulas, Fills |
| Charts | Visual References | BarChart, PieChart objects |
Excel Studio Advanced Features
- Multi-Sheet Cross-Referencing: Link data across different worksheets using standard Excel syntax like
=Sheet1!A1. - Auto-Column Adjustment: Intelligent calculation of cell widths based on content length to ensure readability.
- Professional Styling Hooks: Pre-defined format objects for headers, titles, and color-coded fills (blue, green, red, yellow).
- Formulaic Logic Injection: Programmatically insert complex logical and mathematical formulas for dynamic data updates.
SKILL.md
Loading
Related Openclaw Skills
Xiaohongshu Research Kit
A specialized research tool for extracting metadata, image, and video content from Xiaohongshu without needing an official API.
Self-Improving Agent (Proactive Self-Reflection)
An advanced self-learning framework that enables AI agents to evaluate their own work, log corrections, and evolve through a tiered memory system.
Neverbounce
A powerful email verification skill that allows AI agents to validate addresses, manage bulk cleaning jobs, and monitor account credits through the Membrane ecosystem.
SMC Trading Signal Monitoring
An automated market monitoring tool that identifies high-probability trading entries based on Smart Money Concepts and dynamic ATR risk management.
Yunxiao Work Items Skill
A powerful Openclaw Skills extension for managing Alibaba Cloud Yunxiao work items, tasks, and project communications directly through an AI agent.
VAPT Intern Roadmap
A professional career development platform that generates personalized, evidence-based learning paths for aspiring Vulnerability Assessment and Penetration Testing professionals.
Featured*
