loading...

Excelize 2.3.0 Released

xuri profile image xuri ・2 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.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

Posted on by:

Discussion

pic
Editor guide
 

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