xlsx Agent Skills - Data & Analytics

🎯 What is xlsx?

A powerful skill for creating, editing, and analyzing spreadsheets (.xlsx, .xlsm, .csv, .tsv). It supports complex formulas, formatting, data analysis, and visualization to maintain dynamic, error-free Excel models.

⚡ Key Features

• Create new spreadsheets with formulas and precise formatting
• Read and analyze data using pandas
• Modify existing files while preserving formulas and styles
• Perform data analysis and visualization within Excel
• Recalculate formulas reliably using LibreOffice automation
• Enforce standardized financial modeling color and number formatting conventions

🛠️ Tech Stack

• Python libraries: openpyxl for Excel file manipulation, pandas for data analysis
• LibreOffice for formula recalculation

📋 Installation

• Ensure Python with openpyxl and pandas installed
• LibreOffice installed for formula recalculation scripts
• Use provided recalc.py for dynamic formula evaluation

⚠️ Important Notes

• Zero formula errors mandatory (#REF!, #DIV/0! etc.)
• Preserve existing template style and conventions when editing
• Always use Excel formulas, not hardcoded values, to keep models dynamic
• Follow strict financial modeling standards for colors and number formatting

❓ Common Issues

• Watch for invalid cell references causing #REF!
• Division by zero (#DIV/0!) must be handled defensively
• Formula errors due to wrong data types (#VALUE!) or unrecognized names (#NAME?)
• Ensure cross-sheet and external links are correct
• Test formulas with edge cases including zeros and negative values

🚀 This skill empowers precise, professional-grade spreadsheet workflows with automation and financial model best practices.