AI Office Skill

A comprehensive suite of AI agent skills designed to create, read, edit, analyze, and manipulate various office document formats. These skills empower AI agents to handle complex document workflows across popular file types while maintaining high professional standards.

Covered Document Types

This repository contains dedicated skills for the following file formats:

Word Documents (docx)

• Capabilities: Create new professional documents, read/analyze content (including tracked changes and XML), edit existing documents, generate tables of contents, and add headers/footers.
• Key Tools: docx-js (via Node.js), pandoc, LibreOffice (conversion).
• Features: Supports precise page sizing (US Letter/A4), professional typography, multi-column layouts, and direct XML tracked-change edits.

Spreadsheets (xlsx)

• Capabilities: Read, edit, analyze, and create .xlsx, .xlsm, .csv, and .tsv files.
• Key Tools: pandas (for data analysis), openpyxl (for formatting/formulas), LibreOffice (for formula recalculation).
• Features: Strict adherence to financial modeling standards, color coding, dynamic formula generation (zero hardcoded calculations), and built-in scripts to verify zero formula errors (#REF!, #DIV/0!, etc.).

PDF Documents (pdf)

• Capabilities: Read text/tables, merge/split PDFs, rotate pages, add watermarks, extract images, perform OCR on scanned PDFs, and create new PDFs.
• Key Tools: pypdf, pdfplumber, reportlab, qpdf, pdftoppm, pytesseract.
• Features: Robust layout preservation, table extraction, form filling, and protection/encryption.

PowerPoint Presentations (pptx)

• Capabilities: Create pitch decks/presentations from scratch, edit existing slides, extract text, and apply templates.
• Key Tools: markitdown (text extraction), pptxgenjs, thumbnail.py (visual overview).
• Features: Enforces strict visual QA (checking for overlapping elements, text overflow, low contrast) and emphasizes modern design principles (bold colors, specific typography).

Mind Maps (xmind)

• Capabilities: Generate .xmind files (XMind 8 compatible) locally from text descriptions.
• Features: Creates valid ZIP archives containing the required XML (content.xml, meta.xml, manifest.xml) to seamlessly build structural mind maps.

Prerequisites

To fully utilize all the skills in this repository, the following dependencies are typically required:

• Python 3.x
• Node.js (for docx and pptxgenjs creation)
• LibreOffice (running in headless mode for document conversion and formula recalculation)
• Poppler / poppler-utils (for PDF/PPTX to image conversion)
• Pandoc (for DOCX text extraction with tracked changes)
• Various Python packages (pandas, openpyxl, pypdf, pdfplumber, reportlab, markitdown)

Structure