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.0 (unreleased)
==================

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

This version

1.8.0

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.0.tar.gz (78.6 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.0-py2.py3-none-any.whl (353.9 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for openpyxl-1.8.0.tar.gz
Algorithm Hash digest
SHA256 98d2da2c1970c73d1eee613c85a9403aea830fa8b9a87130c4088ae1edbe3140
MD5 b3c8b5fe72e17fbf189634ca2f6d3612
BLAKE2b-256 8658da029ca7083d654f5bd4a6b29590309fc7070290c9050f82b9455ebfa301

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for openpyxl-1.8.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 442f34ec25a52433b80d320b081bf7bd3134970d0fb18660755dab12aa2b4bfd
MD5 521ce5f6ecb07e904dc2a3e6a81f99f2
BLAKE2b-256 4365bd8eed389b145f5c913a6d784a7a0c6ff90dda49058ea791aa1bcba5d56c

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