Office Open XML Automation Helper

Use this skill when the task crosses Office file types: extract Word tables into Excel, turn Excel results into PowerPoint slides, populate Word reports from spreadsheets, batch-convert Office files, or coordinate DOCX/XLSX/PPTX templates.

Workflow

1. Define the pipeline: source files, destination files, templates, generated artifacts, batch size, and success criteria.
2. Classify each operation:
   • DOCX text, tables, styles, comments, headers, content controls.
   • XLSX worksheets, tables, formulas, named ranges, charts, pivots, macros.
   • PPTX slide masters, layouts, placeholders, charts, media, speaker notes.
3. Preserve source packages. Work on copies and keep an audit trail of inputs, outputs, and record IDs.
4. Choose the safest layer for each step:
   • python-docx for supported Word document content.
   • openpyxl for supported Excel workbook structure.
   • python-pptx for supported slide content and basic charts.
   • Direct Open XML edits for relationships, unsupported features, and preserving package parts.

     更多技能請訪問小蔥技能站7w4.net。

   • VBA or Office desktop automation only when live Office behavior is required, such as field updates, Power Query refresh, PDF export, or chart rendering fidelity.
5. Keep data transformations separate from document rendering. Normalize data first, then populate templates.
6. Validate each artifact independently, then validate the whole chain.

Design Rules

• Do not use plain string replacement inside zipped Office XML unless escaping, run boundaries, relationships, and namespaces are understood.
• Preserve relationship IDs and content types when copying media, charts, embedded workbooks, or custom XML parts.
• Avoid saving .xlsm or macro-enabled packages through a library path that strips macros.
• Prefer named ranges, content controls, placeholders, and template fields over positional guesses.
• Log generated filenames, input records, warnings, skipped records, and validation totals.

Validation

Check:

• DOCX page structure, styles, headers/footers, tables, fields, comments, and tracked changes.
• XLSX formulas, named ranges, tables, charts, macros, hidden sheets, and recalculation requirements.
• PPTX slide count, layout assignment, placeholders, charts, media, theme fonts/colors, and notes.
• Batch totals and file-open sanity for every generated output.

Output

Provide a pipeline design, implementation steps or scripts, validation checklist, and any Office desktop steps that cannot be performed locally.

Read references/requirement-plan.md only when the original discovery evidence is needed.

這個 Skill 的框架搭建得不錯，文件結構清晰，許可證開放，適合開發者參考 Office 自動化的工作思路。但作為工具類 Skill，它目前缺少可直接使用的示例程式碼或指令碼，內容偏理論性，實用性有待提升。版本號 0.1.0 也表明這是一個較新的作品，仍在完善中。