NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI
PyPI
A wrapper library to read, manipulate and write data in xlsx and xlsmformat
Latest stable
0.6.1
Last release 2 years ago
no release in 18 months
Ships unpredictably
gaps range from 2 weeks to 4.4 years
Nearly every release is documented
notes for 27 of 29 stable releases
Nothing withdrawn
no release was ever pulled
12 years old
29 releases · first in 2014
Drag across the ruler to compare, or tap a release to open it.
perform tests on windows, macos using github actions by @chfw in https://github.com/pyexcel/pyexcel-xlsx/pull/47
Full Changelog: https://github.com/pyexcel/pyexcel-xlsx/compare/v0.6.0...v0.6.1
support python 3.6+ and new style plugins. align with pyexcel-io 0.6.2
support python 3.6+ and new style plugins. align with pyexcel-io 0.6.2
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Updated
New style xlsx plugins, promoted by pyexcel-io v0.6.2.
no functional changes in this package.
fix #34
no functional changes in this package.
Find 0.5.7 in changelog for more details
Find 0.5.7 in changelog for more details
Find 0.5.6 in changelog for more details
Find 0.5.6 in changelog for more details
Added
#24, remove deprecated warning from merged_cell_ranges and get_sheet_by_name
Find 0.5.5 in changelog for more details
Find 0.5.5 in changelog for more details
Added
#22, to detect merged cell in xlsx - fast tracked patreon request.
Find 0.5.4 in changelog for more details
Find 0.5.4 in changelog for more details
Updated
Align the behavior of skip_hidden_row_and_column. Default it to True.
Find 0.5.3 in changelog for more details
Find 0.5.3 in changelog for more details
Added
#20, 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.
Update 0.5.0 with pyexcel-io v0.5.0 as dependency.
Update 0.5.0 with pyexcel-io v0.5.0 as dependency.
When you deal with files in memory, you will get performance boost because it uses cStringIO instead of StringIO
When you deal with files in memory, you will get performance boost because it uses cStringIO instead of StringIO
Updated
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.
Removed
#18, is handled in pyexcel-io
Removed #. Removed useless code
Removed
Removed useless code
Updated #. #14 _, close file handle #. pyexcel-io plugin interface now updated to use lml _.
Updated #. Code refactoring with pyexcel-io v 0.3.0 #. #13 _, turn read_only flag on openpyxl.
Updated
Code refactoring with pyexcel-io v 0.3.0
#13, turn read_only flag on openpyxl.
UserWarning: Using a coordinate with ws.cell is deprecated. Use ws[coordinate]
Updated
#12, remove UserWarning: Using a coordinate with ws.cell is deprecated. Use ws[coordinate]
see change log for more details
see change log for more details
Added
support pagination. two pairs: start_row, row_limit and start_column, column_limit help you deal with large files.
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.
Added
#8, 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.
libraries, in the situation where there are more than one plugin for a file type, e.g. xlsm
Added
'library=pyexcel-xlsx' was added 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
This release is backward compatible with earlier releases. 'streaming' is an extra option given to get_data. Only when 'streaming' is explicitly set t
This release is backward compatible with earlier releases. 'streaming' is an extra option given to get_data. Only when 'streaming' is explicitly set to True, the data will be consisted of generators, hence will break your existing code.
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.
Updated
compatibility with pyexcel-io 0.1.0
due to this failed build, openpyxl was not picked up by python 3's pip : https://travis-ci.org/chfw/pyexcel/jobs/97762428
due to this failed build, openpyxl was not picked up by python 3's pip : https://travis-ci.org/chfw/pyexcel/jobs/97762428
Nothing published for this version
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
Openpyxl had a data_only option upon opening a xlsx file. By passing data_only=True, this library would be able to read values back.
Openpyxl had a data_only option upon opening a xlsx file. By passing data_only=True, this library would be able to read values back.
no sheet can have more than 26 columns in a xls file
IO interface update as pyexcel-io introduced keywords in function calls.
support reading, manipulating and writing in xlsx and xlsm.
One column per quarter.