xlsx - Excel Spreadsheet Processing and Analysis
Comprehensive tool for creating, editing, analyzing, and recalculating Excel spreadsheets with formatting and formula validation.
Tags
Updated: 2026-09-23Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Create spreadsheets with dynamic formulas
- Edit existing spreadsheets preserving formulas
- Analyze data using pandas
- Recalculate formulas via script
- Validate zero formula errors
- Apply financial color coding standards
- Format number and text styles
Inputs
- User task requests
- Spreadsheet files (.xlsx, .csv, .tsv)
- Excel template files
- Python dependencies configuration
Outputs
- Generated or modified Excel files
- Formula recalculation JSON reports
- Data analysis summary reports
Requirements
- Python libraries (openpyxl, pandas, xlrd)
- LibreOffice system dependency
- Formula recalculation script (scripts/recalc.py)