xlsx-writer

Generates structured Excel workbooks with KPI bands, tables, and formatting.

4|10|Updated Feb 20, 2026
One-click install
npx skills add https://github.com/Stratio/genai-agents --skill xlsx-writer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx-writer
Source: https://github.com/Stratio/genai-agents/tree/main/shared-skills/xlsx-writer
Command: npx skills add https://github.com/Stratio/genai-agents --skill xlsx-writer

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Spreadsheets often lack structure and consistency, leading to errors, inconsistent formatting, and hard-to-maintain reports. This skill enforces a design-first approach to generate polished, production-ready Excel workbooks with KPI bands, tables, and standardized styling.

Core Features & Use Cases

  • KPI bands with merged cells and theme-driven styling for executive summaries.
  • Native OpenPyxl Tables with autofilter, banding, and preserved formatting on updates.
  • Freeze panes, explicit column widths, and controlled row heights to ensure readable reports.
  • Use Case: produce a six-sheet analytical workbook (Cover, Parameters, Detail per dimension, and Appendix) from raw data, then reuse the same blueprint for batch exports.

Quick Start

Start by creating a new workbook scaffold and populate a Cover sheet with KPI bands using the design tokens.

Frequently Asked Questions about xlsx-writer

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

FAQPage Schema
How do I generate structured Excel workbooks with KPI bands and consistent formatting?

You can generate structured Excel workbooks by applying design tokens, KPI styling, and native Tables with autofilter and banding. This approach ensures consistent formatting across cover sheets, detail sheets, and appendices for analytical deliverables.

What is the best way to automate standardized Excel report generation from raw data?

Automating standardized Excel report generation involves creating a multi-sheet workbook scaffold with explicit column widths and freeze panes. You can populate a Cover sheet with KPI bands and reuse the same blueprint for batch exports.

Does openpyxl support native Tables with preserved formatting during workbook updates?

Yes, openpyxl supports native Tables with autofilter, banding, and preserved formatting during updates. It allows you to implement design tokens, KPI styling, and conditional formatting to maintain structured layouts.

How do I convert legacy XLS files to structured XLSX workbooks?

You can convert legacy XLS files to structured XLSX workbooks using structural operations that support format conversion. This process transforms outdated files into production-ready workbooks with standardized styling and KPI bands.

Can I use design tokens to enforce styling consistency across multiple Excel sheets?

Yes, you can use design tokens to enforce styling consistency across multiple Excel sheets. Design tokens drive KPI styling and theme-driven formatting for executive summaries, ensuring readable reports with controlled row heights.

What are the limitations of manually formatting complex analytical Excel workbooks?

Manually formatting complex analytical Excel workbooks often leads to errors, inconsistent formatting, and hard-to-maintain reports. Using a design-first approach with post-build validation and structural operations mitigates these limitations.