skills.rest
Sir-chawakorn
Sir-chawakornCOMMUNITY
Explore all skills by this author →
GitHub

build-spreadsheet

Generates and modifies Excel XLSX workbooks with formulas, conditional formatting, and charts using openpyxl Python library.

9|3|Updated Jun 13, 2026
Search Tags:#automation#openpyxl#spreadsheet#excel#financial-modeling#data-reporting
One-click install
npx skills add https://github.com/Sir-chawakorn/sanook-cli --skill build-spreadsheet
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: build-spreadsheet
Source: https://github.com/Sir-chawakorn/sanook-cli/tree/main/skills/build-spreadsheet
Command: npx skills add https://github.com/Sir-chawakorn/sanook-cli --skill build-spreadsheet

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This skill solves the challenge of manually creating complex, data-rich Excel files by automating the generation of workbooks, formulas, and charts directly from your data.

Core Features & Use Cases

  • Dynamic Workbook Generation: Create multi-sheet Excel files with custom formatting, conditional rules, and native charts.
  • Formula Automation: Inject live Excel formulas like SUM, VLOOKUP, and custom logic that recalculate automatically when the file is opened.
  • Use Case: Ideal for financial modeling, automated reporting, or converting raw data exports into structured, presentation-ready dashboards.

Quick Start

Use the build-spreadsheet skill to create a new workbook named sales_report.xlsx that includes a summary sheet with formulas pulling from a detail tab.

Frequently Asked Questions about build-spreadsheet

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

FAQPage Schema
How do I automate Excel workbook generation with formulas and charts?▼

You can automate Excel workbook generation by using the openpyxl library to programmatically create XLSX files, inject live formulas, and add native charts. This approach enables dynamic financial modeling and multi-sheet reporting without manual formatting.

Can I inject live Excel formulas that recalculate automatically when the file is opened?▼

Yes, you can inject live Excel formulas like SUM and VLOOKUP into cells programmatically. These formulas are written directly into the XLSX structure and will recalculate automatically when the workbook is opened in Excel.

Does openpyxl support conditional formatting and multi-sheet cross-referencing for financial modeling?▼

Yes, openpyxl supports applying conditional formatting rules and cross-referencing data across multiple sheets. This allows you to build complex financial models and structured data reports with cell-level styling.

What is the best way to convert raw data exports into presentation-ready Excel dashboards?▼

The best way to convert raw data exports into dashboards is programmatically generating a multi-sheet XLSX workbook. You can structure raw data on a detail tab and use formulas to pull summarized metrics into a presentation-ready summary sheet.

Do I need Python and openpyxl installed to create Excel files programmatically?▼

Yes, you need a Python environment with the openpyxl package installed to handle programmatic Excel file manipulation. This dependency is required to validate structures and generate XLSX workbooks with formulas and formatting.

Related Skills

Explore More Finance & Accounting Skills→
xukrutdonutxukrutdonut

excel

Read, write, format, merge, and export Excel workbooks to CSV, JSON, or Markdown.

Community
Intermediate
vadimcomanescuvadimcomanescu
24

xlsx

Create, edit, and analyze .xlsx spreadsheets while preserving templates and formulas.

Community
Advanced
benchflow-aibenchflow-ai
317

xlsx

Create and modify Excel spreadsheets with pandas and openpyxl.

Official
Advanced
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate