xlwt 1.3.0

API 参考

安装指导

开发

变化

• 1.3.0 (22 August 2017)
• 1.2.0 (4 January 2017)
• 1.1.2 (9 June 2016)
• 1.1.1 (2 June 2016)
• 1.1.0 (2 June 2016)
• 1.0.0 (15 April 2015)
• 0.7.5 (5 April 2013)
• 0.7.4 (13 April 2012)
• 0.7.3 (21 February 2012)
• 0.7.2 (1 June 2009)
• 0.7.1 (4 March 2009)
• 0.7.0 (19 September 2008)
• 0.7.0a4 (8 October 2007)

许可

1. 首页
2. xlwt 1.3.0 文档编制
3. 变化

变化 ¶

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) ¶

• 移除 LOCALE from regular expression that caused DeprecationWarning that become an exception in Python 3.6
• Add 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 in range(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 xlwt Workbook can be set to 1904 by doing workbook.dates_1904 = 1 and is written to the output file. However the datemode was not being reflected in conversions from datetime.datetime and datetime.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 when Worksheet.flush_row_data() was called after Workbook.save()
• Fixed an error on Windows that occurred when writing large blocks to 文件。
• 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 specified
• added 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"
• 移除 Worksheet property show_empty_as_zero , and added attribute show_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