Create, edit, and clean spreadsheet files, including Excel workbooks and CSV data. Build formulas and formatting with openpyxl, a Python library, then recalculate and validate workbooks to check for formula errors and file problems.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
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.
설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.
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.
| Task | Path |
|---|---|
| Create, or edit with formulas and formatting | openpyxl |
| Quick look at an existing sheet | muse.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 out | Python 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:
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.sheet["B10"] = "=SUM(B2:B9)",
not the Python-computed total. The sheet must recalculate when its
inputs change.| Script | What it does |
|---|---|
/opt/hatch/skills/artifacts/scripts/recalc_xlsx.py | Recalculates 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.py | Opens 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 |
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.
아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.
로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.
아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.
Create a 3D object with three.js, inspect it from every angle in an interactive viewer, and download it as OBJ + MTL or GLB for use in other 3D applications.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Maintain a private task list with deadlines, next steps, waiting parties, and blockers. Update progress and dependencies, merge duplicate items, and archive closed tasks so ongoing commitments stay clear and easy to follow.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Coordinate a task from a verifiable goal through completion. Handle work directly or split independent tasks across separate agent sessions, track progress, verify results, and arrange pull request merging when included in the goal.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Create animated HTML pages with smooth scene transitions and playback controls. An editable timeline lets users adjust scene lengths and speeds, with fixed landscape or portrait layouts prepared for video export.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Review synced Apple Health records, including steps, heart rate, sleep, and workouts. Retrieve daily summaries or detailed samples for a chosen period, and check sync status and missing data before interpreting the results.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Create and edit Word documents and templates, reorganize text, replace images, and work with tracked changes or comments. Apply proper headings and lists, then render every page to check its appearance before delivery.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.