exstruct

概述

ExStruct 能读取 Excel 工作簿并将其转换为结构化数据，提供提取 API、编辑 CLI 和用于集成的 MCP 服务器。它支持多种输出模式（light、libreoffice、standard、verbose），可以提取单元格、形状、图表、SmartArt、表格、公式和超链接。该项目提供 CLI 和 Python 接口，支持基于补丁的编辑工作流，适合 LLM/RAG 管道和自动化场景。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• exstruct_extract

  Extracts data from an Excel workbook

  试试:Extract data from financial_report.xlsx试试:Read the workbook in verbose mode to include all shapes and hyperlinks试试:Extract cells and table candidates from budget.xlsx
• exstruct_capture_sheet_images

  Captures images from Excel sheets

  试试:Capture images from presentation.xlsx试试:Get all images from slide deck.xlsx试试:Export images from chart_summary.xlsx
• exstruct_make

  Creates a new Excel workbook

  试试:Create a new workbook called quarterly_report.xlsx试试:Generate an empty Excel file with template formatting试试:Make a new workbook with named sheets
• exstruct_patch

  Applies editing patches to a workbook

  试试:Apply these edits to sales_data.xlsx试试:Patch the workbook using the operations in changes.json试试:Update cells A1 to C5 with new values
• exstruct_read_json_chunk

  Reads extracted JSON chunks from a workbook

  试试:Read the JSON chunks from extracted_data试试:Get the chunk with sheet summaries from extracted试试:Read the formula chunks from the extracted data
• exstruct_read_range

  Reads cells from a specified range

  试试:Read cells from A1 to C10 in financial.xlsx试试:Get values from range B5:D20 in report.xlsx试试:Extract data from range F1:H15 in budget.xlsx
• exstruct_read_cells

  Reads data cell by cell from a workbook

  试试:Read all cells from inventory.xlsx试试:Get cell data from products.xlsx试试:Extract individual cells from dataset.xlsx
• exstruct_read_formulas

  Reads cell formulas from a workbook

  试试:Read formulas from calculations.xlsx试试:Get all formula expressions from budget.xlsx试试:Extract formula references from financial_model.xlsx
• exstruct_validate_input

  Validates input workbook data

  试试:Validate this workbook before processing试试:Check if data.xlsx is readable and valid试试:Validate the structure of input_file.xlsx

可对比工具

安装

pip install exstruct[mcp]

{
  "mcpServers": {
    "exstruct": {
      "command": "exstruct-mcp",
      "args": ["--root", "/path/to/your/data", "--on-conflict", "rename"]
    }
  }
}

uvx --from 'exstruct[mcp]' exstruct-mcp --root /path/to/your/data

FAQ

ExStruct 支持哪些平台？

ExStruct 支持 Windows 平台（通过 Excel COM）以及 Linux/macOS 平台（通过直接 OOXML 解析或使用 LibreOffice 运行时）。

如何安装带有可选依赖的 ExStruct？

使用 `pip install exstruct[yaml,toon,render]` 安装支持 YAML、TOON 格式和渲染功能的完整版本。

exstruct 对比