Changes¶
1.3.0 (22 August 2017)¶
Officially support Python 3.6, drop support for 2.6.
Fix bytes/string type mismatch in
upack2rt()
on python 3.Packaging and code style tweaks.
Use generator expressions to avoid unnecessary lists in memory.
Thanks to the following for their contributions to this release:
Jon Dufresne
Bill Adams
1.2.0 (4 January 2017)¶
Remove
LOCALE
from regular expression that causedDeprecationWarning
that become an exception in Python 3.6Add
Workbook.sheet_index()
helper.Workbook.get_sheet()
now takes either a string name or an integer index.
1.1.2 (9 June 2016)¶
Fix failure in style compression under Python 3.
Officially support Python 3.5
Documentation tweaks.
1.1.1 (2 June 2016)¶
Fix release problems.
1.1.0 (2 June 2016)¶
Fix SST BIFF record in Python 3.
Fix for writing
ExternSheetRecord
in Python 3.Add the ability to insert bitmap images from buffers as well as files.
Official support for Python 3.5.
Thanks to “thektulu” and Lele Gaifax for the Python 3 fixes. Thanks to Ross Golder for the support for inserting images from buffers.
1.0.0 (15 April 2015)¶
Python 3 support.
Initial set of unit tests.
An initial set of Sphinx documentation.
Move to setuptools for packaging.
Wire up Travis, Coveralls and ReadTheDocs.
Allow longs as row indexes.
Big thanks to Thomas Kluyver for his work on Python 3 support, Manfred Moitzi for donating his unit tests.
Belated thanks to Landon Jurgens for his help on converting the documentation to Sphinx.
0.7.5 (5 April 2013)¶
Fixes a bug that could cause a corrupt SST in .xls files written by a wide-unicode Python build.
A
ValueError
is now raised immediately if an attempt is made to set column width to other than an int inrange(65536)
Added the ability to set a custom RGB colour in the palette to use for colours. Thanks to Alan Rotman for the work, although this could really use an example in the examples folder…
Fixed an issue trying to set a diagonal border using easyxf. Thanks to Neil Etheridge for the fix.
Fixed a regression from 0.7.2 when writing sheets with frozen panes.
0.7.4 (13 April 2012)¶
Python 2.3 to 2.7 are now the officially supported versions, no Python 3 yet, sorry.
The
datemode
in an xlwtWorkbook
can be set to 1904 by doingworkbook.dates_1904 = 1
and is written to the output file. However the datemode was not being reflected in conversions fromdatetime.datetime
anddatetime.date
objects to floats for output, resulting in dates that were 4 years too high when seen in Excel.
0.7.3 (21 February 2012)¶
Added user_set and best_fit attributes to Column class.
Fixed an
[Errno 0] Error
raised whenWorksheet.flush_row_data()
was called afterWorkbook.save()
Fixed an error on Windows that occurred when writing large blocks to files.
Added the ability to write rich text cells
Fixed a bug when writing
MULBLANK
records on big-endian platforms.allow the
active_pane
on worksheets to be specifiedadded support for zoom (magn) factors and improved possibilities when generating split panes
0.7.2 (1 June 2009)¶
Added function Utils.rowcol_pair_to_cellrange.
(0, 0, 65535, 255) -> "A1:IV65536"
Removed
Worksheet
propertyshow_empty_as_zero
, and added attributeshow_zero_values
(default:1 == True
).Fixed formula code generation problem with formulas including MAX/SUM/etc functions with arguments like A1+123.
Added .pattern_examples.xls and put a pointer to it in the easyxf part of Style.py.
Fixed Row.set_cell_formula() bug introduced in 0.7.1.
Fixed bug(?) with SCL/magnification handling causing(?) Excel to raise a dialogue box if sheet is set to open in page preview mode and user then switches to normal view.
Added color and colour as synonyms for font.colour_index in easyxf.
Removed unused attribute Row.__has_default_format.
0.7.1 (4 March 2009)¶
See source control for changes made.
0.7.0 (19 September 2008)¶
Fixed more bugs and added more various new bits of functionality
0.7.0a4 (8 October 2007)¶
fork of pyExcelerator, released to python-excel.
Fixed various bugs in pyExcelerator and added various new bits of functionality