Skill · em Documentar e entregar

spreadsheet

Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified.

Procedência

Antes de instalar

9 arquivos · 28,4 KB · inclui 4 scripts que executam: references/examples/openpyxl/create_basic_spreadsheet.py, references/examples/openpyxl/create_spreadsheet_with_styling.py, references/examples/openpyxl/read_existing_spreadsheet.py, references/examples/openpyxl/styling_spreadsheet.py

Instalar na sua CLI

O comando baixa a versão fixada (commit 57f899e) direto da origem, para a pasta que a CLI lê. Precisa de curl (macOS e Linux); no Windows não há comando, porque o Rook Labs é para macOS.

Claude Code

Neste projeto: instala em .claude/skills/spreadsheet/.

d=".claude/skills/spreadsheet"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/document-processing/spreadsheet"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/agents/openai.yaml" "$u/agents/openai.yaml" \
  -o "$d/assets/spreadsheet-small.svg" "$u/assets/spreadsheet-small.svg" \
  -o "$d/assets/spreadsheet.png" "$u/assets/spreadsheet.png" \
  -o "$d/LICENSE.txt" "$u/LICENSE.txt" \
  -o "$d/references/examples/openpyxl/create_basic_spreadsheet.py" "$u/references/examples/openpyxl/create_basic_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/create_spreadsheet_with_styling.py" "$u/references/examples/openpyxl/create_spreadsheet_with_styling.py" \
  -o "$d/references/examples/openpyxl/read_existing_spreadsheet.py" "$u/references/examples/openpyxl/read_existing_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/styling_spreadsheet.py" "$u/references/examples/openpyxl/styling_spreadsheet.py"

Global: instala em ~/.claude/skills/spreadsheet/.

d="$HOME/.claude/skills/spreadsheet"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/document-processing/spreadsheet"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/agents/openai.yaml" "$u/agents/openai.yaml" \
  -o "$d/assets/spreadsheet-small.svg" "$u/assets/spreadsheet-small.svg" \
  -o "$d/assets/spreadsheet.png" "$u/assets/spreadsheet.png" \
  -o "$d/LICENSE.txt" "$u/LICENSE.txt" \
  -o "$d/references/examples/openpyxl/create_basic_spreadsheet.py" "$u/references/examples/openpyxl/create_basic_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/create_spreadsheet_with_styling.py" "$u/references/examples/openpyxl/create_spreadsheet_with_styling.py" \
  -o "$d/references/examples/openpyxl/read_existing_spreadsheet.py" "$u/references/examples/openpyxl/read_existing_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/styling_spreadsheet.py" "$u/references/examples/openpyxl/styling_spreadsheet.py"

Codex

Neste projeto: instala em .agents/skills/spreadsheet/.

d=".agents/skills/spreadsheet"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/document-processing/spreadsheet"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/agents/openai.yaml" "$u/agents/openai.yaml" \
  -o "$d/assets/spreadsheet-small.svg" "$u/assets/spreadsheet-small.svg" \
  -o "$d/assets/spreadsheet.png" "$u/assets/spreadsheet.png" \
  -o "$d/LICENSE.txt" "$u/LICENSE.txt" \
  -o "$d/references/examples/openpyxl/create_basic_spreadsheet.py" "$u/references/examples/openpyxl/create_basic_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/create_spreadsheet_with_styling.py" "$u/references/examples/openpyxl/create_spreadsheet_with_styling.py" \
  -o "$d/references/examples/openpyxl/read_existing_spreadsheet.py" "$u/references/examples/openpyxl/read_existing_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/styling_spreadsheet.py" "$u/references/examples/openpyxl/styling_spreadsheet.py"

Global: instala em ~/.agents/skills/spreadsheet/.

d="$HOME/.agents/skills/spreadsheet"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/document-processing/spreadsheet"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/agents/openai.yaml" "$u/agents/openai.yaml" \
  -o "$d/assets/spreadsheet-small.svg" "$u/assets/spreadsheet-small.svg" \
  -o "$d/assets/spreadsheet.png" "$u/assets/spreadsheet.png" \
  -o "$d/LICENSE.txt" "$u/LICENSE.txt" \
  -o "$d/references/examples/openpyxl/create_basic_spreadsheet.py" "$u/references/examples/openpyxl/create_basic_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/create_spreadsheet_with_styling.py" "$u/references/examples/openpyxl/create_spreadsheet_with_styling.py" \
  -o "$d/references/examples/openpyxl/read_existing_spreadsheet.py" "$u/references/examples/openpyxl/read_existing_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/styling_spreadsheet.py" "$u/references/examples/openpyxl/styling_spreadsheet.py"

