xlsx

name	xlsx
description	Excel spreadsheet generation using openpyxl and xlsxwriter. Convert Claude output, data analysis results, and tabular data into formatted .xlsx files with charts, formulas, conditional formatting, and multiple sheets. Use for generating Excel reports programmatically.
version	1.0.0
model	sonnet
invoked_by	both
user_invocable	true
tools	["Bash","Read","Write","Edit"]
best_practices	["Use openpyxl for reading/modifying existing files","Use xlsxwriter for creating new files with advanced formatting","Never mix openpyxl and xlsxwriter on the same file","Always close xlsxwriter workbooks to flush output","Use named styles for consistent formatting across sheets"]
error_handling	graceful
streaming	not_applicable
verified	true
lastVerifiedAt	"2026-03-15T00:00:00.000Z"
source	builtin
trust_score	100
provenance_sha	4658c37a3793b006

Excel Spreadsheet Generation (xlsx)

Overview

Generate .xlsx files programmatically to export data, build reports, and create dashboards. Two primary libraries:

• openpyxl — read/write/modify existing Excel files, formula support, full feature set
• xlsxwriter — write-only, high-performance for large datasets, richer chart/format API

When to Invoke

Skill({ skill: 'xlsx' }) when:

• User asks to "export to Excel", "create a spreadsheet", or "generate a report in Excel"
• Converting tabular data, query results, or analysis output to .xlsx
• Building financial models, dashboards, or structured reports
• Creating templated Excel outputs for recurring workflows

Installation

pip install openpyxl xlsxwriter
# or
uv add openpyxl xlsxwriter

Quick Start (openpyxl)

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
from openpyxl.utils import get_column_letter

wb = Workbook()
ws = wb.active
ws.title = "Sales Report"

# Headers
headers = ["Product", "Q1", "Q2", "Q3", "Q4", "Total"]
for col, header in enumerate(headers, 1):
    cell = ws.cell(row=1, column=col, value=header)
    cell.font = Font(bold=True, color="FFFFFF")
    cell.fill = PatternFill(start_color="1F497D", fill_type="solid")
    cell.alignment = Alignment(horizontal="center")

# Data rows
data = [
    ("Widget A", 45000, , , ),
    (, , , , ),
    (, , , , ),
]
 row_idx, row  (data, ):
     col_idx, value  (row, ):
        ws.cell(row=row_idx, column=col_idx, value=value)
    
    ws.cell(row=row_idx, column=, value=)


 col  ws.columns:
    max_len = (((cell.value  ))  cell  col)
    ws.column_dimensions[get_column_letter(col[].column)].width = max_len + 

wb.save()