excel-generator

Create formatted Excel spreadsheets with charts, themes, and conditional formatting using openpyxl.

Updated Aug 28, 2026
One-click install
npx skills add https://github.com/AnderHonorato/Mem-rias-IA---Infinity --skill excel-generator-anderhonorato
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: excel-generator
Source: https://github.com/AnderHonorato/Mem-rias-IA---Infinity/tree/main/Manus/Skills/excel-generator
Command: npx skills add https://github.com/AnderHonorato/Mem-rias-IA---Infinity --skill excel-generator-anderhonorato

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve? Raw data exports are hard to read and act on. This Skill turns structured data into polished, insight-ready Excel workbooks with consistent formatting, navigation, and built-in analysis so users can open the file and immediately understand it. ## Core Features & Use Cases - Four-Layer Workbook Design: Structure (sheet organization, layout, navigation), Information (number formats, data context, key insights), Visual (themes, typography, borders, charts), and Interaction (freeze panes, filters, hyperlinks, sorting). - Theme & Typography System: Twelve predefined color themes with serif/sans-serif font pairings, semantic colors, and row highlight tints applied consistently across the workbook. - Data Visualization: Bar/line/pie charts, data bars, color scales, sparklines, and conditional highlighting wired to theme colors via openpyxl. - Use Case: Given quarterly revenue data by region, generate a workbook with an Overview sheet containing key insights and a sheet index, a formatted data table with data bars, and a themed bar chart comparing regions. ## Quick Start Create an Excel workbook from my sales data with an overview sheet, formatted tables, and a revenue comparison chart.

Frequently Asked Questions about excel-generator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a formatted Excel file with Python?

Use openpyxl to build the workbook: set number_format on every numeric cell, apply Font, PatternFill, Border, and Alignment styles, hide gridlines, and add charts via openpyxl.chart. Structure sheets with an Overview first, then data and analysis sheets.

How do I add charts and conditional formatting to Excel with openpyxl?

Create BarChart, LineChart, or PieChart objects with Reference ranges for data and categories, then attach with ws.add_chart. For conditional formatting, use DataBarRule or ColorScaleRule from openpyxl.formatting.rule applied to cell ranges.

Why do Excel formula cells show raw decimal precision?

Formula results have no default number format in openpyxl, so they display full raw precision like 14.123456789. Always set number_format explicitly on formula cells, matching the column's format such as #,##0.0 or 0.0%.

When should I not use this Excel formatting approach?

Do not apply these aesthetics to finance deliverables such as DCF, LBO, comps, three-statement models, or DD trackers. Those outputs follow the finance-pro-playbooks excel_standards.md formatting authority instead.

How do I make large Excel tables easier to navigate?

Freeze panes below the header for tables over 10 rows, add auto_filter for tables over 20 rows, and include a hyperlinked sheet index on the Overview sheet when the workbook has three or more sheets.