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 January 3, 2019, the community released version 1.4.1, which includes many new features and bug fixes. A complete list of changes is available in the Change log.

The most significant changes in this release include:

New features

  • Added the WriteTo() method, which supports file writing by implementing the IO.WriterTo interface
  • New SearchSheet() method to search a given worksheet name, cell value, or regular expression, related to Issue #277
  • New ProtectSheet() and UnprotectSheet() methods to set and unprotect worksheets to prevent other users from accidentally or intentionally changing, moving, or deleting data from worksheets
  • Added the GetMergeCells() method to get the coordinates and values of all merged cells in the current worksheet from a given worksheet name
  • Support for setting page contour properties, related issue #304
  • newgo modulesupport
  • Supports setting and getting the TopLeftCell property of a worksheet, related issue #310
  • AddChart() added support for creating 2D area charts, 2D stacking area charts, 2D percentage stacking area charts, 3D stacking area charts, 3D stacking area charts and 3D percentage stacking area charts, related issue #311

The problem to repair

  • Fixing internal functionssharedStringsReader()Solve related problems caused by the lack of traditional and strict schema XML namespace address translationissue #276
  • Fixed issue with chart formatting JSON parameter structure tag definition
  • Fixed issue #290 with null pointer exception when obtaining cell formula in some cases
  • Gets all cells in a specified worksheet by GetRows(). The return value ignores blank lines at the end of the worksheet, addressing issue #195
  • Fixed issue #297 where GetSheetMap() returns worksheet indexes and names incorrectly in some cases
  • Fixed issue #308 when deleting worksheets by index in some cases

other

  • Refactoring of unit tests, related issue #322
  • With the new Logo designed for Excelize, a lot of documentation was updated