DEV Community

loading...
Cover image for Excelize 2.3.2 is Released – Go library for spreadsheet (Excel) files

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

xuri profile image xuri ・3 min read

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

Discussion (0)

pic
Editor guide