Free Support Forum - fileformat.com

Excelize 2.3.2 is Released – Go library for spreadsheet (Excel) files

github.com/360EntSecGroup-Skylar/excelize

Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX / XLSM / XLTM files. Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data.

GitHub: github.com/xuri/excelize

We are pleased to announce the release of version 2.3.2. 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

  • The function AddPivotTable now support none-column and multi-data fields, related issue #710
  • The function GetCellValue support custom date-time number format, related issue #703
  • The function CalcCellValue now support new formula function AND, CLEAN, TRIM, LOWER, PROPER, UPPER and OR, related issue #701 and #747
  • The range of data validation now supports float decimal, related issue #739
  • The function AddChart now support to set marker type and custom line width, related issue #549 and #657
  • The AddChart function support to specify if show the legend without overlapping the chart

Improve the Compatibility

  • Improve over 6 series line chart compatibility with KingSoft WPS™, resolve issue #627
  • Avoid creating duplicate inner style in some case
  • Parse document core part (workbook) dynamically
  • Support single line with repeated row element in the worksheet data, resolve issue #732

Bug Fixes

  • Prevent formula lexer panic on retrieving the top token type on some invalid formula, resolve issue #711
  • Fix missing worksheet when renaming with same names, resolve issue #713
  • Fix wrong worksheet index returned by NewSheet in some case, resolve issue #714
  • Fix panic on formatted value with no built-in number format ID, resolve issue #715 and #741
  • Rounding numeric with precision for formula calculation, resolve issue #727
  • Fix row duplicate mechanism #729
  • Fix incorrect active tab after delete worksheet in some case, resolve issue #735
  • Fix AddPicture autofit failure with multi merged cells, resolve issue #748

Performance

  • Stream writing memory usage decrease about 60%, related issue #659
  • Optimize memory allocation workSheetWriter, related issue #722
  • Improve AddPicture performance, related issue #706

Miscellaneous

1 Like

@xuri

Thanks for sharing the details of new features and fixes of the new release. It would help the community to use it.

1 Like

@xuri,

We do encourage sharing of open source APIs and related information, but please avoid adding too many links as it looks spam and might cause the blockage of your posts. You can point to some main pages etc. I appreciate your understanding.

1 Like