NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI
PyPI, #5230 most downloaded on PyPI
A wrapper library to read, manipulate and write data in xls format. Itreads xlsx and xlsm format
Latest stable
0.7.1
Last release 2 years ago
no release in 18 months
Ships unpredictably
gaps range from 2 weeks to 3.4 years
Nearly every release is documented
notes for 30 of 32 stable releases
Nothing withdrawn
no release was ever pulled
12 years old
32 releases · first in 2014
Drag across the ruler to compare, or tap a release to open it.
release 0.6.0 by @chfw in https://github.com/pyexcel/pyexcel-xls/pull/38
Full Changelog: https://github.com/pyexcel/pyexcel-xls/compare/v0.7.0...v0.7.1
Removed
#52: remove xlsm support for xlrd > 2.0.0
Updated
#54: first project in pyexcel to migrate to pytest
Your coding agent can read these notes before it upgrades. Set up the MCP server →
so, with xlrd >=2, this library won't read xlsx and you will need pyexcel-xlsx. Otherwise, with xlrd <2, it still reads xlsx file.
so, with xlrd >=2, this library won't read xlsx and you will need pyexcel-xlsx. Otherwise, with xlrd <2, it still reads xlsx file.
Removed
#46: remove the hard pin on xlrd version < 2.0
Added
#47: limit support to persist datetime.timedelta. see more details in doc
Updated #. lock down xlrd version less than version 2.0, because 2.0+ does not support xlsx read
Updated
lock down xlrd version less than version 2.0, because 2.0+ does not support xlsx read
0.6.0+ supports only python 3.6+.
Updated
Restrict this library to get installed on python 3.6+, because pyexcel-io 0.6.0+ supports only python 3.6+.
Added #. #35 _, include tests
Added
#35, include tests
see change log for more details
see change log for more details
Find 0.5.7 in changelog for more details
Find 0.5.7 in changelog for more details
Added
pyexcel#54, Book.datemode attribute of that workbook should be passed always.
Find 0.5.6 in changelog for more details
Find 0.5.6 in changelog for more details
Added
pyexcel#120, xlwt cannot save a book without any sheet. So, let's raise an exception in this case in order to warn the developers.
Find 0.5.5 in changelog for more details
Find 0.5.5 in changelog for more details
Find 0.5.4 in changelog for more details
Find 0.5.4 in changelog for more details
Added
#24, xlsx format cannot use skip_hidden_row_and_column. please use pyexcel-xlsx instead.
Find 0.5.3 in changelog for more details
Find 0.5.3 in changelog for more details
Added
#21, skip hidden rows and columns under 'skip_hidden_row_and_column' flag.
Find 0.5.2 in changelog for more details
Find 0.5.2 in changelog for more details
updated
pyexcel pyexcel#105, remove gease from setup_requires, introduced by 0.5.1.
remove python2.6 test support
update its dependecy on pyexcel-io to 0.5.3
Find 0.5.1 in changelog for more details
Find 0.5.1 in changelog for more details
added
pyexcel#103, include LICENSE file in MANIFEST.in, meaning LICENSE file will appear in the released tar ball.
put dependency on pyexcel-io 0.5.0, which uses cStringIO instead of StringIO. Hence, there will be performance boost in handling files in memory.
put dependency on pyexcel-io 0.5.0, which uses cStringIO instead of StringIO. Hence, there will be performance boost in handling files in memory.
Updated
#20, is handled in pyexcel-io
put dependency on pyexcel-io 0.5.0, which uses cStringIO instead of StringIO. Hence, there will be performance boost in handling files in memory.
Updated #. #20 _, handle unseekable stream given by http response.
Updated
#20, handle unseekable stream given by http response.
Updated plugin interface to use pyexcel v0.4.0
Updated plugin interface to use pyexcel v0.4.0
and enforce that the file handle is closed.
Updated
pyexcel-xlsx#15, close file handle
pyexcel-io plugin interface now updated to use lml.
Nothing published for this version
Updated #. #16 _, allow mmap to be passed as file content
Updated
#16, allow mmap to be passed as file content
fix #14 by using xlwt instead of xlwt-future for python 3.x.
fix #14 by using xlwt instead of xlwt-future for python 3.x.
Updated
#14, Python 3.6 - cannot use LOCALE flag with a str pattern
fix its dependency on pyexcel-io 0.3.0
Updated #. #13 _, alert on empyty file content #. Support pyexcel-io v0.3.0
Updated
#13, alert on empyty file content
Support pyexcel-io v0.3.0
generator as member of the incoming two dimensional data
Updated
#10, To support generator as member of the incoming two dimensional data
more details are in change log
more details are in change log
Added
support pagination. two pairs: start_row, row_limit and start_column, column_limit help you deal with large files.
is added. By default, hidden sheets are skipped when reading all sheets. Reading sheet by name or by index are not affected.
Added
#9, skip_hidden_sheets is added. By default, hidden sheets are skipped when reading all sheets. Reading sheet by name or by index are not affected.
a flag to switch off the autoatic conversion from float to int.
Added
By default, float will be converted to int where fits. auto_detect_int, a flag to switch off the autoatic conversion from float to int.
'library=pyexcel-xls' was added so as to inform pyexcel to use it instead of other libraries, in the situation where there are more than one plugin for a file type, e.g. xlsm
Updated
support the auto-import feature of pyexcel-io 0.2.0
xlwt is now used for python 2 implementation while xlwt-future is used for python 3
This official release following v0.1.0-rc1
This official release following v0.1.0-rc1
Added
Passing "streaming=True" to get_data, you will get the two dimensional array as a generator
Passing "data=your_generator" to save_data is acceptable too.
Nothing published for this version
get_data and save_data are seen across pyexcel-\* extensions. remember them once and use them across all extensions.
get_data and save_data are seen across pyexcel-* extensions. remember them once and use them across all extensions.
Loads only one sheet from a multiple sheet book
Older versions write datetime object as date object. This version fixes this problem. When a datetime object is written, it uses "DD/MM/YY HH:MM:SS" f
Older versions write datetime object as date object. This version fixes this problem. When a datetime object is written, it uses "DD/MM/YY HH:MM:SS" format.
numeric data with some user formated style in a xls file will lost
IO interface update: pyexcel-io v0.0.2 introduced keywords
Removed xlsm, xlsx writer as xlwt does not handle it at all
One column per quarter.