Excelize is a library for manipulating Office Excel documents written in the Go language, based on the ECMA-376 OOXML Spec. It can be used to read and write XLSX files. Compared to other open source libraries, Excelize supports manipulating Excel with Pivottables, slicers, charts and images, inserting images into Excel and creating simple charts, and can be used in a variety of reporting systems.

Making: github.com/xuri/exceli…

On July 1, 2019, the community officially released version 2.0.1, which contains a number of new features, bug fixes, and compatibility improvements. Here’s a summary of what’s been updated for this release, and a complete list of changes can be seen in the Change log.

Release Notes

The most significant changes in this release include:

New features

  • New SetHeaderFooter() method to support setting header and footer, related issue #394
  • New SetColStyle() method to support setting column styles, related issue #397
  • New SetDefaultFont() and GetDefaultFont() methods to support setting the default font for workbooks, related issue #390
  • New SetDocProps() and GetDocProps() methods to set and get document properties, related to Issue #415
  • AddChart() adds 26 new chart creation options: Clusters of cone, cone, percentage of cone them, three dimensional figure, clusters of cone cone figure, percentage accumulation level cone figure, the accumulation level cone figure, clusters of pyramid figure, accumulation of a pyramid, percentage accumulation of a pyramid, three-dimensional pyramid figure, clusters of pyramid diagram, accumulation levels pyramid figure, accumulation percentage level of a pyramid figure, clusters of bar charts , Stacking bar chart, percentage stacking bar chart, 3D bar chart, cluster horizontal column chart, stacking horizontal column chart, stacking percentage horizontal column chart, 3D surface chart, vertical frame surface chart, 3D surface frame chart, bubble chart, and 3D bubble chart. Unsupported chart types will return an error message
  • New SetDefinedName() and GetDefinedName() methods to set and get names
  • Optimized and clarified error messages when opening encrypted files
  • The function AddPicture() now supports adding TIF and TIFF images

The problem to repair

  • Fixed an issue when double quotes exist in data validation formulas
  • Fixed internal counting errors causing duplicate annotation in some cases, related issue #373
  • Fixed issue #404 where file reading failed due to internal worksheet map error in some cases
  • Improved compatibility with documents that contain pivottables, related to Issue #413
  • Improved compatibility between font size and bold style, related to issues #411, #420 and #425
  • Optimize internal recalculation components to fix partially deleted or inserted rows in worksheets causing document corruption, related issues #421 and #424
  • Fixed issue #418 where hidden worksheets failed in some cases
  • Fixed internal theme color index overflow causing document corruption in some cases with too many chart series, related issue #422

other

  • Improve the unit test to improve the coverage, and the line coverage reached 96.05%
  • Code optimization, fix golint problem