xlsx-pro
Compétence pour manipuler les fichiers Excel (.xlsx, .xlsm, .csv, .tsv). Utiliser quand l'utilisateur veut : ouvrir, lire, éditer ou créer un fichier tableur ; ajouter des colonnes, calculer des formules, formater, créer des graphiques, nettoyer des données ; convertir entre formats tabulaires. Le livrable doit être un fichier tableur. NE PAS utiliser si le livrable est un document Word, HTML, script Python standalone, ou intégration Google Sheets.
Why use this skill?
Professional Excel automation for OpenClaw. Create, edit, and format XLSX/CSV files with live formulas and industry-standard financial styling.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/ricobaboule/xlsx-proWhat This Skill Does
xlsx-pro is a professional-grade Excel manipulation tool designed for OpenClaw agents. It serves as the primary engine for creating, reading, editing, and formatting spreadsheet files including .xlsx, .xlsm, .csv, and .tsv formats. Unlike generic data libraries, xlsx-pro mandates the use of native Excel formulas, ensuring that financial models, calculations, and data summaries remain dynamic and accurate. It integrates with LibreOffice to verify and recalculate complex formulas, guaranteeing that output files are free of errors like #REF! or #DIV/0!.
Installation
To integrate this skill into your OpenClaw environment, execute the following command in your terminal:
clawhub install openclaw/skills/skills/ricobaboule/xlsx-pro
Ensure you have the required dependencies installed:
pip install openpyxl pandas xlrd xlwt
For full functionality, specifically the headless recalculation of formulas, you must have LibreOffice installed on your host system.
Use Cases
- Financial Modeling: Building budgets or P&L statements using industry-standard color-coding and formatting (blue for inputs, black for formulas, etc.).
- Data Cleaning: Automating the standardization of raw exports into structured, professional tabular reports.
- Report Generation: Converting raw analytical data into formatted spreadsheets with charts and calculated metrics.
- Bulk Formatting: Applying consistent professional fonts and number formats across existing, legacy spreadsheet templates.
Example Prompts
- "Create a monthly budget forecast spreadsheet for Q3. Use blue text for variable inputs and black for all SUM and AVERAGE formulas. Ensure currency is formatted as $#,##0 and negatives use parentheses."
- "Open the file sales_data.xlsx, calculate the year-over-year growth for each category using a native Excel formula, and apply a 0.0% percentage format to the result columns."
- "Clean this provided CSV export: remove duplicate rows, format headers with a bold font, and add a formula in column E that multiplies column C by column D."
Tips & Limitations
- Always prioritize formulas: Never use Python to hardcode calculated results. Let Excel perform the math.
- Respect templates: If you are modifying an existing file, preserve all existing conventions, styles, and sheet structures.
- Formatting matters: Follow the standard industry code: inputs in blue, internal formulas in black, and key assumptions highlighted in yellow.
- Constraint: Do not use this skill for Word documents, HTML reports, or Google Sheets API integrations. This skill is exclusively for file-based spreadsheet management.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-ricobaboule-xlsx-pro": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: file-write, file-read, code-execution