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

Miscellaneous

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