skills.rest
dheejay282002
dheejay282002COMMUNITY
Explore all skills by this author →
WebsiteGitHub

excel-generator

Generate Excel spreadsheets with formulas, charts, pivot summaries, and financial models using Python.

Updated May 25, 2026
Search Tags:#openpyxl#spreadsheet#excel#xlsx#financial model#google sheets#xlsxwriter
One-click install
npx skills add https://github.com/dheejay282002/final_project --skill excel-generator-dheejay282002
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-generator
Source: https://github.com/dheejay282002/final_project/tree/main/.local/secondary_skills/excel-generator
Command: npx skills add https://github.com/dheejay282002/final_project --skill excel-generator-dheejay282002

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Manually building spreadsheets with formulas, formatting, charts, and financial models is slow and error-prone. This Skill programmatically generates .xlsx files, Google Sheets, and PDF exports with correct formulas, styling, and layout. ## Core Features & Use Cases - Spreadsheet Generation: Create .xlsx files with openpyxl or xlsxwriter, including formulas, number formats, conditional formatting, data validation, freeze panes, and charts. - Financial Models: Build 3-statement models, DCF valuations, LBO models, comp tables, and M&A accretion/dilution analyses with input/output cell conventions. - Pivot Summaries & Sensitivity Grids: Produce pandas-based or SUMIFS-based pivot-style summaries and one-way/two-way data table equivalents. - Google Sheets & PDF Export: Create and format Google Sheets via gspread, or convert workbooks to PDF with LibreOffice and print-layout settings. - Use Case: Ask for a DCF model for a public company; the Skill gathers real financials via web search, then outputs a formatted multi-sheet workbook with assumptions, projections, and a sensitivity grid. ## Quick Start Create an Excel sales report with a revenue chart, formatted headers, and a pivot-style summary sheet from my data.

Frequently Asked Questions about excel-generator

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

FAQPage Schema
How do I create an Excel file with formulas in Python?▼

Use xlsxwriter to write new files with ws.write_formula() or openpyxl to create and edit workbooks with formula strings like =SUM(A1:A10). Python stores formulas as strings; Excel computes the values when the file is opened.

openpyxl vs xlsxwriter: which should I use?▼

Use xlsxwriter for creating new files quickly, especially large ones, since it is write-only and memory-efficient. Use openpyxl when you need to read or modify an existing .xlsx file, since xlsxwriter cannot open existing workbooks.

Can Python create native Excel PivotTables?▼

No, Python libraries cannot create native Excel PivotTables because they require cached data. The equivalent is built with pandas pivot_table aggregation written to a sheet, or with SUMIFS formulas that stay dynamic in Excel.

How do I handle Excel files with over 100K rows in Python?▼

Use xlsxwriter with constant_memory: True for writing, or openpyxl in write_only mode for append-only output. For reading, use openpyxl read_only mode with batched row iteration to keep memory usage low.

Why does my formula cell show the formula text instead of the result?▼

Python writes formulas as strings and does not evaluate them; Excel computes results on open. When reading with openpyxl, use data_only=True to get the last cached value instead of the formula string.

How do I convert an xlsx file to PDF?▼

Use the LibreOffice CLI with libreoffice --headless --convert-to pdf for the best fidelity. Set print layout options like fitToWidth, margins, and repeated header rows in openpyxl or xlsxwriter before converting.

Related Skills

Explore More Finance & Accounting Skills→
TMYTiMidlYTMYTiMidlY
1

xlsx

Process Excel and CSV files to read, edit, validate, and convert tabular data.

Community
Advanced
starwreckntxstarwreckntx

immutable-audit-trail-archiving

Archive immutable audit trails with cryptographic hashing and timestamping.

Community
Advanced
vuanhtu1993vuanhtu1993

fact-check

Verify claims and assess source credibility across multiple sources.

Community
Intermediate
living-relationliving-relation

interactive-dashboard-builder

Build self-contained HTML dashboards with Chart.js and dropdown filters.

Community
Intermediate