xlsx-manipulation

What This Skill Does

The xlsx-manipulation skill is a powerful extension for OpenClaw that enables users to interact with Microsoft Excel files (.xlsx) programmatically. By leveraging the industry-standard openpyxl library, this skill allows the agent to create, modify, format, and extract data from complex spreadsheets. Whether you are generating a professional financial report, automating recurring data entry tasks, or applying conditional logic to large datasets, this skill serves as your virtual spreadsheet engineer.

Installation

You can integrate this skill into your OpenClaw environment by executing the following command in your terminal: clawhub install openclaw/skills/skills/lijie420461340/xlsx-manipulation

Use Cases

This skill is ideal for professionals dealing with repetitive spreadsheet management. Common use cases include:

• Automating the generation of weekly financial reports.
• Applying corporate branding and formatting templates to raw data exports.
• Programmatically injecting complex Excel formulas into calculated columns.
• Building automated dashboards that update based on incoming raw data streams.
• Validating and cleaning data structures within existing workbook files.

Example Prompts

1. "Create a monthly budget tracker that calculates the remaining balance and highlights negative results in red using conditional formatting."
2. "Take this sales data, generate a summary table grouped by product category, and add a bar chart to visualize the total revenue per category."
3. "Apply a professional header style with bold, blue text and a grey background to the first row of 'data.xlsx', and ensure all columns are auto-resized for readability."

Tips & Limitations

• Efficiency: While openpyxl is excellent for structural manipulation, extremely large datasets (millions of rows) may require substantial memory. If you are handling massive files, consider performing pre-processing or using read-only/write-only modes.
• Compatibility: This skill is strictly designed for .xlsx files. It does not support legacy .xls or binary .xlsb formats.
• Formulas: When using formulas, remember that openpyxl writes the formula string to the cell. Excel will calculate the result upon opening the file, but the agent cannot 'see' the calculated value unless an Excel-compatible calculation engine is also present.
• Formatting: Complex formatting chains are supported, but always verify your color codes and border types against the openpyxl documentation for perfect accuracy.