Excelize 2.0.1 is released


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 file generated by Microsoft Excel™ 2007 and later. Supports saving a file without losing original charts of XLSX. This library needs Go version 1.8 or later.

GitHub: github.com/360EntSecGroup-Skylar/excelize

We are pleased to announce the release of version 2.0.1. 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/360EntSecGroup-Skylar/excelize/releases/tag/v2.0.1). A full list of changes is available in the change log.

Release Notes

The most notable changes in this release are:

Notable Features

  • New function SetHeaderFooter() init set header and footer support, relate issue #394
  • New function SetColStyle() support to set style by columns, relate issue #397
  • New functions SetDefaultFont() and GetDefaultFont() support to change the default font, relate issue #390
  • New functions SetDocProps() and GetDocProps(), support to set and get doc properties, relate issue #415
  • The function AddChart() now support to create new 26 types of chart: cone, pyramid and cylinder series chart for column and bar, surface 3D, wireframe Surface 3D, contour and wireframe contour,bubble and 3D bubble chart, unsupported chart type add error prompt
  • New functions SetDefinedName() and GetDefinedName() support to set and get defined names
  • More detailed error information when open the encrypted file
  • The function AddPicture() now support to add TIF and TIFF format images

Bug Fixes

  • Fix structs fields definition errors and keep double quotes in data validation formula
  • Fix comments duplicate caused by inner counting errors, resolve issue #373
  • Fix read file error caused by get sheet map errors, resolve issue #404
  • Enhance compatibility with PivotTable, resolve issue #413
  • Enhance compatibility with font size and bold style, resolve issue #411, #420 and #425
  • Enhance recalculation adjuster to resolve file broken issue, after insert or remove rows in some case, relate issue #421 and #424
  • Fix hide sheet does not work in some case, relate issue #418
  • Fix multi chart series caused file corrupted by avoid accent theme color index overflow, relate issue #422


  • Improve unit testing coverage (Line Coverage: 96.05%)
  • Optimize code, fix golint issues

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.