Excelize 2.3.0 Released

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.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

• Support to set cell values concurrent, relate issue #670
• New API: SetSheetFormatPr and GetSheetFormatPr, support to set and get worksheet formatting properties, relate issue #635
• New API: GetCols and Cols, support columns iterator
• AddChart support specified logarithmic scale on Y-axis, relate issue #661
• AddPicture support insert image autofit cell
• Add limits for total columns, row and filename length
• Formula calculation engine support defined name, relate issue #665
• API CalcCellValue update, formula calculation engine working in progress: 12 new functions has been added, COUNTA, ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISNONTEXT, ISODD, ISNUMBER, MEDIAN, NA, SUMIF

Improve the Compatibility

• Compatible to case-sensitive doc parts path
• Storage string to SST (shared string table), relate issue #622
• Support the row element without r attribute in the worksheet
• Support XML multi namespace, make compatible with Kingsoft WPS™ Office, relate issue #651
• Improve the compatibility of the auto filter with Office 2007 - 2010, resolve #637

Bug Fixes

• Avoid duplicate filter database in workbook defined name
• Avoid creating duplicate style, resolve #643
• Escape characters for set rich-text
• Fix the issue, comment shapes are changed after reopening spreadsheet created by Excelize, resolve #672
• Fix panic when enabling compiler inline flags, resolve #677 and #679
• Fix the accuracy issue of getting cell value of percentage cell

Miscellaneous

• Improved error handling and fix crash when open invalid spreadsheet file
• Add missing checking error in unit tests
• Documentation website with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated
• Welcome join the Slack channel to meet other members of our community

Comments

[xuri]

Thanks for your feedback, could you provide a spreadsheet xlsx attachment without confidential info?