Xlsx

SKILL.md — /xlsx Corporate Workbook Generator

What It Does

Generates professional Excel workbooks (.xlsx) from structured input. Output is generated from the reference template at: .claude/skills/xlsx/templates/reference.xlsx

How to Invoke

/xlsx [workbook title] — [brief description of the workbook, sheets, and data it should contain]

The agent will generate a complete corporate workbook and recalculate formulas when needed.

---

Output

• File: output/[title]_YYYY-MM-DD.xlsx
• Format: Corporate workbook with a cover sheet plus styled data sheets
• Template: Loads .claude/skills/xlsx/templates/reference.xlsx directly and preserves its workbook styles, page setup, sheet layout, and header/footer behavior

---

Workbook Structure

Every generated workbook follows this structure:

1. COVER
   ├── Workbook title
   ├── Subtitle (if applicable)
   ├── Prepared by
   ├── Date
   ├── Classification
   └── Sheet index / notes

2. WORKSHEETS
   ├── Sheet title row
   ├── Header row with filters
   ├── Data rows
   └── Optional formulas / notes

---

Formatting Standards

• Template authority: The reference workbook controls the visual system
• Headers: Dark fill, white bold text
• Body cells: Clean corporate formatting
• Hardcoded inputs: Blue text
• Formulas: Black text
• Negative values: Prefer number formats with parentheses where appropriate
• Freeze panes: Header row remains visible
• Filters: Enabled on header rows

---

Generation Script

Use the provided generator: .claude/skills/xlsx/scripts/generate_corporate_xlsx.py

python3 .claude/skills/xlsx/scripts/generate_corporate_xlsx.py \
  --title "Fuel Oil Market Workbook" \
  --subtitle "Q1 2026 Benchmark Review" \
  --date "April 2026" \
  --classification "CONFIDENTIAL" \
  --prepared-by "BedRock AI Research" \
  --output output/fuel_oil_workbook.xlsx \
  --sheets-json '[
    {
      "name": "Key Metrics",
      "description": "Top-line findings and benchmark statistics",
      "headers": ["Metric", "Value", "Notes"],
      "rows": [
        ["MOC Window", "30 minutes", "Platts closing window"],
        ["Settlement", 1100000000, "2022 Glencore resolution"],
        ["Coverage", "=COUNTA(A4:A5)", "Formula example"]
      ]
    },
    {
      "name": "Trade Log",
      "description": "Observed transactions and flags",
      "headers": ["Date", "Counterparty", "Volume", "Flag"],
      "rows": [
        ["2026-03-01", "Firm A", 42000, "Review"],
        ["2026-03-02", "Firm B", 38000, "Escalate"]
      ]
    }
  ]'

---

Formula Recalculation

If the workbook contains formulas, recalculate it after generation:

python3 .claude/skills/xlsx/recalc.py output/fuel_oil_workbook.xlsx

The recalc helper:

• uses LibreOffice
• recalculates all formulas
• scans all sheets for Excel errors
• returns JSON describing any #REF!, #DIV/0!, #VALUE!, #NAME?, #N/A, or related issues

---

What the Agent Must Do

1. Determine the workbook structure from the request:

• What sheets are needed?
• What headers should each sheet have?
• Which cells should contain formulas instead of hardcoded calculations?

1. Gather / write content for each worksheet:

• Use real research or provided data
• Do not fabricate numbers
• Use formulas for derived values where appropriate

1. Call the generator script with structured sheets-json

1. Recalculate formulas when formulas are present

1. Verify the output:

• workbook opens without errors
• cover sheet metadata is populated
• headers, filters, and freeze panes are present
• formulas recalculate cleanly

---

Notes

• Always use the generator script for new corporate workbooks
• Use the reference template as the style authority
• Use formulas instead of hardcoded Python calculations whenever the value should stay dynamic
• Prerequisite: LibreOffice for formula recalculation

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: luckeyfaraday
• Source: luckeyfaraday/OpenGolem
• License: MIT
• Homepage: https://opengolem.netlify.app/

Install and usage instructions live in the source repository linked above.