Release v2.0.1 · qax-os/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:

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 a 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

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 getting sheet map errors, resolve issue #404
Enhance compatibility with PivotTable, resolve issue #413
Enhance compatibility with font size and a 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