A high-reliability AI coding skill designed to create, inspect, and edit Microsoft Excel workbooks, preserving complex formulas, formatting, and template structures.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install testskill1111
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 testskill1111 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 / XLSX?
The excel-xlsx skill empowers AI coding agents to interact reliably with Microsoft Excel spreadsheets, including XLSX, XLSM, XLS, CSV, and TSV formats. Designed to transition smoothly between high-performance data processing and high-fidelity layout preservation, this skill ensures that programmatic edits do not strip styles, break formulas, or corrupt crucial legacy behaviors.
By establishing clear boundaries between data manipulation (using tools like pandas) and structural preservation (using openpyxl), this skill ensures that generated or modified workbooks stay live, dynamic, and fully functional for end-users without manual formatting corrections.
Excel / XLSX Use Cases
- Building live financial models that require dynamic Excel formula recalculations and specific cell styling.
- Updating existing corporate templates while preserving hidden sheets, print settings, conditional formatting, and data validation.
- Programmatically writing large datasets to XLSX without corrupting phone numbers, ZIP codes, or high-precision numerical IDs.
- Auditing existing workbooks for formula errors, broken relative references, or circular dependencies before shipping.
How Excel / XLSX Works
- Workflow Selection: The skill determines whether to use pandas (for raw data analysis) or openpyxl (for formula, style, and structure preservation) based on the task requirement.
- Workbook Inspection: It analyzes existing templates, respecting merged cells, hidden ranges, styles, and sheet orders.
- Data Type Protection: Ensures sensitive data types (like serial codes, leading zeros, or long integers) are written as text to prevent automatic Excel truncation or scientific formatting.
- Formula Embedding: Inserts dynamic Excel formulas with absolute or relative references, referencing assumption cells instead of hardcoding static calculated values.
- Validation and Audit: Audits the resulting sheet for stale cached values, broken formulas (#REF!, #DIV/0!), and style anomalies.
- Resource Scaling: Adapts file streaming or chunked-read modes automatically for larger files to prevent memory spikes.
Excel / XLSX Setup
To install this excel-xlsx automation skill inside your project, run the following command within your environment:
clawhub install excel-xlsx
To ensure you are using the latest optimized version and rules for Openclaw Skills, synchronize your local registry:
clawhub sync
Make sure you have pandas and openpyxl installed in your runtime environment to support both analytical and structure-preserving pipelines.
Excel / XLSX Data Schema & Taxonomy
Supported File Extensions
The excel-xlsx skill manages data across multiple tabular and spreadsheet-specific extensions:
| Extension | Library | Primary Workflow Focus |
|---|---|---|
.xlsx |
openpyxl / pandas |
Standard workbooks, layout preservation, cell styles |
.xlsm |
openpyxl |
Macro-enabled workbooks |
.xls |
openpyxl (legacy) |
Legacy binary format processing |
.csv / .tsv |
Standard csv / pandas |
Flat, layout-free tabular exchange |
Structural Cell Taxonomy
- Values: Top-left cells in merged ranges host values; surrounding cells evaluate to null.
- Dates: Stored strictly as serial numbers with fractional time values, with 1900 or 1904 epoch tracking.
- Formula Strings: Retained dynamically; cached values are verified to prevent stale out-of-sync formula outputs.
Excel / XLSX Advanced Features
- Dynamic Formula Referencing: Generates absolute and relative references with validation checks to prevent range shifting during batch fills.
- Streaming & Chunked Processing: Handles multi-gigabyte files efficiently using streaming modes, averting out-of-memory errors on extensive datasets.
- Strict Type Coercion: Imposes programmatic text constraints on columns containing long IDs, phone numbers, and codes to block destructive Excel auto-formatting.
- Template Integrity Engine: Detects, isolates, and protects print configurations, frozen panes, custom styles, conditional formatting, and sheet structures during update operations.
- Multi-Skill Interoperability: Seamlessly integrates with related tools in Openclaw Skills, such as
csvfor quick ingestion, anddata-analysisfor upfront calculations.
SKILL.md
Loading
Related Openclaw Skills
Analytical Thinking
A structured, framework-driven skill that enables AI agents to decompose complex problems, test hypotheses, map evidence, and generate clear, synthesized decisions.
Creative Thinking
A structured, agentic framework designed to separate divergent generation from convergent evaluation to produce high-quality, novel solutions.
Ethical Thinking
A structured ethical analysis skill for AI agents to map stakeholders, navigate value tensions, assess power asymmetries, and recommend balanced actions.
Agent Governance Assistant
An AI-powered framework on Openclaw Skills to discover, audit, secure, and ensure regulatory compliance for enterprise AI agents and automated workflows.
Shanghai Government Service Guide
An AI-powered municipal assistant that maps Shanghai public service queries to official departments, handling processes, and application guidelines.
iOS ShareSDK Integration
An automated AI skill to seamlessly integrate and configure the MobTech ShareSDK into iOS projects with absolute code safety and strict privacy compliance.
Featured*
