Excel Automation Python Packages

elixcee

Run, test, and diagnose Excel VBA macros without Microsoft Excel. elixcee is a Rust-powered headless VBA runtime for Linux, macOS, and Windows, with static analysis, property-based workbook testing, and root-cause diagnostics for common Excel operation failures.

exstruct

Conversion from Excel to structured JSON (tables, shapes, charts) for LLM/RAG pipelines, and autonomous Excel reading/writing by AI agents via CLI and MCP integration.

kitchensink4xl

Read and edit Excel workbooks with your AI assistant, and know which numbers are calculated, cached or missing.

openpyxl-toolkit

openpyxl formatting without the boilerplate.

excelalchemy

Schema-driven Python library for typed Excel import/export workflows with Pydantic, locale-aware workbooks, pluggable storage, and contract-tested architecture.

pivoteer

pivoteer injects pandas DataFrames into existing Excel templates without breaking PivotTables, filters, or formatting. Built for enterprise reporting workflows where Excel templates must stay intact and pivots refresh reliably on open.

iflow-mcp-harumiweb-exstruct

Conversion from Excel to structured JSON (tables, shapes, charts) for LLM/RAG pipelines, and autonomous Excel reading/writing by AI agents via CLI and MCP integration.