libxlsxwriter
Changes

1.0.0 September 7 2020

  • There are now over 1000 test cases, including 650 tests that compare the output from libxlsxwriter, byte for byte, against test files created in Excel. This is also the 100th release of libxlsxwriter.

0.9.9 August 17 2020

0.9.8 August 11 2020

0.9.7 August 4 2020

  • Changed lxw_chart_data_label field from .delete to .hide in order to avoid reserved word conflict with C++. Issue #300.

0.9.6 August 3 2020

0.9.5 May 31 2020

0.9.4 January 19 2020

0.9.3 January 13 2020

  • Fix Xcode/Cocoapods build warnings.

0.9.2 January 13 2020

  • Added support for writing cell comments, see Working with Cell Comments.
  • Makefile now respects DESTDIR and PREFIX, including when setting rpath on macOS.
  • Changed function names in bundled MD5 code to avoid conflicts with OpenSSL.

0.9.1 December 26 2019

  • Fix to missing MD5 linkage in Cocoapod file. Issue #259.

0.9.0 December 26 2019

  • Fix to avoid duplicate images being copied to an libxlsxwriter file. Excel uses an optimization where it only stores one copy of a repeated/duplicate image in a workbook. Libxlsxwriter didn't do this which meant that the file size would increase when then was a large number of repeated images. This release fixes that issue and replicates Excel's behavior.

    Note, that this change adds a dependency on the Openwall MD5 library, which is now included with the libxlsxwriter third party source files. It is possible to compile libxlsxwriter without this library, and thus getting the older behavior, by passing USE_NO_MD5=1 to make.

0.8.9 December 16 2019

0.8.8 November 17 2019

  • Added option to allow a user defined, or overridden, image description used with worksheet_insert_image(). By default it uses the filename as the description. Issue #238.
  • Added Windows portable version of fopen to handle utf8 filenames when working with images. Issue #238.
  • Added an option to allow chart fonts to be rotation to 270 deg to give a stacked orientation. Also added support for East Asian vertical chart fonts.
  • Refactored struct types used in pubic APIs to remove or document hidden fields. Note: This change introduces backward incompatible API changes. However, it should minimize any future changes of this nature. See issue #252.

0.8.7 June 20 2019

  • Added support for adding VBA macros to workbooks. These macros can be extracted from existing xlsm files, created in Excel, and added to new xlsm files. See Working with VBA Macros. Feature request #29.
  • Added support for ZIP64 extensions when writing very large xlsx files to allow the zip container, or individual XML files within it, to be greater than 4 GB. See workbook_new_opt(). Feature request #228.
  • Added extra validity checks on worksheet names. Issues #223 and #230.

0.8.6 April 7 2019

  • Fixed issue where images that started in hidden rows/columns weren't placed correctly in the worksheet.
  • Fixed the mime-type reported by system file(1). The mime-type reported by "file --mime-type"/magic was incorrect for XlsxWriter files since it expected the [Content_types] to be the first file in the zip container.

0.8.5 February 10 2019

  • Fix compile-time warnings with strict prototypes enabled. Issue #208.
  • Make py.test name configurable. Pull request #206.

0.8.4 November 10 2018

  • Fix for issue when hashing number formats. Issue #203.

0.8.3 October 1 2018

0.8.2 September 16 2018

0.8.1 September 15 2018

0.8.0 September 12 2018

  • Added chartsheet support. A chartsheet is a type of worksheet that only contains a chart. See the Chartsheet object and chartsheet.c.

0.7.9 September 1 2018

0.7.8 August 30 2018

0.7.7 May 16 2018

  • Fix to ensure the use of wide filenames on Windows with Microsoft Visual C++. Issue #153.
  • Added docs on building an app with Cmake and Microsoft Visual C++ on Windows. See Cmake for Microsoft Visual Studio.

0.7.6 January 11 2018

0.7.5 September 25 2017

0.7.4 August 20 2017

0.7.3 August 12 2017

  • Build system fixes for Gentoo. Issue #116.

0.7.2 July 26 2017

  • Changed font sizes from integer to double to allow fractional font sizes. Issue #114.

0.7.1 July 24 2017

  • Fixed issue where internal file creation and modification dates were in the local timezone instead of UTC. Issue #110.

0.7.0 June 26 2017

  • Added support for CMake build system. See Install using CMake. Thanks to Alex Huszagh.
  • Fixed issue where image filehandles weren't closed until the overall file was closed causing the system to run out of filehandles. Issue #106.

0.6.9 January 30 2017

0.6.8 January 28 2017

0.6.7 January 24 2017

