An advanced toolset for building, modifying, and programmatically auditing robust Excel spreadsheets with dynamic formulas.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sheetpro
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 sheetpro 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?
The XLSX skill provides a programmatic framework for generating, editing, and analyzing .xlsx, .xlsm, .csv, and .tsv files. Built primarily for developers and automation agents, it enforces clean layout principles and standardizes financial modeling designs directly within data workflows.
By leveraging tools like openpyxl for presentation-layer adjustments and pandas for heavy data analytics, this Openclaw Skills resource turns static data outputs into highly interactive spreadsheets. It explicitly bans the hardcoding of calculated numbers, guaranteeing that all output assets remain dynamic, functional, and production-ready.
XLSX Use Cases
- Creating executive dashboards and dynamic financial models from raw transactional inputs.
- Parsing and cleaning corrupted or poorly formatted tabular source files into structurally sound spreadsheets.
- Batch-updating cell contents, altering column matrices, or injecting multi-sheet logic into legacy templates.
- Automated validation testing of complex business models to eliminate runtime spreadsheet formulas errors.
How XLSX Works
- Tool Evaluation: The framework selects pandas for large-scale data modifications or openpyxl for detailed, cell-level formatting and formula assignments.
- Workbook Construction: The script initializes blank sheets or loads structural templates, placing inputs on the left/top and moving toward calculations and summaries.
- Formula Injection: Functional expressions like =SUM() or =AVERAGE() are written into target coordinates as native strings rather than hardcoded metrics.
- Recalculation Execution: The background automation engine invokes a headless LibreOffice process via an integrated recalculation script to process cell logic.
- Automated Auditing: The engine checks the cell output schema for errors like #REF!, #DIV/0!, or #VALUE! and reports locations via structured JSON.
XLSX Setup
Ensure that python, pandas, openpyxl, and LibreOffice are installed on your system environment.
# Navigate to the skill environment directory
cd xlsx_skill_directory
# Recalculate cell formulas and perform automated structural validation
python scripts/recalc.py path/to/target_workbook.xlsx 30
XLSX Data Schema & Taxonomy
The skill manages operations based on precise coordinate mappings, tracking dependencies between structured tables and core assumption configurations.
| Document Section | Implementation Rule | Operational Purpose |
|---|---|---|
| First Worksheet | Executive Dashboard / Summary | Displays key analytics, charts, and PivotTables first |
| Dedicated Worksheets | Named Data Tables & Calculations | Organizes lookups and isolated processes to prevent matrix contamination |
| Assumptions Block | Grouped Configuration Regions | Houses variables like growth rates in single cells to omit magic numbers |
All formula checks run against a structured validation schema that documents operational outcomes:
- status: Indicates overall processing health (
successorerrors_found). - total_errors: Aggregated count of breaking anomalies identified within the sheet matrix.
- error_summary: Nested dictionary highlighting error types along with precise coordinate arrays.
XLSX Advanced Features
- Headless Macro Recalculation: Utilizes a custom LibreOffice bridge script to trigger deep recalculations without launching standard graphical user interfaces.
- Automated Validation Loop: Conducts a comprehensive three-pass structural, formula, and content quality check before final delivery.
- Financial Standards Compliance: Detects financial layouts and automatically injects industry-standard text color mapping for hardcodes, formulas, and worksheets link structures.
- High-Performance Streaming: Implements read-only and write-only stream controls to seamlessly interact with massive files exceeding 50MB.
SKILL.md
Loading
Related Openclaw Skills
Word Document (DOCX) Manipulation
An advanced automation skill for creating, editing, and validating professional Word documents (.docx) via programmatic libraries and direct XML restructuring.
PPTX Skill
The PPTX Skill equips AI agents with advanced tools and automated workflows to read, edit, and programmatically construct professionally styled PowerPoint presentations from scratch.
Guanshi Deep Insight (DeepInsight)
Guanshi Deep Insight is a powerful analysis methodology engine that subjects strategic conclusions to rigorous three-layer causal drilling and Red Teaming verification.
Feishu Docs
A highly automated Open API skill that enables AI agents to read, write, format, and structure documents inside Feishu cloud drives with full OAuth token lifecycle management.
10x Talent School Management Framework
An AI-driven organizational framework designed for rapidly growing schools to systematically select, cultivate, deploy, and retain high-performing educators.
Family Meeting Assistant (Jiayu)
A warm, secure, and privacy-first family memory butler and communication facilitator that runs locally to archive memories, track growth, and structure family meetings.
Featured*
