A professional-grade skill for automating complex Excel workflows, including formula recalculation, financial modeling, and data visualization.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install lhx1112
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 lhx1112 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 Master?
The XLSX skill for Openclaw Skills provides a robust framework for interacting with spreadsheet data across formats like .xlsx, .xlsm, .csv, and .tsv. It bridges the gap between Python's data processing power and Excel's dynamic environment by emphasizing the use of live formulas over static hardcoded values. This ensures that any generated or modified workbook remains fully interactive for the end user.
Designed with high-stakes environments in mind, such as financial modeling and data science, this skill adheres to strict industry standards for color coding, number formatting, and error prevention. By leveraging powerful libraries like pandas for analysis and openpyxl for granular formatting, it allows AI agents to produce spreadsheets that are not just data dumps, but professional assets ready for executive review.
XLSX Spreadsheet Master Use Cases
- Generating complex financial models with dynamic projections and standardized industry color coding.
- Automating the migration of data from CSV/TSV formats into formatted Excel reports with summaries.
- Auditing existing spreadsheets for formula errors like #REF!, #DIV/0!, and circular references.
- Performing bulk data analysis and visualization on multi-sheet workbooks using pandas.
- Updating existing templates while strictly preserving original styles, conventions, and established patterns.
How XLSX Spreadsheet Master Works
- Tool Selection: The agent evaluates the task to choose between pandas (for heavy data manipulation) or openpyxl (for formulas and styling).
- Workbook Initialization: A new workbook is created or an existing template is loaded into memory, preserving all metadata.
- Data & Formula Injection: Data is populated and logic is applied using Excel-native formulas (e.g., =SUM(), =AVERAGE()) to maintain dynamism.
- Professional Styling: Industry-standard formatting is applied, such as blue text for inputs and black for formulas.
- Formula Recalculation: The skill triggers a dedicated recalculation script (recalc.py) using LibreOffice to evaluate all formula strings into actual values.
- Validation: A final JSON error report is generated to verify the absence of calculation errors before delivery.
XLSX Spreadsheet Master Setup
Ensure you have the necessary Python libraries and LibreOffice installed for full functionality within Openclaw Skills.
# Install required Python dependencies
pip install pandas openpyxl
# The recalculation script handles LibreOffice configuration on its first run
python recalc.py your_spreadsheet.xlsx
XLSX Spreadsheet Master Data Schema & Taxonomy
The skill organizes data based on standard Excel object hierarchies and financial modeling best practices:
| Component | Description | Metadata/Style |
|---|---|---|
| Inputs | Hardcoded user assumptions | Blue Text (RGB: 0,0,255) |
| Calculations | Dynamic Excel formulas | Black Text (RGB: 0,0,0) |
| Internal Links | References to other sheets | Green Text (RGB: 0,128,0) |
| External Links | References to other files | Red Text (RGB: 255,0,0) |
| Warnings | Cells requiring attention | Yellow Background |
All currency follows $#,##0 formatting, and years are treated as text strings to prevent unintended mathematical operations.
XLSX Spreadsheet Master Advanced Features
- Automated Recalculation Engine: Uses an integrated LibreOffice headless mode to solve formulas without opening the Excel GUI.
- Template Preservation: Intelligence to detect and mimic existing workbook styles, ensuring seamless integration with corporate templates.
- Comprehensive Error Auditing: Detailed JSON output of all formula errors (#VALUE!, #NAME?, etc.) with exact cell coordinates.
- Large Dataset Handling: Support for read_only and write_only modes in openpyxl to process massive workbooks efficiently.
- Data Source Documentation: Automatic placement of source comments for hardcoded values to ensure auditability.
SKILL.md
Loading
Related Openclaw Skills
Stock Monitor Pro
A professional-grade intelligent stock monitoring and alert system designed to track market anomalies and technical indicators with multi-condition resonance.
Xiaohongshu Search
A browser-based automation skill designed to search Xiaohongshu notes, extract engagement data, and analyze consumer trends for market research.
Downloader
A streamlined automation skill designed to download and store remote resources from any HTTP/HTTPS URL directly to a local directory.
Podcast Gen
An automated podcast generator that scrapes the latest news, writes oral-friendly scripts, and synthesizes high-quality audio using semantic voice matching.
Memory Manager
A sophisticated dual-track memory system that prevents AI context loss through automated daily journaling and long-term knowledge distillation.
NotebookLM PDF Cleaner
A precision tool designed to mask the NotebookLM footer badge on exported slide-decks for a professional, presentation-ready finish.
Featured*
