skills.rest
Mo7amed-Mahmoud
Mo7amed-MahmoudCOMMUNITY
Explore all skills by this author →
GitHub

excel-generator

Generate and modify Excel workbooks with Python libraries.

Updated Apr 18, 2026
Search Tags:#charts#formulas#excel#xlsx#pivot#financial-models
One-click install
npx skills add https://github.com/Mo7amed-Mahmoud/ZeinaGuard-Pro --skill excel-generator-mo7amed-mahmoud
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Finance & Accounting Skills→
Wesley1600Wesley1600

Python Script Skill Template

Executes Python scripts that process CLI input and return JSON-formatted results.

Community
Basic
vasilyu1983vasilyu1983
73

document-xlsx

Create, edit, and analyze Excel workbooks with formulas and charts.

Community
Advanced
CrumbgrabberCrumbgrabber
3

excel-analysis

Analyze and manipulate Excel spreadsheet data using pandas and openpyxl.

Community
Intermediate
xpert-aixpert-ai
8

spreadsheets

Create and modify .xlsx, .xls, .csv, and .tsv spreadsheets with formulas and charts.

Official
Advanced