本文へ移動
cccskills
無料GitHub で公開

artifact_spreadsheet

Create, read, edit, fix, or clean spreadsheet files (.xlsx, .xlsm, .csv, .tsv). Use whenever a build task's artifact kind is spreadsheet, or the task names a spreadsheet file and wants something done to it or produced from it, including restructuring messy tabular data into a proper workbook. Covers openpyxl generation, formulas and recalculation, editing existing workbooks, and the validation gates. Not for tasks whose deliverable is a document, report, or web page that merely contains a table.

インストール方法を見る

含まれるファイル(3)

  • SKILL.md3.5 KB
  • references/formulas.md3.4 KB
  • references/visual.md3.0 KB

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

Spreadsheet artifacts

An xlsx is generated with the preinstalled openpyxl library from a generator script. Keep the generator under .src/: it is the editable source for future revisions, and the binary is always regenerated from it.

TaskPath
Create, or edit with formulas and formattingopenpyxl
Quick look at an existing sheetmuse.read (converted to markdown, paged); it carries no cell coordinates, so never plan edits from it
Read a workbook's model (formulas AND their values)two load_workbook passes; see /opt/hatch/skills/artifacts/spreadsheet/references/formulas.md
Bulk or messy tabular data in or outPython csv from the standard library; pip install --break-system-packages pandas when a task genuinely needs it
Design, structure, number formats, model conventions/opt/hatch/skills/artifacts/spreadsheet/references/visual.md
Formulas, recalculation, editing existing workbooks/opt/hatch/skills/artifacts/spreadsheet/references/formulas.md

Requirements on every delivered workbook:

  • Set a non-empty workbook.properties.title and a human-readable filename. Data enters the workbook from the build's gathered content only; a value you do not have is a blank cell or a question, never an invented number.
  • Write formulas, never precomputed results: sheet["B10"] = "=SUM(B2:B9)", not the Python-computed total. The sheet must recalculate when its inputs change.
  • Follow the user's spec literally: their exact tab names, exact column headers, and the formula they spelled out. A redesign that computes something else fails, however elegant.
  • Zero formula errors at delivery: run the recalculation gate below and fix what it names.
  • Document assumptions and hardcoded numbers where the reader will see them (a cell comment or an adjacent labeled cell), citing the real source when one exists and saying plainly when the number came from the user.
  • A workbook created for someone to fill in gets a short legend naming the cells to edit and one example row of realistic values; never add an example row to a file you were asked to edit.

Scripts

ScriptWhat it does
/opt/hatch/skills/artifacts/scripts/recalc_xlsx.pyRecalculates the workbook in place through headless LibreOffice and reports every formula-error cell as JSON; mandatory whenever the file contains formulas. errors_found exits 0: read the JSON, not the exit code
/opt/hatch/skills/artifacts/scripts/validate_xlsx.pyOpens the workbook read-back: zip integrity, sheet parts, populated-cell counts; do not deliver a link while it fails. A csv output gets no reader check

Verification

Run recalc_xlsx.py (when formulas exist), then validate_xlsx.py, then follow /opt/hatch/skills/artifacts/testing/SKILL.md. A clean recalculation proves the formulas evaluate, not that they are right: spot-check two or three formulas pull the values you expect before building out a grid.

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

The user's synced Apple Health (HealthKit) data: daily metrics (steps, distance, calories, heart rate, HRV, VO2max), sleep sessions (stages, quality, efficiency), and workouts.

日本語の概要は準備中です。原文の説明を表示しています。

obra/muse-skills182026年10月11日 更新

Create, read, edit, or manipulate Word documents (.docx) and Word templates (.dotx). Use whenever a build task's artifact kind is document with the default docx output, or the task mentions a Word doc, .docx, or .dotx, extracts or reorganizes content from one, inserts or replaces images, does find-and-replace in one, or works with tracked changes (redlines) or comments. Covers python-docx generation, raw OOXML editing of existing files, document structure and formatting, and render verification. Not for PDFs, spreadsheets, or Google Docs.

日本語の概要は準備中です。原文の説明を表示しています。

obra/muse-skills182026年10月11日 更新

Build or revise a plain markdown file (md) deliverable such as notes, a README, meeting minutes, documentation, or text the user will edit or paste elsewhere. Use whenever a build task's artifact kind is markdown. Covers markdown formatting conventions and read-back verification.

日本語の概要は準備中です。原文の説明を表示しています。

obra/muse-skills182026年10月11日 更新

Build, revise, or manipulate a fixed-layout PDF (report, guide, one-pager, printable document). Use whenever a build task's artifact kind is pdf, a document build's output format is pdf, or the task reads, merges, splits, crops, or fills an existing PDF, including fillable AcroForms. Covers authoring the print-CSS HTML source, rendering, the geometry and validation gates, existing-PDF manipulation and form filling, and delivery under workspace/your_files.

日本語の概要は準備中です。原文の説明を表示しています。

obra/muse-skills182026年10月11日 更新

Build or revise a slide deck (pptx by default; pdf or html on request). Use whenever a build task's artifact kind is presentation, or the user asks for a deck, slides, or a presentation. Covers per-slide HTML authoring, the StylePlan theme system, font embedding, deck assembly, render gates, and the PPTX export.

日本語の概要は準備中です。原文の説明を表示しています。

obra/muse-skills182026年10月11日 更新

Verify an artifact before delivering it - file deliverables (pdf, pptx, docx, xlsx, csv) and web artifacts alike. Use whenever a build is about to return a link, or a build task asks for validation, QA, or a visual check. Covers the per-kind gate scripts, render-and-look verification, and leftover-placeholder scanning.

日本語の概要は準備中です。原文の説明を表示しています。

obra/muse-skills182026年10月11日 更新

obra のスキルをすべて見る

このスキルの問題を報告する