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 http://www.phpexcel.net/

== Mailing List ==

Official user list can be found on http://groups.google.com/group/openpyxl-users

== Official documentation ==

The homepage is http://openpyxl.readthedocs.org
You will find:

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


1.8.2 (2014-01-17)
==================

Bugfix #247 - iterable worksheets open too many files
Bugfix #252 - improved handling of lxml
Bugfix #253 - better handling of unique sheetnames


1.8.1 (2014-01-14)
==================

Bugfix #246


1.8.0 (2014-01-08)
==================

Compatibility
-------------

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


Compatibility
-------------

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
--------------

#109
#165
#179
#209
#112
#166
#109
#223
#124
#157


Miscellaneous
-------------

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.2.tar.gz (78.9 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

openpyxl-1.8.2-py2.py3-none-any.whl (355.7 kB view details)

Uploaded Python 2Python 3

File details

Details for the file openpyxl-1.8.2.tar.gz.

File metadata

  • Download URL: openpyxl-1.8.2.tar.gz
  • Upload date:
  • Size: 78.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for openpyxl-1.8.2.tar.gz
Algorithm Hash digest
SHA256 ed311d8212fc9bff67af0452c2ac50222c79ab39730002ef5169286c59419797
MD5 06442bc4c4368f48dd5a97e2f6436591
BLAKE2b-256 b6a51c5a627ee279cb9099ada10902dea449db9a85fb366b54078c8d60fece5c

See more details on using hashes here.

File details

Details for the file openpyxl-1.8.2-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for openpyxl-1.8.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 64ec360bac2a80a6d68449728eb872d35d703fb75f82b825fac92ba7a02425dc
MD5 a81f4f0b0ba3d6ad8a7c89419e02c2d4
BLAKE2b-256 6e724d27f7634eb5f88fa778732366ef998593a9f7ca0c0485fad9b9906795c0

See more details on using hashes here.

Supported by

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