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.6 (2014-05-05)
==================
Minor changes
-------------
Fixed typo for import Elementtree
Bugfixes
--------
#279 Incorrect path for comments files on Windows
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.6 (2014-05-05)
==================
Minor changes
-------------
Fixed typo for import Elementtree
Bugfixes
--------
#279 Incorrect path for comments files on Windows
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.6.tar.gz
(76.6 kB
view details)
Built Distribution
openpyxl-1.8.6-py2.py3-none-any.whl
(190.3 kB
view details)
File details
Details for the file openpyxl-1.8.6.tar.gz
.
File metadata
- Download URL: openpyxl-1.8.6.tar.gz
- Upload date:
- Size: 76.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | aa11a4acd2765392808bca2041f6f9ba17565c72dccc3f5d876bf78effa06126 |
|
MD5 | a610d32ca5460eb78df4eb83c896ba34 |
|
BLAKE2b-256 | c2ae4ac6659a37bac4c496cc59378b95e5fbbaf3c1d6249827bb7c7516de979a |
File details
Details for the file openpyxl-1.8.6-py2.py3-none-any.whl
.
File metadata
- Download URL: openpyxl-1.8.6-py2.py3-none-any.whl
- Upload date:
- Size: 190.3 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 87fdfe6ada6a296e696777bdd9b1eba019d38332d5e1efdbeb6ea7e1f02161ac |
|
MD5 | 52592abbc79819d1dfcd2f938c47739a |
|
BLAKE2b-256 | eb38e52d897f0529c470a335b347c6b4e7feb5992d231e3601f2ea0b33745075 |