excel-generator

What problem does it solve?

This Skill automates the creation of professional Excel spreadsheets, including formatting, formulas, charts, and data validation, eliminating manual spreadsheet creation and complex data manipulation.

Core Features & Use Cases

• Generate New Spreadsheets: Create .xlsx files from scratch with advanced formatting and formulas using libraries like xlsxwriter or openpyxl.
• Modify Existing Spreadsheets: Read and update existing .xlsx files.
• Data Visualization: Embed charts (bar, line, pie) directly into spreadsheets.
• Data Validation: Implement dropdown lists and other validation rules.
• Use Case: Generate a monthly sales report with dynamic formulas, conditional formatting, and a summary chart, all from Python.

Quick Start

Use the excel-generator skill to create a new Excel file named 'sales_report.xlsx' with headers 'Product', 'Units', 'Price', and 'Revenue', and populate it with the provided data.