What problem does it solve?
This Skill eliminates the tedious manual work of creating, editing, and analyzing spreadsheets, especially with complex formulas and formatting, saving you hours and reducing errors.
Core Features & Use Cases
- Comprehensive Spreadsheet Management: Create new Excel files, modify existing ones, and analyze data with full support for formulas, formatting, and data analysis.
- Mandatory Formula Recalculation: Automatically recalculate all formulas and verify for common errors (e.g., #REF!, #DIV/0!), ensuring data integrity.
- Use Case: Automatically generate a detailed financial report in Excel, populating it with data, applying industry-standard formatting, and ensuring all formulas are correct and error-free before delivery.
Quick Start
Example: Read, modify, and save an Excel file
import pandas as pd
from openpyxl import load_workbook
Read data with pandas for analysis
df = pd.read_excel('input.xlsx')
print(df.head())
Load workbook with openpyxl to preserve formulas/formatting
wb = load_workbook('input.xlsx')
sheet = wb.active
sheet['A1'] = 'Updated Header' # Modify a cell
wb.save('output.xlsx')
CRITICAL: Recalculate formulas and check for errors
python recalc.py output.xlsx
