Excelize 2.3.2 is Released – Go library for spreadsheet (Excel) files
Tags: go, excel, xlsx
Published: 2021-01-03 16:57:11

---
title: Excelize 2.3.2 is Released – Go library for spreadsheet (Excel) files
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,Golang,XLSX
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/3n2te2qcxfy7upsnibf3.png
---

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

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

### Notable Features

* The function [`AddPivotTable`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.AddPivotTable) now support none-column and multi-data fields, related issue [#710](https://github.com/xuri/excelize/issues/710)
* The function [`GetCellValue`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.GetCellValue) support custom date-time number format, related issue [#703](https://github.com/xuri/excelize/issues/703)
* The function [`CalcCellValue`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.CalcCellValue) now support new formula function `AND`, `CLEAN`, `TRIM`, `LOWER`, `PROPER`, `UPPER` and `OR`, related issue [#701](https://github.com/xuri/excelize/issues/701) and [#747](https://github.com/xuri/excelize/issues/747)
* The range of data validation now supports float decimal, related issue [#739](https://github.com/xuri/excelize/issues/739)
* The function [`AddChart`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.AddChart) now support to set marker type and custom line width, related issue [#549](https://github.com/xuri/excelize/issues/549) and [#657](https://github.com/xuri/excelize/issues/657)
* The [`AddChart`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.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&trade;, resolve issue [#627](https://github.com/xuri/excelize/issues/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](https://github.com/xuri/excelize/issues/732)

### Bug Fixes

* Prevent formula lexer panic on retrieving the top token type on some invalid formula, resolve issue [#711](https://github.com/xuri/excelize/issues/711)
* Fix missing worksheet when renaming with same names, resolve issue [#713](https://github.com/xuri/excelize/issues/713)
* Fix wrong worksheet index returned by [`NewSheet`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.NewSheet) in some case, resolve issue [#714](https://github.com/xuri/excelize/issues/714)
* Fix panic on formatted value with no built-in number format ID, resolve issue [#715](https://github.com/xuri/excelize/issues/715) and [#741](https://github.com/xuri/excelize/issues/741)
* Rounding numeric with precision for formula calculation, resolve issue [#727](https://github.com/xuri/excelize/issues/727)
* Fix row duplicate mechanism [#729](https://github.com/xuri/excelize/issues/729)
* Fix incorrect active tab after delete worksheet in some case, resolve issue [#735](https://github.com/xuri/excelize/issues/735)
* Fix [`AddPicture`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.AddPicture) autofit failure with multi merged cells, resolve issue [#748](https://github.com/xuri/excelize/issues/748)

### Performance

* Stream writing memory usage decrease about 60%, related issue [#659](https://github.com/xuri/excelize/issues/659)
* Optimize memory allocation `workSheetWriter`, related issue [#722](https://github.com/xuri/excelize/issues/722)
* Improve [`AddPicture`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.3.2#File.AddPicture) performance, related issue [#706](https://github.com/xuri/excelize/issues/706)

### Miscellaneous

* Unit tests and godoc updated
* [Documentation website](https://xuri.me/excelize) with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated, 3 new language: Arabic, German and Spanish language version docs published
* Welcome join [the Slack channel](https://join.slack.com/t/xuri/shared_invite/zt-eriqdkeo-wV04zcCdBiiZveFgY86Wzw), [Telegram Group](https://t.me/excelize) or [Discord channel](https://discord.gg/MWV8MBQGtv) to meet other members of our community