Excelize v2.1.0

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 getting and 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, related issue #501
  • The function AddChart now support to set line width of the line chart, related issue #505
  • The function AddChart now support to set a major unit and tick label skip for the chart, related issue #538
  • The function SetColVisible now support to set column visible by column range
  • The function AddPivotTable allow empty columns in the pivot table, related 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

results matching ""

    No results matching ""