spreadsheet

Topics in the source

• Spreadsheet Skill (Create, Edit, Analyze, Visualize)
• When to use
• Workflow
• Temp and output conventions
• Primary tooling
• Rendering and visual checks
• Dependencies (install if missing)
• Environment

Build new workbooks with formulas, formatting, and structured layouts. Read or analyze tabular data (filter, aggregate, pivot, compute metrics). Modify existing workbooks without breaking formulas or references. Visualize data with charts/tables and sensible formatting. IMPORTANT: System and user instructions always take precedence. 1. Confirm the file type and goals (create, edit, analyze, visualize). 2. Use openpyxl for .xlsx edits and pandas for analysis and CSV/TSV workflows. 3. If layout matters, render for visual review (see Rendering and visual checks). 4. Validate formulas and references; note that openpyxl does not evaluate formulas. 5. Save outputs and clean up intermediate files. Use tmp/spreadsheets/ for intermediate files; delete when done. Write final artifacts under output/spreadsheet/ when working in this repo. Keep filenames stable and descriptive. Use openpyxl for creating/editing .xlsx files and preserving formatting. Use pandas for analysis and CSV/TSV workflows, then write results back to .xlsx or .csv. If you need charts, prefer openpyxl.chart for native Excel charts. If LibreOffice (soffice) and Poppler (pdftoppm) are available, render sheets for visual revie

This is an excerpt. Refer to the complete source and its current requirements.