awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
·
xlwings avatar

xlwings/xlwings

0
View on GitHub↗
3,312 stars·525 forks·Python·other·10 viewswww.xlwings.org↗

Xlwings

xlwings - Make Excel fly with Python!

Features

  • Excel Automation - Controls Excel workbooks, worksheets, and ranges programmatically from Python.
  • Python-Excel Bridge Libraries - Bridges Excel and Python, enabling calling Python functions, defining custom formulas, and automating workbooks without VBA.
  • Python Macro Replacements - Runs Python scripts in place of VBA macros triggered from Excel for powerful automation.
  • Python Macro Triggers - Embeds Python calls inside VBA macros using RunPython for native macro-like execution.
  • Workbook Deployment Preparation - Prepares Excel workbooks for distribution by embedding Python code, deploy keys, and VBA modules.
  • Embedded Python Excel Add-Ins - Embeds Python scripts and dependencies into Excel workbooks for distribution without requiring local Python installation.
  • Python Data Structure Conversions - Converts Python data types like NumPy arrays and Pandas DataFrames to and from Excel ranges.
  • Python-Driven Excel Control - Controls Excel workbooks, worksheets, and ranges programmatically from Python with VBA-like syntax.
  • Python-Excel Data Exchange - Transfers data between Excel ranges and Python data structures like Pandas DataFrames and NumPy arrays.
  • Python Function Invocations - Enables calling Python functions directly from Excel cells and VBA macros.
  • Python-Powered Workbook Distribution - Packages Python code and dependencies into Excel workbooks for distribution via installers and cloud execution.
  • Excel Range Operations - Reads and writes values to and from Excel ranges including expanding ranges and complex data types.
  • Excel - Defines custom Excel worksheet functions written in Python that calculate values directly inside spreadsheet cells.
  • Spreadsheet Function Definitions - Defines custom Excel worksheet functions written in Python that calculate values in cells.
  • Version-Bound Deploy Keys - Generates version-bound license keys for distributing Python-powered Excel workbooks to end users.
  • Remote Python Execution for Excel - Runs Python code from Excel workbooks on a remote server, eliminating the need for local Python installation.
  • Spreadsheet Function Registrations - Registers Python functions as Excel user-defined functions callable from spreadsheet formulas.
  • Pandas DataFrame Exchanges - Reads and writes NumPy arrays and Pandas DataFrames directly to and from Excel ranges.
  • Document-Embedded Scripts - Stores Python code directly inside an Excel workbook for simplified deployment without external files.
  • Embedded Script Storage - Stores Python source code directly inside Excel workbook files for self-contained deployment.
  • Deployment License Generation - Generates version-bound deploy keys from activated developer keys for distributing workbooks to end users.
  • Developer License Activation - Activates developer licenses via CLI or environment variables to unlock PRO features during development.
  • Template-Based Reports - Fills pre-designed Excel templates with Python data to produce formatted reports.
  • Excel Parsers - Reads Excel files at high speed without requiring Microsoft Excel installation.
  • Python Bundled Installers - Bundles a Python interpreter and dependencies into a single executable installer for distribution.
  • Python Environment Bundlers - Packages a Python environment and dependencies into a single installer for easy workbook distribution.
  • Remote Python Execution - Runs Python code stored in workbooks on a remote server, eliminating local Python installation.
  • Matplotlib Embeddings - Adds Matplotlib plots as pictures into Excel sheets for visual data representation.
  • Data Loading Extraction - Call Python from Excel.
  • Document and File Processing - Enables bidirectional interaction between Python and Excel.
  • Documentation and Processing - Integration library for Python and Excel.
  • Spreadsheet Integration - Python integration for automating and extending Excel functionality.

Star history

Star history chart for xlwings/xlwingsStar history chart for xlwings/xlwings

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

Open-source alternatives to Xlwings

