We are pleased to announce the release of version 2.1.0. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.

Release Notes

The most notable changes in this release are:

Notable Features

• New function DeleteDefinedName, support to delete the defined names of the workbook or worksheet
• New functions SetPageMargins and GetPageMargins, support to for getting setting page margins
• New functions DeleteChart and DeletePicture, support to delete chart and images from the worksheet
• Add support for Excel file that uses no UTF-8 encoding
• The function AddChart now support to create the pie of pie chart, the bar of pie chart and combo chart The function AddChart now support to set minor grid lines for the chart, relate issue #501 The function AddChart now support to set line width of the line chart, relate issue #505 The function AddChart now support to set a major unit and tick label skip for the chart, relate issue #538
• The function SetColVisible now support to set column visible by column range
• The function AddPivotTable allow empty columns in the pivot table, relate issue #511

Bug Fixes

• Fix missing ending space text of the cell
• The MergeCell function support overlapped merge cells, resolve issue #533
• Added handling of empty inline rich text in some case, resolve issue #529
• Added handling of empty workbook view in some case, resolve issue #426
• Added handling of escape character in the formula, resolve issue #546

Performance

• New functions NewStreamWriter and Flush to generate the new worksheet with huge amounts of data. Compared to non-streaming writing, reduced memory usage by 90.2%, time cost by 53%
• Make GetRows function read data as streaming. Reduced memory usage by 78.9%, relate issues #146 and #382
• Compatibility improvements, adding 49 internal XML namespaces support

Miscellaneous

• Added logging of possible errors when decoding XML, relate issues #539
• Improve code coverage unit tests (line Coverage: 97.04%)
• Add missing checking error in unit tests
• Documentation website with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated