Release v2.0.2 · qax-os/excelize

We are pleased to announce the release of version 2.0.2. 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:

Upgrade requirements Go language version is 1.10 or later.

Create pivot table support. New function AddPivotTable() has been added
Create sparkline support. New function AddSparkline() has been added
New function GroupSheets() and UngroupSheets() support group and ungroup sheets
New function AddVBAProject() to support add vbaProject.bin file which contains functions and/or macros
The function SetPageLayout() now support to support to set fit to width and height, relate issue #432
The function SetSheetViewOptions() support to set whether to "show a zero in cells that have zero value" now
Allow access to more formula attributes in SetCellFormula(), support set the type of the formula and the ref attribute
Font strike style support, relate issue #482

Fix missing text of comments in some case, resolve issue #434
Fix RemoveRow() out of range in some case by recalculate offset for merged cells adjuster, resolve issue #437
Fix invalid formula in data validation drop list
Fix file corrupted when calling the Save() method in the iteration, resolve issue #443
Compatible with different types of relative paths in workbook.xml.rels to fix read file failed in some case, resolve issue #442
Fixed file corruption when deleting all merged cells in some case
Fix issue where the protection worksheet settings are invalid in some case, resolve issue #454
Fix GetSheetName doesn't work in some case by check the sheets list based on index instead, resolve issue #457
Add multi-row inline strings support, relate issue #464
Fix overflow numeric cell value on the 32-bit operating system, relate issue #386
Fix go module dependency errors, relate issue #466 and #480
Fix file corrupted when calling SetSheetPrOptions() in some case, resolve issue #483

Add missing error check in SetSheetRow()
Optimize code, combine internal functions:
workBookRelsWriter, drawingRelsWriter into relsWriter;
drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader
addDrawingRelationships, addSheetRelationships into addRels