xlsx

What problem does it solve? Spreadsheet tasks often fail silently: formulas written by scripts never get calculated, modern Excel functions break in other runtimes, and edited files lose their formatting or external links. This Skill provides a disciplined workflow for producing spreadsheet files that actually recalculate, contain zero formula errors, and follow professional financial-modeling conventions. ## Core Features & Use Cases - Spreadsheet creation and editing: Build or modify .xlsx, .xlsm, .xltx, .csv, and .tsv files with openpyxl for formulas and formatting, or pandas for bulk data movement. - Mandatory formula recalculation: The bundled recalc.py script drives LibreOffice headlessly to compute every formula, then reports JSON with error counts and exact cell locations for #VALUE!, #REF!, #NAME?, and other failures. - Data cleaning and conversion: Restructure messy tabular data (malformed rows, misplaced headers) into proper spreadsheets, and convert between tabular formats. - Use Case: A user asks to build a revenue forecast workbook. The Skill writes SUMIFS and INDEX/MATCH formulas (avoiding unsupported functions like XLOOKUP), applies blue-input/black-formula color conventions, runs recalc.py until zero errors remain, and delivers a workbook that recalculates when inputs change. ## Quick Start Use the xlsx skill to create a quarterly budget spreadsheet with formulas for totals and then verify it has no formula errors.