Excelize is a basic Office Excel document library written in Go language. It is based on ECMA-376, ISO/IEC 29500 international standard. You can use it to read and write spreadsheet documents created with Microsoft Excel™ 2007 and above. Supports multiple document formats such as XLSX/XLSM/XLTM, is highly compatible with documents with styles, images (tables), Pivottables, slicers and other complex components, and provides streaming read and write APIS for working with workbooks containing large amounts of data. It can be applied to various report platforms, cloud computing, edge computing and other systems. He was selected as 2020 Gopher China-Go star Open Source Project (GSP), 2018 Gitee most valuable open source project GVP, and has become the most popular Excel document base library of Go language.

Open source code

Making: github.com/xuri/exceli…

Gitee: gitee.com/xurime/exce…

英 文 版 : Xuri. me/excelize/zh…

On January 4, 2021, the community released version 2.3.2, which includes a number of new features, bug fixes, and compatibility improvements. Here’s a summary of the updates, and a complete list of changes can be found at Changelog.

Release Notes

The most significant changes in this release include:

New features

  • PivotTable API AddPivotTable supports default columns and multiple data sources, related to Issue #710
  • Getting the value of a cell using GetCellValue supports custom date and time numeric formats, related issue #703
  • Evaluates the cell’s value APICalcCellValueNew formula function supportAND,CLEAN,TRIM,LOWER,PROPER,UPPER 和 OR, the relevant issue# 701 和 # 747
  • Data validation new support for floating point decimal range validation rules, related to Issue #739
  • AddChart API added support for setting linewidth and line end type of data series, related to Issues #549 and #654
  • The chart-creation API AddChart allows you to specify whether to close legends that do not overlap charts

Improved compatibility

  • Improved compatibility with Kingsoft WPS™ applications for line charts containing more than 6 data series, issue #627
  • Avoid redundancy of internal workbook style data in some cases
  • Dynamic parsing of workbook core data widgets
  • Workbooks that support reuse of labels in the same row in a worksheet, related to issue #732

The problem to repair

  • Fixed a potential panic issue when parsing certain illegal formulas by formula lexers, related issue #711
  • Fixed issue #713 where worksheets were lost when renamed with the same name
  • Fixed issue #714 where NewSheet returned a worksheet index error in some cases
  • Fixed panic issue when applying cell number format with non-built-in number format ID in certain cases, related issues #715 and #741
  • Fixed formula calculation engine data accuracy, related issue #727
  • Fixed issue #729 where copy row data failed in some cases
  • Fixed issue #735 with default active worksheet error after deleted worksheet in some cases
  • Fixed issue #748 when using AddPicture to insert pictures into a worksheet with multiple merged cells
  • Fixed issue #752 where merging cells handled exceptions when copying rows in some cases

Performance optimization

  • Memory usage for streaming writing data is reduced by approximately 60%, issue #659
  • Optimizing internal methodsworksheetWriterRun-time impact on memory allocation, related issue# 722
  • Improved performance of AddPicture AddPicture API, related issue #706

other

  • Unit tests and documentation updates
  • Three new document languages: Arabic, German and Spanish
  • Welcome to join the technical exchange Group

DingTalk Group ID: 30047129

QQ Group ID: 207895940

WeChat ID: hixuri (please note: Excelize)