A sophisticated spreadsheet automation skill for creating, editing, and analyzing Excel files with full formula and formatting support.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install lhx111
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 lhx111 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 xlsx Spreadsheet Specialist?
The xlsx skill provides a robust framework for AI agents to interact with spreadsheet data programmatically. By leveraging the power of Openclaw Skills, users can generate dynamic Excel workbooks that utilize native formulas rather than static hardcoded values, ensuring that data remains interactive and updateable.
This skill is particularly valuable for developers and analysts who need to maintain high standards of data integrity. It combines the data manipulation strengths of pandas with the precise formatting and formula capabilities of openpyxl, all while ensuring that every output meets professional standards for financial modeling and technical reporting.
xlsx Spreadsheet Specialist Use Cases
- Building dynamic financial models with automated growth projections and valuation multiples.
- Generating automated business reports from raw datasets using pandas and openpyxl.
- Auditing and fixing formula errors like #REF! or #DIV/0! in complex workbooks.
- Converting CSV data into professionally formatted Excel files with custom styling and color coding.
- Updating existing Excel templates while preserving original formatting and conventions.
How xlsx Spreadsheet Specialist Works
- The skill identifies the task requirements to choose between pandas for high-volume data or openpyxl for formula-heavy tasks.
- Data is ingested from existing files or generated dynamically based on the user prompt.
- The agent applies specific logic to create Excel formulas, ensuring all calculations are dynamic and referenceable.
- Industry-standard formatting is applied, including color-coding (e.g., blue for inputs, black for formulas).
- A mandatory recalculation step is performed using a LibreOffice-based script to validate all formulas.
- The system interprets JSON error summaries to fix any identified formula issues before final delivery.
xlsx Spreadsheet Specialist Setup
To utilize this skill within Openclaw Skills, ensure your environment has the necessary dependencies installed:
# Install Python dependencies
pip install pandas openpyxl
# Formula recalculation requires LibreOffice
# The recalc.py script will handle initial configuration
python recalc.py your_spreadsheet.xlsx
xlsx Spreadsheet Specialist Data Schema & Taxonomy
The skill organizes spreadsheet data according to strict professional standards to ensure clarity and usability:
| Component | Standard | Description |
|---|---|---|
| Hardcoded Inputs | Blue Text (0,0,255) | User-changeable scenario variables |
| Formulas | Black Text (0,0,0) | Dynamic calculations and logic |
| Internal Links | Green Text (0,128,0) | References to other sheets in the workbook |
| External Links | Red Text (255,0,0) | References to external files |
| Assumptions | Dedicated Cells | All growth rates and margins kept in separate, referenced cells |
| Metadata | Source Comments | Documentation of data sources including dates and URLs |
xlsx Spreadsheet Specialist Advanced Features
- Headless formula recalculation using LibreOffice integration for Linux and macOS.
- Automated error detection and reporting via JSON-formatted summaries (status, counts, and cell locations).
- Support for complex financial number formatting, including custom currency units and percentage decimals.
- Smart template preservation that matches existing styles and conventions without forcing new standards.
- Advanced data analysis capabilities including statistical descriptions and visual data previews via pandas integration.
SKILL.md
Loading
Related Openclaw Skills
sdbao - AI Insurance Brokerage Assistant
An intelligent insurance brokerage assistant designed for product discovery, lead registration, and comprehensive policy support.
Shopping Affiliate Search
A global e-commerce search tool that automatically injects affiliate tracking codes into product links to generate passive commission income.
Content Humanizer
A specialized text refiner that eliminates AI patterns and adapts writing for specific social platforms with natural human rhythm.
Raspberry Pi Hardware PWM Servo Control
A high-performance skill that leverages Raspberry Pi native hardware PWM interfaces to provide smooth and precise servo motor control.
Format Flow
A versatile CLI toolkit for high-fidelity document conversion, web scraping to markdown, and automated image processing.
FBox MCP Server Manager
A specialized skill for managing FBox Industrial IoT devices, providing real-time PLC data monitoring, alarm confirmation, and remote VNC access.
Featured*
