Changes in XlsxWriter

This section shows changes and bug fixes in the XlsxWriter module.

Release 0.5.5 - May 6 2014

Release 0.5.4 - May 4 2014

  • Added image positioning option to insert_image() to control how images are moved in relation to surrounding cells. Issue #117.
  • Fix for chart error_bar exceptions. Issue #115.
  • Added clearer reporting of nested exceptions in write() methods. Issue #108.
  • Added support for inside_base data label position in charts.

Release 0.5.3 - February 20 2014

  • Added checks and warnings for data validation limits. Issue #89.
  • Added option to add hyperlinks to images. Thanks to Paul Tax.
  • Added Python 3 Http server example. Thanks to Krystian Rosinski.
  • Added set_calc_mode() method to control automatic calculation of formulas when worksheet is opened. Thanks to Chris Tompkinson.
  • Added use_zip64() method to allow ZIP64 extensions when writing very large files.
  • Fix to handle ‘0’ and other number like strings as number formats. Issue #103.
  • Fix for missing images in in_memory mode. Issue #102.

Release 0.5.2 - December 31 2013

  • Added date axis handling to charts. See Example: Date Axis Chart. Issue #73.
  • Added support for non-contiguous chart ranges. Issue #44.
  • Fix for low byte and control characters in strings. Issue #86.
  • Fix for chart titles with exclamation mark. Issue #83.
  • Fix to remove duplicate set_column() entries. Issue #82.

Release 0.5.1 - December 2 2013

  • Added interval unit option for category axes. Issue #69.
  • Fix for axis name font rotation.
  • Fix for several minor issues with Pie chart legends.

Release 0.5.0 - November 17 2013

Release 0.4.9 - November 17 2013

Release 0.4.8 - November 13 2013

  • Added in_memory Workbook() constructor option to allow XlsxWriter to work on Google App Engine. Issue #28.

Release 0.4.7 - November 9 2013

Release 0.4.6 - October 23 2013

  • Added font formatting to chart legends.

Release 0.4.5 - October 21 2013

  • Added position_axis chart axis option.
  • Added optional list handling for chart names.

Release 0.4.4 - October 16 2013

  • Documented use of cell utility functions.
  • Fix for tables added in non-sequential order. Closes #51 reported by calfzhou.

Release 0.4.3 - September 12 2013

  • Fix for comments overlying columns with non-default width. Issue #45.

Release 0.4.2 - August 30 2013

  • Added a default blue underline hyperlink format for write_url().
  • Added Workbook() constructor options strings_to_formulas and strings_to_urls to override default conversion of strings in write().

Release 0.4.1 - August 28 2013

  • Fix for charts and images that cross rows and columns that are hidden or formatted but which don’t have size changes. Issue #42 reported by Kristian Stobbe.

Release 0.4.0 - August 26 2013

  • Added more generic support for JPEG files. Issue #40 reported by Simon Breuss.
  • Fix for harmless Python 3 installation warning. Issue #41 reported by James Reeves.

Release 0.3.9 - August 24 2013

  • Added fix for minor issue with insert_image() for images that extend over several cells.
  • Added fix to ensure formula calculation on load regardless of Excel version.

Release 0.3.8 - August 23 2013

  • Added handling for Decimal(), Fraction() and other float types to the write() function.
  • Added Python 2.5 and Jython support. Thanks to Jonas Diemer for the patch.

Release 0.3.7 - August 16 2013

  • Added write_boolean() function to write Excel boolean values. Issue #37. Also added explicit handling of Python bool values to the write() function.
  • Changed Workbook() constructor option strings_to_numbers default option to False so that there is no implicit conversion of numbers in strings to numbers. The previous behaviour can be obtained by setting the constructor option to True. Note This is a backward incompatibility.

Release 0.3.6 - July 26 2013

  • Simplified import based on a suggestion from John Yeung. Issue #26.
  • Fix for NAN/INF converted to invalid numbers in write(). Issue #30.
  • Added Workbook() constructor option strings_to_numbers to override default conversion of number strings to numbers in write().
  • Added Workbook() constructor option default_date_format to allow a default date format string to be set. Issue #5.

Release 0.3.5 - June 28 2013

  • Reverted back to using codecs for file encoding (versions <= 0.3.1) to avoid numerous UTF-8 issues in Python2/3.

Release 0.3.4 - June 27 2013

  • Added Chart line smoothing option. Thanks to Dieter Vandenbussche.
  • Added Http Server example (Example: Simple HTTP Server). Thanks to Alexander Afanasiev.
  • Fixed inaccurate column width calculation. Closes #27. Thanks to John Yeung.
  • Added chart axis font rotation.

