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
========
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
2 maintainers
Metadata
2 maintainers
Release files for openpyxl 1.8.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| openpyxl-1.8.5.tar.gz | 77.2 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| openpyxl-1.8.5-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 267.5 kB
Release files / openpyxl-1.8.5.tar.gz
| Download URL | openpyxl-1.8.5.tar.gz |
|---|---|
| Size | 77.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
1bf67e24453cf88c6f8675560779b75621425846951c24ed842bb7bf8cb2c9de
|
|
BLAKE2b-256 checksum How to use checksums |
be20f6f8e04f8bdf540a912a8e8096f64212848e263e3801a3397b568b08829a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / openpyxl-1.8.5-py2.py3-none-any.whl
| Download URL | openpyxl-1.8.5-py2.py3-none-any.whl |
|---|---|
| Size | 190.4 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
d32bcc633a6ddc6e0fb64eb4bbc0c0b8accb54d485ec8cbbb289218cc5429de0
|
|
BLAKE2b-256 checksum How to use checksums |
0c006d3c30426e0fbd0c0774a515fc959a278fe0d15561359b1d2ccf745ae8d5
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Security for openpyxl 1.8.5
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
