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

Uploaded Source

Built Distribution

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

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for openpyxl-1.8.1.tar.gz
Algorithm Hash digest
SHA256 de3f62ea407bdb441aa6e2a5f1c0c3cfca761e71b4cf25225c0a6c73cae4f312
MD5 3adceb3202862c1ca26f28e3f6be43c4
BLAKE2b-256 ae57f7c41c7d6a315d3ca088e4bbf7ae41af7ff360360c5c29f2b146818b23ef

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for openpyxl-1.8.1-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 7c42e923e50899fc37f403ec30f5847ef8ff486cbf40e8917eb4ed71791864f2
MD5 2987d163cfacc3f1783ebe15364dbb5c
BLAKE2b-256 af300b717ddcb6224cddd44ed637353e0fe85db6e15ce016913ba06641d104d0

See more details on using hashes here.

Supported by

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