Skip to main content

A Python library to read/write Excel 2007 xlsx/xlsm files

Project description

OpenPyxl is a Python library to read/write Excel 2010 xlsx/xlsm files.

It was born from lack of existing library to read/write natively from Python the new Office Open XML format.

All kudos to the PHPExcel team as openpyxl is based on PHPExcel

== Mailing List ==

Official user list can be found on

== Official documentation ==

The homepage is
You will find:

* every installation methods
* the official documentation
* code examples
* instructions for contributing

1.8.1 (2014-01-14)

Bugfix #246

1.8.0 (2014-01-08)


Support for Python 2.5 dropped.

Major changes

* Support conditional formatting
* Support lxml as backend
* Support reading and writing comments
* pytest as testrunner now required
* Improvements in charts: new types, more reliable

Minor changes

* load_workbook now accepts data_only to allow extracting values only from
formulae. Default is false.
* Images can now be anchored to cells
* Docs updated
* Provisional benchmarking
* Added convenience methods for accessing worksheets and cells by key

1.7.0 (2013-10-31)

Major changes

Drops support for Python < 2.5 and last version to support Python 2.5


Tests run on Python 2.5, 2.6, 2.7, 3.2, 3.3

Merged pull requests

#27 Include more metadata
#41 Able to read files with chart sheets
#45 Configurable Worksheet classes
#3 Correct serialisation of Decimal
#36 Preserve VBA macros when reading files
#44 Handle empty oddheader and oddFooter tags
#43 Fixed issue that the reader never set the active sheet
#33 Reader set value and type explicitly and TYPE_ERROR checking
#22 added page breaks, fixed formula serialization
#39 Fix Python 2.6 compatibility
#47 Improvements in styling

Known bugfixes



Performance improvements in optimised writer

Docs updated

Project details

Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

openpyxl-1.8.1.tar.gz (78.7 kB view hashes)

Uploaded Source

Built Distribution

openpyxl-1.8.1-py2.py3-none-any.whl (354.2 kB view hashes)

Uploaded Python 2 Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page