What problem does it solve?
This Skill empowers users to create, edit, and analyze spreadsheet data efficiently, handling complex formulas, formatting, and data manipulation tasks.
Core Features & Use Cases
- Spreadsheet Creation: Generate new
.xlsx files with data, formulas, and custom formatting.
- Data Analysis: Read, analyze, and visualize data from existing spreadsheets using pandas.
- Formula Management: Ensure formula accuracy, preserve existing templates, and recalculate formulas using LibreOffice.
- Use Case: Analyze sales data from a CSV, create a new Excel report with charts, and ensure all financial formulas are error-free.
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.