1Passwordに保存したパスワードやAPIキーを、コマンド実行や設定テンプレートで使うためのスキル。CLIの導入、認証、秘密情報の取得・受け渡しを案内します。
- 1Password CLIの導入と設定
- 保存済みAPIキーでコマンド実行
- 設定テンプレートへの秘密情報の埋め込み
PowerPoint資料の作成・内容抽出・編集を支援するスキル。文章やグラフ、画像、発表者ノートを扱い、会社のテンプレートに沿った資料作成にも対応します。
Create, read, edit .pptx decks with python-pptx.
PowerPointの.pptx資料を作成し、内容の読み取りや編集を行います。python-pptxと付属スクリプトを使い、文章、画像、表、グラフ、図形、発表者ノートを扱います。既存資料の文言・ロゴ・グラフ値の更新や、スライドの削除・並べ替えにも対応します。会社のテンプレートに値を差し込み、そのレイアウトを使ってスライドを追加する手順もあります。
報告資料や提案資料を作りたいとき、共有された資料から内容を取り出したいときに向いています。同じ体裁の資料を繰り返し作る作業や、既存資料の数値更新にも役立ちます。
Python 3.10以上とpython-pptxが必要です。作成・読み取り・編集はオフラインで動作し、PowerPointのインストールは不要です。スライド画像の生成にはLibreOfficeとpoppler、PDF出力にはLibreOfficeが必要です。旧形式の.pptは事前変換が必要で、グラフを含むスライドの複製や資料間のスライドコピーには対応しません。
この紹介文は、公開されている SKILL.md をもとに AI(Claude Haiku)が作成しました。正確な仕様は下の原文を確認してください。
インストールする前に、エージェントに与えられる指示の中身を確認できます。
Create, inspect, and edit PowerPoint (.pptx) presentations using the python-pptx library. Five helper scripts cover deck creation from a JSON spec, structured read-back, in-place edits, template-driven brand decks, and slide rendering — all offline, no PowerPoint installation required.
soffice --convert-to pptx old.ppt if LibreOffice is available.python-pptx installed
(pip install python-pptx).soffice) plus poppler (pdftoppm or
pdftocairo) for rendering slides to PNGs and for PDF export.
pptx_render.py detects both with shutil.which and degrades
gracefully (reports {"rendered": false, "missing": [...]}, exit 0)
when absent — all create/read/edit operations work without them.terminal:
python -c "import pptx; print(pptx.__version__)" and which soffice pdftoppm.All scripts live in scripts/, take --help, print JSON to stdout, and
exit non-zero on failure. Run them with terminal:
python scripts/pptx_create.py deck.json out.pptx
python scripts/pptx_read.py deck.pptx --outline # full JSON outline
python scripts/pptx_read.py deck.pptx --notes # speaker notes
python scripts/pptx_read.py deck.pptx --images ./img # export pictures
python scripts/pptx_edit.py deck.pptx --replace-text "Old Corp" "New Corp"
python scripts/pptx_edit.py deck.pptx --chart-data update.json
python scripts/pptx_edit.py deck.pptx --duplicate-slide 2
python scripts/pptx_edit.py deck.pptx --remove-slide 3 --move-slide 2 0
python scripts/pptx_from_template.py brand.pptx out.pptx --values vals.json
python scripts/pptx_render.py deck.pptx --outdir ./render # slide PNGs
Author JSON specs with write_file; inspect script output and generated
JSON with read_file.
| Task | Command |
|---|---|
| New deck from spec | pptx_create.py spec.json out.pptx |
| 16:9 vs 4:3 | "slide_size": "16:9" or "4:3" in the spec |
| Outline as JSON | pptx_read.py deck.pptx --outline |
| Export images | pptx_read.py deck.pptx --images DIR |
| Replace text | pptx_edit.py deck.pptx --replace-text OLD NEW |
| Replace chart data | pptx_edit.py deck.pptx --chart-data spec.json |
| Patch one series | same flag, spec with "ops" (see below) |
| Swap picture | pptx_edit.py deck.pptx --swap-image N NAME new.png |
| Duplicate slide | pptx_edit.py deck.pptx --duplicate-slide N |
| Remove slide | pptx_edit.py deck.pptx --remove-slide N |
| Reorder slide | pptx_edit.py deck.pptx --move-slide FROM TO |
| Slide background | pptx_edit.py deck.pptx --set-background N RRGGBB |
| Hyperlink runs | pptx_edit.py deck.pptx --hyperlink N TEXT URL |
| Slide number on | pptx_edit.py deck.pptx --enable-slide-number N |
| Footer text | pptx_edit.py deck.pptx --set-footer N TEXT |
| Set notes | pptx_edit.py deck.pptx --set-notes N TEXT |
| Append notes | pptx_edit.py deck.pptx --append-notes N TEXT |
| Fill template | pptx_from_template.py tpl.pptx out.pptx --values v.json |
| Render slide PNGs | pptx_render.py deck.pptx --outdir DIR |
Write a JSON spec (see pptx_create.py --help for the full format), then
run pptx_create.py. Per slide you can set: layout (title,
title_content, section, two_content, title_only, blank), title,
subtitle, bullets (strings, or dicts with level 0-4, size pt,
bold, italic, font, color hex, link URL for a hyperlink),
background (solid hex), footer (text; enables the layout's footer
placeholder), slide_number (true; enables the layout's slide-number
placeholder), images (path + left/top/width/height in inches), tables
(rows as list-of-lists), shapes (rectangle, rounded_rectangle, oval,
diamond, right_arrow, chevron, with fill hex + optional text),
charts (bar, bar_h, line, pie with categories + series), and
notes (speaker notes).
pptx_read.py deck.pptx --outline returns slide size, layout inventory,
and per slide: layout name, all shape texts, table cells, image inventory
(filename/ext/bytes), chart categories/series/values, and speaker notes.
Use --images DIR to dump embedded pictures to files, then
vision_analyze on any exported image if you need to see its content.
pptx_edit.py combines operations in one pass; use --output to keep the
original. Text replacement scans slide shapes, table cells, and notes.
Image swap retargets the picture's relationship id so position and size
are preserved. Slide removal drops the relationship and the <p:sldId>
entry; reorder moves the <p:sldId> element within <p:sldIdLst>
(python-pptx has no public API for either — the script does the XML-level
work). --duplicate-slide N appends an independent deep copy of slide N:
shape XML plus image/media/hyperlink relationships are cloned and rIds
remapped, so editing the copy never touches the original. Chart slides
are refused (see Pitfalls). --set-notes/--append-notes edit speaker
notes; --set-background, --hyperlink, --enable-slide-number, and
--set-footer handle deck polish.
Chart updates take a JSON spec via --chart-data. Full replace:
{"slide": 0, "chart": 0, "categories": [...], "series": {...}}. For
surgical edits, pass "ops" instead — a list of
{"op": "update_series", "name": ..., "values": [...]},
add_series, remove_series, rename_category (from/to or
index), and set_title. python-pptx can only swap a chart's entire
dataset (replace_data), so ops are implemented as read-existing →
modify → replace; the per-part UX is a wrapper, and any chart data not
expressible as categories + numeric series will be normalized by the
round-trip.
pptx_from_template.py opens a brand .pptx, replaces every
{{token}} from a values JSON across slides/tables/notes, and can append
new slides that use the template's own layouts (by layout name or index)
so they inherit the master's fonts and colors. Tip: to start from a
template with zero slides, delete existing ones afterward with
pptx_edit.py --remove-slide.
pptx_render.py deck.pptx --outdir ./render converts the deck to PDF
with soffice --headless and splits it into one PNG per slide with
pdftoppm (or pdftocairo). Output JSON lists the PNG paths — review
each with vision_analyze. When either tool is missing the script exits
0 with {"rendered": false, "missing": [...]} and guidance; fall back to
the JSON outline from pptx_read.py, which verifies content and
structure, just not visuals.
If LibreOffice is installed, export the finished deck to PDF directly:
soffice --headless --convert-to pdf --outdir ./out deck.pptx
The output lands at ./out/deck.pdf. Fonts not installed on the host are
substituted, so render-verify (Procedure step 5) before shipping the PDF.
There is no offline pure-Python .pptx→PDF path; if soffice is absent,
say so rather than approximating.
--replace-text first merges adjacent
runs whose formatting is identical, so matches split across such runs
are replaced with formatting fully preserved. Only when a match spans
genuinely differently-formatted runs is the paragraph rewritten with
the first run's formatting — verify those slides after replacement.--duplicate-slide refuses chart slides cleanly instead
of corrupting the deck. Rebuild the chart on a new slide instead.
External-hyperlink and image/media rels are carried over; layout and
notes rels are recreated fresh."ops" round-trips existing plot data through replace_data, and
changing chart type is not possible.--move-slide manipulates <p:sldIdLst> directly; safe for ordinary
decks but re-read the deck afterward to confirm.--set-footer fails
with a clear message (add a textbox instead).--hyperlink links every run
containing the given text on that slide.pptx_read.py template.pptx --outline (layouts_available).slide.shapes.title is None on blank layouts — the create script
handles this, but remember it when writing ad-hoc python-pptx code.encoding="utf-8" when writing spec files; tokens like
{{city}} may be filled with non-ASCII values.pptx_read.py OUT.pptx --outline and check
slide count, texts, tables, notes, and chart values match intent.--images DIR then file-size check confirms pictures embedded.pptx_render.py deck.pptx --outdir ./render
and review each PNG with vision_analyze — this catches overlapping
shapes, truncated text, and color problems the outline cannot. If the
render tools are missing, the script says so; rely on the outline.python -m pytest tests/ -q (requires python-pptx + pytest).まだレビューはありません。使ってみた感想をお寄せください。
概要と使いどころ
1Passwordに保存したパスワードやAPIキーを、コマンド実行や設定テンプレートで使うためのスキル。CLIの導入、認証、秘密情報の取得・受け渡しを案内します。
損益計算書・貸借対照表・キャッシュフロー計算書を数式で連動させるExcelモデルを作ります。実績と予測の入力、前提を変えた比較、財務三表の整合性確認を段階的に進めます。
Run PyTorch training across GPUs with minimal changes.
日本語の概要は準備中です。原文の説明を表示しています。
Set up Actual Computer (actual.inc) inference in Hermes.
日本語の概要は準備中です。原文の説明を表示しています。
技術が苦手で不満を抱きやすい利用者になりきってアプリを試し、操作の分かりにくさや離脱の原因を発見。実際の改善課題と個人的な不満を分け、修正案をまとめます。
2つのエージェントが別々に加えた変更のGit競合を、双方の差分と意図から中立的に解決。競合箇所ごとの判断理由を記録し、ビルドやテストで統合結果を確認します。