Skip to main content

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

Project description

openpyxl
========

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.5 (2014-03-25)
==================

Minor changes
-------------
The '=' string is no longer interpreted as a formula
When a client writes empty xml tags for cells (e.g. <c r='A1'></c>), reader will not crash


1.8.4 (2014-02-25)
==================

Bugfixes
--------
#260 better handling of undimensioned worksheets
#268 non-ascii in formualae
#282 correct implementation of register_namepsace for Python 2.6


1.8.3 (2014-02-09)
==================

Major changes
-------------
Always parse using cElementTree

Minor changes
-------------
Slight improvements in memory use when parsing

Bugfix #256 - error when trying to read comments with optimised reader
Bugfix #260 - unsized worksheets
Bugfix #264 - only numeric cells can be dates


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

Uploaded Source

Built Distribution

openpyxl-1.8.5-py2.py3-none-any.whl (190.4 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for openpyxl-1.8.5.tar.gz
Algorithm Hash digest
SHA256 1bf67e24453cf88c6f8675560779b75621425846951c24ed842bb7bf8cb2c9de
MD5 6f2eca608c3129dbfd77982713565709
BLAKE2b-256 be20f6f8e04f8bdf540a912a8e8096f64212848e263e3801a3397b568b08829a

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for openpyxl-1.8.5-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 d32bcc633a6ddc6e0fb64eb4bbc0c0b8accb54d485ec8cbbb289218cc5429de0
MD5 aa262fe8b562b00ff53bb624b9712c24
BLAKE2b-256 0c006d3c30426e0fbd0c0774a515fc959a278fe0d15561359b1d2ccf745ae8d5

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