iOfficeAI/OfficeCLI

Features

• AI Agent Interfaces - Exposes document manipulation operations as tools for AI agents via a JSON-RPC server and MCP.
• Office Document Tools - Provides a comprehensive set of tools for programmatically creating, processing, and manipulating Microsoft Office document formats.
• MCP Protocol Integrations - Exposes document manipulation operations as standardized tools for AI agents using the Model Context Protocol.
• XML Structure Customization - Enables advanced customization of office files through direct raw XML manipulation using XPath.
• Automated Report Generators - Generates structured business reports by merging JSON data into predefined document templates.
• Dynamic Document Formatting - Applies complex styles and structural changes to Word documents programmatically.
• Excel Spreadsheet Management - Implements full lifecycle management of Excel files, including programmatic editing of worksheets, formulas, and charts.
• Headless Office Suites - Functions as a standalone binary for managing spreadsheets, presentations, and documents without requiring local office software.
• Office Automation Tools - Provides a command line tool designed to automate the reading, editing, and generation of Microsoft Office files.
• Office Document Generation - Generates new blank or predefined Word, Excel, and PowerPoint files from scratch.
• Paragraph Management - Provides tools for creating, inserting, and removing block-level paragraph containers in documents.
• Spreadsheet Cell Manipulators - Provides utilities for programmatically reading, adding, and modifying cell values, formulas, and formatting.
• Table Management - Offers full programmatic control over the creation, deletion, and formatting of document tables.
• Worksheet Organization - Supports the programmatic creation, renaming, and deletion of individual worksheets within a spreadsheet file.
• Document Templating Systems - Ships a templating engine that merges JSON data into predefined document templates for automated report generation.
• Existing Document Modification - Edits text, fonts, colors, layout, formulas, charts, and images within existing office files.
• OOXML Schema Manipulations - Allows direct programmatic modification of the underlying XML structure of Office Open XML documents.
• Content Extraction - Extracts text, structure, styles, and formulas from office files into plain text or structured JSON.
• Document Structure Export - Dumps document subtrees into replayable JSON batches to enable imitation and automated variation generation.
• Raw XML Editors - Provides the ability to read and update the underlying XML structure of document parts for advanced customization.
• Single-Binary Distributions - Bundles all necessary dependencies into a standalone executable to operate without local office software installations.
• XPath-Based XML Document Manipulation - Directly reads and modifies the underlying XML structure of document parts using XPath for advanced customization.
• JSON-RPC Implementations - Implements a JSON-RPC server to expose document operations as tools for integration with external AI agents.
• Spreadsheet Formula Engines - Provides a calculation engine that evaluates built-in spreadsheet functions and dynamic arrays without external software.
• Style Management - Provides a system for defining and applying consistent named styles to paragraphs, characters, and tables.
• Replayable JSON Batches - Dumps document subtrees into replayable JSON batches to enable imitation and automated variation generation.
• Character-Level Styling - Changes the content and character-level styling of text segments to update fonts, sizes, or weights.
• Chart Embeddings - Creates, modifies, and removes embedded charts while configuring types, data series, and styling.
• Chart Insertions - Provides the capability to build and embed various chart types into spreadsheets.
• Document Content Controls - Adds, modifies, and queries structured content controls to automate text replacement and metadata tagging.
• Document Element Reorganization - Allows adding, removing, moving, or copying elements within a single document or across different office files.
• Floating Textbox Management - Allows creating, reading, modifying, and deleting floating textboxes with precise control over geometry, fills, and rotation.
• Paragraph Querying - Provides the ability to filter paragraphs based on styles, alignment, list levels, and text content.
• Spreadsheet Element Deletion - Removes cells, rows, or columns and identifies potential formula reference errors.
• Spreadsheet Charting - Generates standard data visualizations like bar, line, and pie charts directly within spreadsheet files.
• Bookmark Managers - Provides tools for creating, renaming, and removing named anchors to mark specific document locations.
• Document Generation Templates - Populates standardized document templates with JSON data to produce consistent, formatted reports.
• Document Watermarking - Allows placing text overlays behind page content to create watermarks for branding or security.
• Header and Footer Management - Provides comprehensive control over the creation, modification, and removal of document header and footer sections.
• Element Insertion - Enables the insertion of formatted paragraphs and images into document header and footer sections.
• Row and Column Manipulations - Allows structural restructuring of spreadsheets by manipulating rows and columns through a synthesized axis.
• Coordinate Axis Synthesis - Uses a synthesized coordinate axis to manipulate spreadsheet columns and rows independently of implicit document structures.
• Template-Based Reports - Generates consistent reports by replacing predefined placeholders in document templates with structured JSON data.
• Content Change Tracking - Tracks document changes, including insertions and deletions, with author and date attribution.
• Worksheet Data Extraction - Isolates and extracts content and attributes from specific spreadsheet worksheets.
• Structured Spreadsheet Tables - Enables the programmatic creation, modification, and removal of formal structured tables and their styling within spreadsheets.
• Pivot Table Aggregators - Generates native pivot tables from source ranges with multi-field aggregations and custom layouts.
• Table Data Retrieval - Allows retrieving specific rows or ranges by filtering for column headers, values, and logical conditions.
• Tabular Data Sorting - Implements operations for ordering rows in a worksheet based on specific column values and directions.
• Data Querying - Allows searching for spreadsheet cells using value matches, data types, formulas, and text-based selectors.
• Revision Finalization - Provides mechanisms to commit or discard tracked changes across the entire file or specific targets.
• Document Object Embedding - Enables embedding and extracting binary objects, charts, and diagrams within document layouts.
• Image Insertion Utilities - Provides utilities for inserting inline or floating images with configurable dimensions and text-wrapping.
• AI Agent Tool Interfaces - Exposes document manipulation operations as tools for AI agents via a JSON-RPC server.
• Fillable Form Fields - Adds text inputs, checkboxes, and dropdown menus to create fillable office documents.
• Right-To-Left Support - Configures right-to-left and left-to-right reading directions for sections, tables, and paragraphs.
• Conditional Formatting - Provides capabilities to change the visual appearance of spreadsheet cells based on their values or specific thresholds.
• HTML-to-Image Converters - Converts document files into high-fidelity HTML or PNG screenshots for visual inspection of layouts.
• HTML Document Renderers - Converts complex office document layouts into high-fidelity HTML or PNG formats for visual inspection.
• Spreadsheet Row Sorting - Reorders rows based on specified columns and directions while optionally preserving a header row.
• General Productivity Tools - Command line interface for manipulating office documents.

Star history