Excel / XLSX

Overview

Read, write, and generate Excel files with correct types, dates, formulas, and cross-platform compatibility. This skill handles type coercion, date serialization, formula evaluation, and cross-platform quirks.

Key Features

• Correctly handles Excel file types (.xlsx, .xls, .xlsm)
• Coerces types, serializes dates, and evaluates formulas
• Cross-platform compatible
• Handles merged cells, hidden rows/columns, and external references

How It Works

This skill uses a memory-based architecture, storing user preferences and tools in ~/excel-xlsx/. The skill follows a set of core rules to ensure correct file processing.

Use Cases

• Reading and writing Excel files for data analysis
• Generating Excel files for reporting and presentation
• Handling large Excel files with streaming readers
• Ensuring cross-platform compatibility for Excel files