« Changelog History


excelize v2.1.0 Release Notes

Release Date: 2020-02-09 // about 4 years ago

  • 🚀 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