0.6.6 January 22 2017

0.6.5 January 21 2017

0.6.4 January 20 2017

0.6.3 January 19 2017

0.6.2 January 17 2017

0.6.1 January 16 2017

  • Added option to set formatting for points in a chart. This allow the colors of Pie chart segments to be defined. See Working with Chart Points.

0.6.0 January 15 2017

0.5.9 January 14 2017

0.5.8 January 13 2017

0.5.7 January 12 2017

0.5.6 January 11 2017

0.5.5 January 10 2017

0.5.4 January 9 2017

0.5.3 January 8 2017

0.5.2 January 7 2017

0.5.1 January 6 2017

0.5.0 January 5 2017

0.4.9 January 4 2017

0.4.8 January 3 2017

0.4.7 January 2 2017

0.4.6 January 1 2017

0.4.5 December 31 2016

0.4.4 December 30 2016

0.4.3 December 26 2016

  • Added workbook_get_worksheet_by_name() function to get a worksheet object from its name.
  • Added workbook_validate_worksheet_name() function to validate a worksheet name.
  • Fix for parameter length check when strings are UTF-8. Issue #84.

0.4.2 July 14 2016

0.4.1 July 11 2016

0.4.0 July 5 2016

  • Added fixes for MSVC 2010.
  • Refactored public APIs to return lxw_error instead of int.

0.3.9 July 2 2016

0.3.8 June 11 2016

0.3.7 June 2 2016

  • Added updated Cocoapods file for Cocoapods 1.0.0. This also add support for the "use_frameworks" directive. Thanks to Ludovico Rossi. See Getting Started with libxlsxwriter for instructions on how to use the cocoapod.

    Pull request #50.

0.3.6 June 1 2016

0.3.5 May 31 2016

  • Refactored the error handling and reporting for when the file creation subsystem fails due to file permissions or other issues. The new error codes are in #lxw_error and the codes can be converted to strings, for reporting, using the new lxw_strerror() function.

    Issue #49.

0.3.4 May 28 2016

0.3.3 May 23 2016

0.3.2 April 8 2016

0.3.1 January 9 2016

  • Improved performance 20-30% for large data files.

0.3.0 January 4 2016

0.2.9 January 3 2016

0.2.8 December 22 2015

0.2.7 December 21 2015

  • Added support for escaping control characters in strings. This prevents unreadable files if string data contains control characters. Issue #42.

0.2.6 December 19 2015

0.2.5 December 14 2015

0.2.4 December 13 2015

0.2.3 December 12 2015

0.2.2 December 11 2015

  • Replaced shared strings hash table with a Red/Black tree implementation for better performance. Thanks to Martin Renters. Pull Request #41.

0.2.1 December 11 2015

  • Added worksheet_right_to_left() function. This can be used to change the default direction of the worksheet from left-to-right when creating Arabic, Hebrew or other near or far eastern worksheets that use right-to-left as the default direction.
  • Added worksheet_hide_zero() function to hide zero cell values.
  • Added worksheet_set_zoom() method to set the worksheet zoom factor.

0.2.0 December 9 2015

0.1.9 December 7 2015

  • Replaced main worksheet data structure with a Red/Black tree implementation for better performance when data isn't added in linear row-column order. Thanks to Martin Renters. Pull Request #14 and #16.

0.1.8 December 7 2015

0.1.7 September 27 2015

  • Fixed Cocoapod spec file for iOS and OS X.

0.1.6 September 27 2015

  • Added Cocoapod spec file to allow the library to be installed using CocoaPods. Pull Request #7.

0.1.5 May 3 2015

0.1.4 March 18 2015

0.1.3 March 15 2015

0.1.2 March 14 2015

0.1.1 March 13 2015

0.1.0 March 12 2015

0.0.9 March 9 2015

0.0.8 March 8 2015

0.0.7 March 7 2015

0.0.6 March 5 2015

0.0.5 March 6 2015

  • Added worksheet_select() function to set worksheets as selected.
  • Added worksheet_activate() to set the active worksheet.
  • Several portability fixes to fix warnings with different compilers.

0.0.4 March 1 2015

  • Added worksheet_set_margins() function to set top, bottom, left and right margins in a worksheet.
  • Fix for issue where format objects were written to the file in the order of creation rather than the order of use. This issue caused incorrect formats in cells. Issue #3.
  • Fix for issue where tmp files in constant_memory mode weren't closed until application exited. Issue #1.

0.0.3 January 7 2015

0.0.2 June 26 2014

  • First public release.

0.0.1 June 8 2014

  • First GitHub release.