skills.rest
yethikrishna
yethikrishnaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create formula-driven Excel workbooks with openpyxl and LibreOffice headless.

Updated Apr 16, 2026
Search Tags:#formatting#openpyxl#excel#libreoffice#financial-modeling#recalc#pivot-table
One-click install
npx skills add https://github.com/yethikrishna/humble --skill xlsx-yethikrishna
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/yethikrishna/humble/tree/main/core/kortix-master/opencode/skills/GENERAL-KNOWLEDGE-WORKER/xlsx
Command: npx skills add https://github.com/yethikrishna/humble --skill xlsx-yethikrishna

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

Provides a complete, production-ready workflow for creating, formatting, validating, and delivering Excel workbooks so users avoid manual formatting, broken formulas, and non-recalculating snapshots.

Core Features & Use Cases

  • Formula-first models: Write live formulas (no hardcoded derived values) and enforce number formats, color conventions, alignment, and column widths for professional deliverables.
  • Validation & Recalculation: Drive LibreOffice headless to recalculate formulas and scan workbooks for Excel errors, returning structured diagnostics.
  • Pivot automation: Create and remove real, interactive pivot tables via LibreOffice DataPilot while preserving workbook tables and styles.
  • Use Case: Build a 3-sheet financial model with assumptions, projections, and an overview dashboard, add pivot analyses from raw data, run a recalc pass, and deliver an error-free, presentation-ready workbook.

Quick Start

Generate a three-sheet financial model from sales.csv with assumptions, projections, and a summary dashboard, then run the recalculation and pivot scripts to validate formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create Excel workbooks with live formulas instead of hardcoded values?▼

To create Excel workbooks with live formulas, use openpyxl to generate formula-driven sheets rather than static values, ensuring calculations update dynamically and remain error-free across your reporting models.

How do I automate Excel recalculation and error checking for financial models?▼

Automate Excel recalculation by driving LibreOffice headless to recalculate formulas and scan workbooks for Excel errors, returning structured diagnostics that validate your financial model results.

Can I create interactive pivot tables in Excel using openpyxl?▼

Yes, you can create interactive pivot tables by driving LibreOffice DataPilot while preserving workbook tables and styles, as openpyxl alone does not support direct pivot table creation.

Does openpyxl support applying professional number formats and Excel Table objects?▼

Yes, openpyxl supports applying professional number formats, color conventions, Excel Table objects, freeze panes, and charts to produce structured, presentation-ready Excel sheets.

What is the best way to build a financial model dashboard with multiple sheets in Excel?▼

The best way to build a financial model dashboard is generating a multi-sheet workbook with assumptions, projections, and an overview dashboard, then running a recalculation pass to validate formulas.

Related Skills

Explore More Finance & Accounting Skills→
bingran-youbingran-you
3

xlsx

Create, edit, validate, and recalculate Excel workbooks with openpyxl.

Community
Intermediate
blueskies1818blueskies1818
1

pptx-author

Generate PowerPoint decks from Excel data using python-pptx.

Community
Intermediate
CrumbgrabberCrumbgrabber
3

excel-analysis

Analyze and manipulate Excel spreadsheet data using pandas and openpyxl.

Community
Intermediate
hotriluanhotriluan

ck:xlsx

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

Community
Intermediate