What problem does it solve?
This Skill automates spreadsheet creation, editing, analysis, and conversion while reducing formula errors, formatting inconsistencies, and problems caused by manually calculated values.
Core Features & Use Cases
- Spreadsheet Creation and Editing: Build or modify XLSX, XLSM, CSV, and TSV files with pandas and openpyxl while preserving formulas, templates, and formatting.
- Formula Management: Use dynamic Excel formulas, recalculate them through LibreOffice, and detect errors such as #REF!, #DIV/0!, #VALUE!, and #N/A.
- Validation and Office Processing: Unpack, edit, validate, and repack Office files while checking XML structure, relationships, content types, and tracked-change integrity.
- Use Case: Create a financial model from source data with documented assumptions, professional formatting, dynamic projections, and verified formula results.
Quick Start
Use the xlsx skill to analyze the attached workbook, preserve its existing template, repair any formula errors, and return a validated spreadsheet.