Similar open-source projects, ranked by how many features they share with Xlwings.
  • jazzband/tablibjazzband avatar

    jazzband/tablib

    4,754View on GitHub↗

    Tablib is a Python library designed for importing, exporting, and manipulating tabular datasets. It functions as a multi-format data converter and manager, allowing users to move information between different file standards. The library supports data transformation across CSV, JSON, YAML, and Excel formats. It provides a programmatic interface to manage these datasets by adding rows, filtering columns, and segregating records. The system uses a common internal representation and adapter-based mapping to normalize diverse input sources. This allows for consistent reading and writing routines

    Python
    View on GitHub↗4,754
  • jmcnamara/xlsxwriterjmcnamara avatar

    jmcnamara/XlsxWriter

    3,911View on GitHub↗

    XlsxWriter is a library for generating spreadsheets in the XLSX format, functioning as an Excel workbook writer and file generator. It provides the capability to write data, apply cell formatting, and build complex layouts across multiple worksheets. The project distinguishes itself with a memory-optimized writing mode that flushes large datasets to disk row-by-row, enabling the creation of files exceeding 4 GB while minimizing RAM consumption. It also includes a specialized mechanism for embedding binary project files and digital signatures to enable VBA macros and signed scripts within work

    Pythonchartslibxlsxwriterpandas
    View on GitHub↗3,911
  • pymupdf/pymupdfpymupdf avatar

    pymupdf/PyMuPDF

    9,086View on GitHub↗

    PyMuPDF is a comprehensive PDF manipulation library and document analysis tool. It serves as a text extraction tool, OCR engine, and image converter, providing a programmatic interface to edit, merge, split, and optimize PDF and Office documents. The project distinguishes itself through high-performance capabilities, including the use of C-bindings for low-level manipulation and parallelized page processing to accelerate workloads. It provides specialized conversion paths, such as transforming PDF content into Markdown for retrieval-augmented generation and large language model pipelines. It

    Pythondata-scienceepubextract-data
    View on GitHub↗9,086
  • camelot-dev/camelotcamelot-dev avatar

    camelot-dev/camelot

    3,764View on GitHub↗

    Camelot is a Python library and processing engine designed to extract tabular data from PDF documents. It converts unstructured tables into machine-readable formats such as CSV, JSON, and Excel. The project provides specialized toolsets for different document types, using line detection for ruled tables and whitespace analysis for borderless tables. It includes an optical character recognition system to recover structured data from image-based scanned PDFs that lack a digital text layer. The library handles complex document layouts, including encrypted files, rotated pages, and tables that s

    Python
    View on GitHub↗3,764
See all 30 alternatives to Xlwings→

Frequently asked questions

What does xlwings/xlwings do?

xlwings - Make Excel fly with Python!

What are the main features of xlwings/xlwings?

The main features of xlwings/xlwings are: Excel Automation, Python-Excel Bridge Libraries, Python Macro Replacements, Python Macro Triggers, Workbook Deployment Preparation, Embedded Python Excel Add-Ins, Python Data Structure Conversions, Python-Driven Excel Control.

What are some open-source alternatives to xlwings/xlwings?

Open-source alternatives to xlwings/xlwings include: jazzband/tablib — Tablib is a Python library designed for importing, exporting, and manipulating tabular datasets. It functions as a… jmcnamara/xlsxwriter — XlsxWriter is a library for generating spreadsheets in the XLSX format, functioning as an Excel workbook writer and… pymupdf/pymupdf — PyMuPDF is a comprehensive PDF manipulation library and document analysis tool. It serves as a text extraction tool,… kozea/weasyprint — WeasyPrint is a Python-based library and layout engine that converts HTML and CSS into printable PDF documents. It… camelot-dev/camelot — Camelot is a Python library and processing engine designed to extract tabular data from PDF documents. It converts… martinblech/xmltodict — xmltodict is a Python library that provides bidirectional serialization between XML documents and dictionaries. It…