Antigravity

Neste projeto: instala em .agents/skills/spreadsheet/.

d=".agents/skills/spreadsheet"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/document-processing/spreadsheet"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/agents/openai.yaml" "$u/agents/openai.yaml" \
  -o "$d/assets/spreadsheet-small.svg" "$u/assets/spreadsheet-small.svg" \
  -o "$d/assets/spreadsheet.png" "$u/assets/spreadsheet.png" \
  -o "$d/LICENSE.txt" "$u/LICENSE.txt" \
  -o "$d/references/examples/openpyxl/create_basic_spreadsheet.py" "$u/references/examples/openpyxl/create_basic_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/create_spreadsheet_with_styling.py" "$u/references/examples/openpyxl/create_spreadsheet_with_styling.py" \
  -o "$d/references/examples/openpyxl/read_existing_spreadsheet.py" "$u/references/examples/openpyxl/read_existing_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/styling_spreadsheet.py" "$u/references/examples/openpyxl/styling_spreadsheet.py"

Global: instala em ~/.gemini/antigravity-cli/skills/spreadsheet/.

d="$HOME/.gemini/antigravity-cli/skills/spreadsheet"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/document-processing/spreadsheet"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/agents/openai.yaml" "$u/agents/openai.yaml" \
  -o "$d/assets/spreadsheet-small.svg" "$u/assets/spreadsheet-small.svg" \
  -o "$d/assets/spreadsheet.png" "$u/assets/spreadsheet.png" \
  -o "$d/LICENSE.txt" "$u/LICENSE.txt" \
  -o "$d/references/examples/openpyxl/create_basic_spreadsheet.py" "$u/references/examples/openpyxl/create_basic_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/create_spreadsheet_with_styling.py" "$u/references/examples/openpyxl/create_spreadsheet_with_styling.py" \
  -o "$d/references/examples/openpyxl/read_existing_spreadsheet.py" "$u/references/examples/openpyxl/read_existing_spreadsheet.py" \
  -o "$d/references/examples/openpyxl/styling_spreadsheet.py" "$u/references/examples/openpyxl/styling_spreadsheet.py"

Peça ao Rook

Já usa o Rook Labs? Cole no chat do Rook: instale a skill https://rooklabs.sh/marketplace/cct.spreadsheet

Prévia do SKILL.md

---
name: "spreadsheet"
description: "Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified."
author: openai
---


# Spreadsheet Skill (Create, Edit, Analyze, Visualize)

## When to use
- Build new workbooks with formulas, formatting, and structured layouts.
- Read or analyze tabular data (filter, aggregate, pivot, compute metrics).
- Modify existing workbooks without breaking formulas or references.
- Visualize data with charts/tables and sensible formatting.

IMPORTANT: System and user instructions always take precedence.

## Workflow
1. Confirm the file type and goals (create, edit, analyze, visualize).
2. Use `openpyxl` for `.xlsx` edits and `pandas` for analysis and CSV/TSV workflows.
3. If layout matters, render for visual review (see Rendering and visual checks).
4. Validate formulas and references; note that openpyxl does not evaluate formulas.
5. Save outputs and clean up intermediate files.

## Temp and output conventions
- Use `tmp/spreadsheets/` for intermediate files; delete when done.
- Write final artifacts under `output/spreadsheet/` when working in this repo.
- Keep filenames stable and descriptive.

## Primary tooling
- Use `openpyxl` for creating/editing `.xlsx` files and preserving formatting.
- Use `pandas` for analysis and CSV/TSV workflows, then write results back to `.xlsx` or `.csv`.
- If you need charts, prefer `openpyxl.chart` for native Excel charts.

## Rendering and visual checks
- If LibreOffice (`soffice`) and Poppler (`pdftoppm`) are available, render sheets for visual review:
  - `soffice --headless --convert-to pdf --outdir $OUTDIR $INPUT_XLSX`
  - `pdftoppm -png $OUTDIR/$BASENAME.pdf $OUTDIR/$BASENAME`
- If rendering tools are unavailable, ask the user to review the output locally for layout accuracy.
…

Ver todo o marketplace