What problem does it solve? Creating a well-structured Excel workbook from scratch—proper sheet layout, formulas, styling, conditional formatting, and error-free calculations—normally requires significant manual spreadsheet work. This Skill automates the entire pipeline: it infers the workbook title and output path, extracts content from reference attachments, applies proven design principles, writes an openpyxl build script, and validates that every formula computes without errors before delivery. ## Core Features & Use Cases - From-scratch XLSX generation: Builds complete workbooks with openpyxl when no source .xlsx/.csv file exists, covering record, plan, progress, statistics, form/print, dashboard, calendar, and calculation-model scenarios. - Reference-aware content: Accepts local PDF/DOCX/PPTX attachments (extracted to markdown via extract.py) and online Tencent Docs links as content or style references. - Formula validation via recalc: Recalculates the workbook with LibreOffice or a pure-Python fallback engine and reports formula errors (#REF!, #DIV/0!, etc.) so they can be fixed before delivery. - Use Case: Ask for a project budget tracker based on an attached PDF brief; the Skill extracts the reference data, designs detail and summary sheets with linked formulas and conditional formatting, generates the xlsx, and verifies zero formula errors. ## Quick Start Ask the agent to create an Excel workbook from scratch, for example: "Create a quarterly sales summary workbook with a detail sheet and a dashboard based on this attached PDF."
