excel-processor

What problem does it solve?

This Skill automates the creation, editing, and analysis of Excel files, eliminating manual data entry, formula creation, and chart generation.

Core Features & Use Cases

• Data Manipulation: Read and write cell data, rows, and columns.
• Formula Generation: Automatically create formulas like SUM and VLOOKUP.
• Chart Creation: Generate various chart types (bar, line, pie).
• Styling & Formatting: Apply colors, fonts, conditional formatting, and more.
• Data Analysis: Perform aggregations and create pivot tables.
• Use Case: Automatically generate a monthly sales report by reading raw sales data, calculating totals and averages, and creating a bar chart to visualize performance.

Quick Start

Use the excel-processor skill to create a new Excel file named 'sales_report.xlsx' with columns 'Product' and 'Sales', then add rows for 'Laptop' with sales 1200 and 'Keyboard' with sales 300.