A high-fidelity spreadsheet skill for creating and editing Microsoft Excel workbooks while preserving formulas, formatting, and complex workbook structures.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install xiaomolong-excel-tool
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 xiaomolong-excel-tool 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 provides advanced capabilities for interacting with Microsoft Excel workbooks, including .xlsx, .xlsm, and legacy formats. Unlike basic CSV tools, this skill focuses on workbook integrity, ensuring that formulas, merged cells, and specific data types remain intact during automated edits. It is designed for developers and AI agents who need to build live financial models, maintain corporate templates, or perform complex data entry without destroying existing styles or logic.
By prioritizing the preservation of workbook structures—such as named ranges, hidden sheets, and print settings—this skill ensures that the final output is professional and ready for business use. It addresses common pitfalls like Excel's 15-digit precision limit and the 'false leap-day' date bug, making it a robust choice for mission-critical spreadsheet automation within the Openclaw Skills ecosystem.
Excel / XLSX Use Cases
- Generating live financial models with functional formulas instead of static values.
- Updating existing corporate Excel templates while preserving brand styles and print settings.
- Managing complex data types like ZIP codes and phone numbers that Excel often mangles.
- Automating data entry into workbooks containing merged cells, filters, and conditional formatting.
- Building cross-platform compatible spreadsheets that work reliably in Excel, Google Sheets, and LibreOffice.
How Excel / XLSX Works
- Workflow Selection: The skill evaluates the task to choose between pandas (for raw analysis) or openpyxl (for structural preservation).
- Workbook Inspection: It reads existing metadata, including hidden rows, named ranges, and formula caches.
- Data Type Protection: Explicit handling is applied to prevent numeric truncation or accidental date conversion during the write process.
- Formula Injection: Logic is written as live Excel formulas using relative or absolute references to maintain interactivity.
- Structural Validation: The skill checks for formula errors (like #REF! or #DIV/0!) and ensures merged areas are handled correctly.
- Final Review: Recalculation logic is verified to ensure the recipient sees current values upon opening the file.
Excel / XLSX Setup
To install this skill and its dependencies, use the following commands in your terminal:
clawhub install excel-xlsx
clawhub sync
Ensure your environment has access to Python libraries like openpyxl or pandas depending on your specific automation needs.
Excel / XLSX Data Schema & Taxonomy
The skill manages data through a structured approach to workbook components:
| Component | Handling Method |
|---|---|
| Dates | Processed as serial numbers to maintain legacy compatibility. |
| Numbers | Text-casting used for identifiers exceeding 15 digits to prevent truncation. |
| Formulas | Injected as raw strings; cached values are treated as potentially stale. |
| Templates | Styles, freeze panes, and print areas are preserved by default. |
| Merged Cells | Values are strictly mapped to the top-left cell coordinate. |
Excel / XLSX Advanced Features
- Multi-Agent Template Preservation: Maintains complex workbook features like macros (.xlsm) and data validation even when edited by AI.
- Streaming Support: Employs chunked reads for massive workbooks to prevent memory spikes.
- Formula Anchoring: Advanced logic to prevent off-by-one drift when filling formulas across large cell blocks.
- Environment Awareness: Detects 1900 vs 1904 date systems to ensure chronological accuracy.
- Style Matching: Automatically matches the visual system of newly filled cells to the existing workbook aesthetic.
SKILL.md
Loading
Related Openclaw Skills
Mysteel MarketAnalysis
A professional-grade market analysis skill for tracking bulk commodity prices, supply-demand dynamics, and inventory trends via Mysteel's internal data interfaces.
Daily Review Manager
An AI-powered assistant that captures, organizes, and summarizes your daily reflections through text or voice to generate structured journals and reports.
Company Alias Generator
An intelligent enterprise alias generator designed to create precise, filtered short names for over 686 companies and government institutions.
API Tester Skill (jpeng-api-tester)
A comprehensive utility for testing, validating, and monitoring REST and GraphQL APIs within the Openclaw Skills framework.
Task Detection + Proactive Thinking
An intelligent monitoring and self-healing system that identifies task anomalies and proactively generates solutions to keep projects on track.
Jike Data Service
A professional marketing data assistant for Douyin providing competitor analysis, trend tracking, and content suggestions for the smartphone industry.
Featured*
