What This Skill Does
Create, edit, analyze, and format spreadsheets (.xlsx, .csv, .tsv) using Python with openpyxl and pandas. Preserves formulas, references, and formatting.
When to Use It
- Creating spreadsheets with formulas and formatting
- Analyzing data in existing spreadsheets
- Editing Excel files while preserving formulas
- Converting between tabular file formats
Key Features
Formula Preservation
Edit spreadsheets without breaking existing formulas and cell references.Formatting
Apply conditional formatting, cell styles, borders, and number formats programmatically.Data Analysis
Use pandas for analysis, then write results back to formatted Excel files.Best Practices
- Always preserve existing formulas when editing
- Verify formula results after modifications
- Use named ranges for complex spreadsheets
- Test with the target Excel version for compatibility