xlsx

xlsx - Excel File Processing Automation Skills

Skill Overview

xlsx is an automation skill specialized in creating, editing, analyzing, and converting Excel files. It leverages Python libraries such as openpyxl and pandas to efficiently process spreadsheets, making it especially suitable for financial model building, batch report generation, data cleaning, and export.

Use Cases

1. Financial Model Building and Analysis

Suitable for scenarios that require building complex financial models, such as budgeting, financial forecasting, valuation analysis, and more. The skill supports using Excel formulas rather than hard-coded values, ensuring that the model can be updated dynamically. It also provides professional financial formatting standards and color-coding conventions.

2. Batch Report Generation and Data Processing

When you need to generate large numbers of Excel reports regularly or handle multiple workbooks, the xlsx skill can automate the entire workflow. It supports creating multi-sheet workbooks, linking data across sheets, applying batch formatting, and more—greatly improving efficiency.

3. Data Cleaning and Format Conversion

Ideal for converting various data sources (CSV, TSV, database exports, etc.) into standardized Excel formats. It offers end-to-end capabilities including data cleaning, formatting, formula insertion, and style application, ensuring the output files are professional and easy to use.

Core Features

1. Formula-Driven Excel Creation

Unlike simple data writing, xlsx emphasizes using Excel formulas instead of hard-coded calculation values. All computations (sum, percentages, ratios, growth rates, etc.) are performed through formulas, ensuring that results automatically update when source data changes. The skill also includes professional financial formatting standards, such as color coding (blue = input, black = formulas, green = cross-sheet links) and number formatting rules.

2. Multi-Workbook and Complex Formatting Support

Supports creating multi-sheet workbooks, applying professional formatting, setting conditional formatting, adjusting column widths and row heights, and more. It can read and modify existing Excel files while preserving the original formulas and formatting. In combination with LibreOffice’s formula recalculation feature, it ensures all formulas calculate correctly with no errors.

3. Data Analysis and Conversion Tools

Integrates pandas’ powerful data processing capabilities to support reading, cleaning, transforming, and exporting data. It can handle large datasets, supports multiple Excel formats (.xlsx, .xlsm, .xlsb), and includes error detection and repair mechanisms to ensure the output file contains zero formula errors.

Common Questions

What Excel file formats does the xlsx skill support?

xlsx supports multiple spreadsheet formats including .xlsx, .xlsm (macro-enabled workbooks), .xlsb (binary format), .xls, and .ods. It can also be used to convert and process CSV and TSV files when users need spreadsheet output.

How do you ensure Excel formulas calculate correctly?

The xlsx skill uses the accompanying scripts/recalc.py script to automatically recalculate all formulas via LibreOffice and scan for common errors such as #REF!, #DIV/0!, #VALUE!, and more. The script returns detailed information about error locations and types to facilitate repair and validation.

What scenarios is the xlsx skill not suitable for?

xlsx focuses on scenarios where Excel files are the primary deliverable. It is not intended for Word document processing, HTML report generation, independent Python script development, database ETL pipelines, or Google Sheets API integrations. If you need these capabilities, choose other specialized skills.