Excelize 2.1.0 Released
Tags: go, excel, xml, office
Published: 2020-02-09 16:50:13

---
title: Excelize 2.1.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 width="650" src="https://xuri.me/excelize/images/excelize.svg" alt="Excelize logo"></p>

Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX files. Supports reading and writing XLSX files generated by Microsoft Excel™ 2007 and later. Supports saving a file without losing original charts of XLSX.

**GitHub:**  [github.com/xuri/excelize](https://github.com/xuri/excelize)

We are pleased to announce the release of version 2.1.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.1.0). A full list of changes is available in the [changelog](https://github.com/xuri/excelize/compare/v2.0.2...v2.1.0).

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

#### Notable Features

* New function [`DeleteDefinedName`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.DeleteDefinedName), support to delete the defined names of the workbook or worksheet
* New functions [`SetPageMargins`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.SetPageMargins) and [`GetPageMargins`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.GetPageMargins), support to for getting setting page margins
* New functions [`DeleteChart`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.DeleteChart) and [`DeletePicture`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.DeletePicture), support to delete chart and images from the worksheet
* Add support for Excel file that uses no UTF-8 encoding
* The function [`AddChart`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.AddChart) now support to create the pie of pie chart, the bar of pie chart and combo chart
The function [`AddChart`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.AddChart) now support to set minor grid lines for the chart, relate issue #501
The function [`AddChart`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.AddChart) now support to set line width of the line chart, relate issue #505
The function [`AddChart`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.AddChart) now support to set a major unit and tick label skip for the chart, relate issue #538
* The function [`SetColVisible`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.SetColVisible) now support to set column visible by column range
* The function [`AddPivotTable`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.AddPivotTable) allow empty columns in the pivot table, relate issue #511

#### Bug Fixes

* Fix missing ending space text of the cell
* The [`MergeCell`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.MergeCell) function support overlapped merge cells, resolve issue #533
* Added handling of empty inline rich text in some case, resolve issue #529
* Added handling of empty workbook view in some case, resolve issue #426
* Added handling of escape character in the formula, resolve issue #546

#### Performance

* New functions [`NewStreamWriter`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.NewStreamWriter) and [`Flush`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#StreamWriter.Flush) to generate the new worksheet with huge amounts of data. Compared to non-streaming writing, reduced memory usage by 90.2%, time cost by 53%
* Make [`GetRows`](https://pkg.go.dev/github.com/xuri/excelize/v2@v2.1.0#File.GetRows) function read data as streaming. Reduced memory usage by 78.9%, relate issues #146 and #382
* Compatibility improvements, adding 49 internal XML namespaces support

#### Miscellaneous

* Added logging of possible errors when decoding XML, relate issues #539
* Improve code coverage unit tests (line Coverage: 97.04%)
* 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