xlsx - Create, edit, analyze, and recalculate Excel spreadsheets.
Processes .xlsx and .csv files by creating or editing spreadsheets with formulas and formatting, performing data analysis, and recalculating formulas.
Tags
Updated: 2026-09-24Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Create Excel spreadsheets
- Edit existing Excel spreadsheets
- Analyze data with pandas
- Apply cell formulas and formatting
- Recalculate formulas via LibreOffice
- Generate scientific schematic diagrams
Inputs
- Excel files (.xlsx)
- CSV files (.csv)
- Spreadsheet data and formulas
- Diagram descriptions
Outputs
- Modified Excel files (.xlsx)
- Formula recalculation JSON reports
- Generated schematic images (.png)
Requirements
- LibreOffice installed
- Python environment with pandas and openpyxl
- recalc.py script
- generate_schematic.py script
){kind=link}