Repolode
Submit
xuri

xuri/excelize-py

Python library for reading and writing Excel spreadsheet files (XLSX, XLSM, XLTX, XLTM, XLAM), ported from the Go Excelize library.

Open-source alternative to:Microsoft Excel

View on GitHubWebsite
Stars
51
Forks
31
Open issues
4
Last commit
16 hours ago

What is it?

excelize-py is a Python port of the Go Excelize library. It lets Python code create, read, and modify spreadsheet files in the XLAM, XLSM, XLSX, XLTM, and XLTX formats generated by Microsoft Excel 2007 and later.

The library covers common spreadsheet work: setting and reading cell values, managing sheets, inserting pictures with scaling and offset options, and building charts from worksheet data. It also provides a streaming API for writing or reading large worksheets without loading everything into memory.

Prebuilt binaries are provided for Windows (amd64, arm64, i686), macOS (amd64, arm64), and Linux (amd64, arm64, i686). It requires Python 3.9 or later and is installed with pip install excelize.

Key features

  • 01Reads and writes XLSX, XLSM, XLTX, XLTM, and XLAM files.
  • 02Sets and retrieves cell values and rows by sheet name and cell reference.
  • 03Creates charts from worksheet data, including 3D clustered column charts.
  • 04Inserts pictures with scaling, offset, and print options.
  • 05Provides a streaming API for large worksheets.

Use cases

  • Generating Excel reports from Python data pipelines.
  • Reading spreadsheet data uploaded by users into a Python application.
  • Adding charts or images to existing workbooks automatically.

Quick start

  1. 1

    Install the library from PyPI

    pip install excelize
  2. 2

    Create a spreadsheet with the minimal example from the README

Things to know

  • Requires Python 3.9 or later.
  • Supported platforms are limited to Windows, Darwin (macOS) and Linux on amd64, arm64 or i686.

In collections

Data science courses & tools

Topics

#excel#spreadsheet#xlsx#python-library#office-documents#data-export#calculation#chart#data-analysis#data-science

FAQ

What is excelize-py?
Python library for reading and writing Excel spreadsheet files (XLSX, XLSM, XLTX, XLTM, XLAM), ported from the Go Excelize library. excelize-py is a Python port of the Go Excelize library. It lets Python code create, read, and modify spreadsheet files in the XLAM, XLSM, XLSX, XLTM, and XLTX formats generated by Microsoft Excel 2007 and later.
Is excelize-py free to use? What license does it have?
excelize-py is open source under the BSD-3-Clause license. Check the license terms before using it in commercial products.
Is excelize-py still maintained?
Actively maintained. The last commit to excelize-py was on Oct 22, 2026.
What can I use excelize-py for?
Generating Excel reports from Python data pipelines. Reading spreadsheet data uploaded by users into a Python application. Adding charts or images to existing workbooks automatically.
How do I install excelize-py?
Install the library from PyPI: pip install excelize Create a spreadsheet with the minimal example from the README
Where can I get excelize-py?
The source code and installation instructions are on GitHub: https://github.com/xuri/excelize-py

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects