A high-performance Python library for reading and writing Microsoft Excel spreadsheets with support for complex components and large datasets.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excelize
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 excelize 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 Excelize?
Excelize is a comprehensive Python port of the renowned Go Excelize library, specifically engineered for manipulating Microsoft Excel files including XLAM, XLSM, XLSX, XLTM, and XLTX formats. It provides a robust set of functions that allow developers to build complex spreadsheet automation workflows within Openclaw Skills environments.
This tool stands out for its high compatibility with Microsoft Excel 2007 and later, offering a streaming API that enables efficient processing of massive worksheets without exhausting system resources. Whether you are generating reports from scratch or parsing existing data, this skill ensures data integrity and high performance for professional-grade automation.
Excelize Use Cases
- Generating automated business reports and financial statements.
- Migrating data between legacy systems and modern spreadsheet formats.
- Processing large-scale datasets using the high-performance streaming API.
- Enhancing spreadsheets with visual elements like 3D charts and images.
- Reading and extracting specific cell data for automated data analysis pipelines.
How Excelize Works
- Initialize a new spreadsheet instance or open an existing Excel file using the library core functions.
- Create or manipulate worksheets by adding data to specific cell coordinates or entire rows.
- Apply advanced formatting or insert complex components such as charts, pictures, and rich text.
- Set the active worksheet and configure printing or display options for the user.
- Save the final document to a specified file path and close the file handle to ensure proper resource management within the Openclaw Skills workflow.
Excelize Setup
To integrate this tool into your environment using Openclaw Skills, ensure you have Python 3.9 or later installed. Install the package via pip:
pip install excelize
Excelize Data Schema & Taxonomy
Excelize manages data through a structured hierarchy reflecting the Office Open XML standard. The following table outlines the primary data components:
| Component | Description |
|---|---|
| File Handle | The primary object representing the entire Excel workbook. |
| Worksheets | Individual sheets identified by name or index. |
| Cells | Data storage units addressed by coordinates (e.g., A1, B2). |
| Graphics | External objects like images and charts embedded via specific options. |
| Metadata | Document properties and cell styles stored within the XML structure. |
Excelize Advanced Features
- High-performance streaming API specifically designed for generating or reading worksheets with massive data volumes.
- Comprehensive support for complex chart generation including 3D clustered column charts directly from Python.
- Advanced image insertion capabilities with custom scaling, offsets, and aspect ratio locking.
- Full support for reading and writing spreadsheet documents generated by Microsoft Excel 2007 and later.
- Highly compatible with Openclaw Skills for multi-agent data processing and automated reporting tasks.
SKILL.md
Loading
Related Openclaw Skills
Algernon Review
An interactive AI-powered flashcard review session utilizing the FSRS-4.5 spaced repetition algorithm for peak memory retention.
SEO Monitoring
A technical framework for building a holistic SEO data analysis system to monitor indexing, traffic, keywords, and backlinks.
LI.FI MCP Skill
A powerful cross-chain bridge and DEX aggregation skill for discovering optimal routes, generating quotes, and performing wallet prechecks via the LI.FI protocol.
Eudic OpenAPI Language Assistant
A comprehensive interface for managing multilingual vocabulary, study lists, and personal language notes across Eudic, Frdic, Dehelper, and Eshelper.
Journal SCI/SSCI Checker
A specialized tool to verify if psychology journals are indexed in SCI or SSCI databases to ensure high academic standards.
Whop
A comprehensive toolkit for managing and scaling Whop businesses, from offer optimization to advanced API automation.
Featured*
