What problem does it solve?
This Skill empowers users to create, edit, analyze, and manage spreadsheet files (.xlsx, .xlsm, .csv, .tsv) efficiently, handling complex formulas, formatting, and data analysis tasks.
Core Features & Use Cases
- Spreadsheet Creation & Editing: Generate new spreadsheets or modify existing ones, including adding data, formulas, and formatting.
- Data Analysis & Visualization: Utilize pandas for in-depth data analysis and prepare data for visualization.
- Formula Recalculation & Verification: Ensure all formulas are error-free and correctly calculated using a dedicated script.
- Use Case: Automatically generate a financial projection spreadsheet with complex formulas, apply industry-standard formatting, and verify all calculations are accurate before delivery.
Quick Start
Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula to sum the 'Revenue' column.