DEV Community

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

Posted on • Edited on

1 1

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

github.com/xuri/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

Top comments (0)

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up