Excelize 2.3.0 Released
Tags: go, excel, xml, office
Published: 2020-08-09 16:15:33

---
title: Excelize 2.3.0 Released
published: true
description: Excelize is a library written in pure Go and providing a set of functions that allow you to write to and read from XLSX files. 
tags: Go,Excel,XML,Office
---

<p align="center"><img src="https://xuri.me/excelize/images/excelize.svg" width="440" alt="github.com/xuri/excelize" /></p>

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](https://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](https://github.com/xuri/excelize/releases/tag/v2.3.0). A full list of changes is available in the [changelog](https://github.com/xuri/excelize/compare/v2.2.0...v2.3.0).

Release Notes
------------
The most notable changes in this release are:

#### Notable Features

* Support to set cell values concurrent, relate issue #670
* New API: [`SetSheetFormatPr`](https://pkg.go.dev/github.com/xuri/excelize/v2?@v2.3.0#File.SetSheetFormatPr) and [`GetSheetFormatPr`](https://pkg.go.dev/github.com/xuri/excelize/v2?@v2.3.0#File.GetSheetFormatPr), support to set and get worksheet formatting properties, relate issue #635
* New API: [`GetCols`](https://pkg.go.dev/github.com/xuri/excelize/v2?@v2.3.0#File.GetCols) and [`Cols`](https://pkg.go.dev/github.com/xuri/excelize/v2?@v2.3.0#Cols), support columns iterator
* [`AddChart`](https://pkg.go.dev/github.com/xuri/excelize/v2?@v2.3.0#File.AddChart) support specified logarithmic scale on Y-axis, relate issue #661
* [`AddPicture`](https://pkg.go.dev/github.com/xuri/excelize/v2?@v2.3.0#File.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`](https://pkg.go.dev/github.com/xuri/excelize/v2?@v2.3.0#File.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&trade; 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](https://xuri.me/excelize) with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated
* Welcome join [the Slack channel](https://join.slack.com/t/xuri/shared_invite/zt-eriqdkeo-wV04zcCdBiiZveFgY86Wzw) to meet other members of our community