DEV Community ๐Ÿ‘ฉโ€๐Ÿ’ป๐Ÿ‘จโ€๐Ÿ’ป

DEV Community ๐Ÿ‘ฉโ€๐Ÿ’ป๐Ÿ‘จโ€๐Ÿ’ป is a community of 963,274 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
xuri
xuri

Posted on • Updated on

Excelize 2.3.0 Released

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

Top comments (2)

Collapse
 
xuri profile image
xuri Author

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

Take a look at this:

Settings

Go to your customization settings to nudge your home feed to show content more relevant to your developer experience level. ๐Ÿ›