What problem does it solve? Building or editing Excel workbooks programmatically often produces broken formulas, clipped columns, stale cached values, and invalid XML. This Skill provides a disciplined workflow for creating, reading, and modifying .xlsx files through the officecli CLI so delivered spreadsheets are formula-correct, properly formatted, and visually verified. ## Core Features & Use Cases - Workbook creation and editing: Set cell values, formulas, number formats, column widths, named ranges, charts, pivot tables, conditional formatting, and data validation via officecli commands. - Reading and analysis: Inspect sheets with outline, text, HTML, and annotated views, plus CSS-like queries to find formula errors, placeholders, and broken references. - CSV/TSV bulk import: Load large datasets into sheets with the native import command or batched value-set operations. - Mandatory QA cycle: Validate files, query for Excel error types (#REF!, #DIV/0!, etc.), and audit rendered HTML output before delivery. - Use Case: Build a financial model with color-coded inputs, live formulas, charts, and print-ready page setup, then verify every formula's cached value before sending it to stakeholders. ## Quick Start Ask the assistant to create an Excel workbook with monthly revenue data, a SUM total formula, currency formatting, and a chart, then validate and preview it.