Release 0.3.3 - June 10 2013

  • Minor packaging fixes #14 and #19.
  • Fixed explicit UTF-8 file encoding for Python 3. PR from Alexandr Shadchin, #15.
  • Fixed invalid string formatting resulted in misleading stacktrace. PR from Andrei Korostelev, #21.

Release 0.3.2 - May 1 2013

  • Speed optimisations. The module is now 10-15% faster on average.

Release 0.3.1 - April 27 2013

Release 0.3.0 - April 7 2013

Release 0.2.9 - April 7 2013

  • Added worksheet tables. See Working with Worksheet Tables and Example: Worksheet Tables.

  • Tested with the new Python stable releases 2.7.4 and 3.3.1. All tests now pass in the following versions:

    • Python 2.6
    • Python 2.7.2
    • Python 2.7.3
    • Python 2.7.4
    • Python 3.1
    • Python 3.2
    • Python 3.3.0
    • Python 3.3.1
  • There are now over 700 unit tests including more than 170 tests that compare against the output of Excel.

Release 0.2.8 - April 4 2013

Release 0.2.7 - April 3 2013

Release 0.2.6 - April 1 2013

Release 0.2.5 - April 1 2013

  • Added additional Workbook() parameters 'tmpdir' and 'date_1904'.

Release 0.2.4 - March 31 2013

  • Added Workbook() 'constant_memory' constructor property to minimise memory usage when writing large files. See Working with Memory and Performance for more details.
  • Fixed bug with handling of UTF-8 strings in worksheet names (and probably some other places as well). Reported by Josh English.
  • Fixed bug where temporary directory used to create xlsx files wasn’t cleaned up after program close.

Release 0.2.3 - March 27 2013

  • Fixed bug that was killing performance for medium sized files. The module is now 10x faster than previous versions. Reported by John Yeung.

Release 0.2.2 - March 27 2013

Release 0.2.1 - March 25 2013

  • Added support for datetime.datetime, datetime.date and datetime.time to the write_datetime() method. GitHub issue #3. Thanks to Eduardo (eazb) and Josh English for the prompt.

Release 0.2.0 - March 24 2013

Release 0.1.9 - March 19 2013

  • Added Python 2.6 support. All tests now pass in the following versions:

    • Python 2.6
    • Python 2.7.2
    • Python 2.7.3
    • Python 3.1
    • Python 3.2
    • Python 3.3.0

Release 0.1.8 - March 18 2013

  • Fixed Python 3 support.

Release 0.1.7 - March 18 2013

Release 0.1.6 - March 17 2013

Release 0.1.5 - March 10 2013

Release 0.1.4 - March 8 2013

Release 0.1.3 - March 7 2013

Release 0.1.2 - March 6 2013

Release 0.1.1 - March 3 2013

  • Added the write_url() worksheet method for writing hyperlinks to a worksheet.

Release 0.1.0 - February 28 2013

  • Added the set_properties() workbook method for setting document properties.

  • Added several new examples programs with documentation. The examples now include:

    • array_formula.py
    • cell_indentation.py
    • datetimes.py
    • defined_name.py
    • demo.py
    • doc_properties.py
    • headers_footers.py
    • hello_world.py
    • merge1.py
    • tutorial1.py
    • tutorial2.py
    • tutorial3.py
    • unicode_polish_utf8.py
    • unicode_shift_jis.py

Release 0.0.9 - February 27 2013

  • Added the define_name() method to create defined names and ranges in a workbook or worksheet.
  • Added the worksheets() method as an accessor for the worksheets in a workbook.

Release 0.0.8 - February 26 2013

Release 0.0.7 - February 25 2013

  • Added final page setup methods to complete the page setup section.

    • print_area()
    • fit_to_pages()
    • set_start_page()
    • set_print_scale()
    • set_h_pagebreaks()
    • set_v_pagebreaks()

Release 0.0.6 - February 22 2013

  • Added page setup method.

    • print_row_col_headers

Release 0.0.5 - February 21 2013

  • Added page setup methods.

    • repeat_rows()
    • repeat_columns()

Release 0.0.4 - February 20 2013

  • Added Python 3 support with help from John Evans. Tested with:

    • Python-2.7.2
    • Python-2.7.3
    • Python-3.2
    • Python-3.3.0
  • Added page setup methods.

    • center_horizontally()
    • center_vertically()
    • set_header()
    • set_footer()
    • hide_gridlines()

Release 0.0.3 - February 19 2013

  • Added page setup method.

    • set_margins()

Release 0.0.2 - February 18 2013

  • Added page setup methods.

    • set_landscape()
    • set_portrait()
    • set_page_view()
    • set_paper()
    • print_across()

Release 0.0.1 - February 17 2013

  • First public release.