# Xlsx

> Corporate workbook generation, spreadsheet editing, and formula recalculation for .xlsx files. Use when Claude needs to create professional Excel workbooks from structured input, preserve workbook templates, or recalculate formulas with LibreOffice.

- **Type:** Skill
- **Install:** `agentstack add skill-luckeyfaraday-opengolem-xlsx`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [luckeyfaraday](https://agentstack.voostack.com/s/luckeyfaraday)
- **Installs:** 0
- **Category:** [Data & Analytics](https://agentstack.voostack.com/c/data-and-analytics)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [luckeyfaraday](https://github.com/luckeyfaraday)
- **Source:** https://github.com/luckeyfaraday/OpenGolem/tree/main/.claude/skills/xlsx
- **Website:** https://opengolem.netlify.app/

## Install

```sh
agentstack add skill-luckeyfaraday-opengolem-xlsx
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 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

```text
/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:

```text
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`

```bash
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:

```bash
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?

2. Gather / write content for each worksheet:
   - Use real research or provided data
   - Do not fabricate numbers
   - Use formulas for derived values where appropriate

3. Call the generator script with structured `sheets-json`

4. Recalculate formulas when formulas are present

5. 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](https://github.com/luckeyfaraday)
- **Source:** [luckeyfaraday/OpenGolem](https://github.com/luckeyfaraday/OpenGolem)
- **License:** MIT
- **Homepage:** https://opengolem.netlify.app/

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

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-luckeyfaraday-opengolem-xlsx
- Seller: https://agentstack.voostack.com/s/luckeyfaraday
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.