excel-generator

Generate and modify Excel workbooks with Python libraries.

Updated Apr 18, 2026

Search Tags:#charts #formulas #excel #xlsx #pivot #financial-models

Ready to run

npx skills add https://github.com/Mo7amed-Mahmoud/ZeinaGuard-Pro --skill excel-generator-mo7amed-mahmoud

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: excel-generator
Source: https://github.com/Mo7amed-Mahmoud/ZeinaGuard-Pro/tree/main/.local/secondary_skills/excel-generator
Command: npx skills add https://github.com/Mo7amed-Mahmoud/ZeinaGuard-Pro --skill excel-generator-mo7amed-mahmoud

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Excel workbooks and data in spreadsheets often require repetitive formatting, hard-coded formulas, and manual charting. This Skill automates the creation and modification of .xlsx files, including formulas, charts, data validation, and financial models.

Core Features & Use Cases

Create new .xlsx from scratch and large files with formatting and charts.
Read/modify existing .xlsx and read legacy .xls files.
Generate formatted reports by quickly exporting to PDF or Google Sheets, and build pivot-like summaries using formulas.

Quick Start

Create a new workbook with a header row, a few data rows, and a bar chart.

Frequently Asked Questions about excel-generator

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

FAQPage Schema

How do I automatically generate Excel workbooks with formulas and charts?▼

To generate Excel workbooks with formulas and charts, this Skill automates .xlsx file creation and modification using Python libraries like openpyxl, xlsxwriter, and pandas to apply formatting, build financial models, and insert charts programmatically.

Can I modify existing .xlsx files and read legacy .xls spreadsheets?▼

Yes, you can modify existing .xlsx files and read legacy .xls spreadsheets. The Skill reads and updates existing workbooks while applying new formatted reports, data validation, and pivot-like summaries using formulas.

Does this Skill support exporting Excel reports to PDF or Google Sheets?▼

Yes, this Skill supports exporting Excel reports to PDF or Google Sheets. It uses optional export capabilities alongside openpyxl and xlsxwriter to quickly convert formatted spreadsheet data into PDF documents or Google Sheets formats.

What Python libraries do I need to create formatted spreadsheets and pivot summaries?▼

To create formatted spreadsheets and pivot summaries, you need Python libraries such as openpyxl, xlsxwriter, and pandas. These dependencies enable the Skill to generate .xlsx workbooks, apply financial formulas, and build data charts.

What is the best way to automate financial modeling and data transformation workflows in Excel?▼

The best way to automate financial modeling and data transformation workflows in Excel is using this Skill to programmatically apply formulas, generate charts, and create pivot-like summaries directly within .xlsx workbooks without manual formatting.