Go Language Spreadsheet Library: Excelize 2.3.2 Released

Excelize is a library written in pure Go that provides a set of functions that allow you to read and write XLSX / XLSM / XLTM files. Supports reading and writing of spreadsheet documents generated in Microsoft Excel & trade; 2007 and later. It is highly compatible, supports complex components, and provides a streaming API for generating or reading data from worksheets that contain large amounts of data.

In some cases, import existing Excel document content, create a new Excel document, generate a new Excel document based on an existing document (template), insert an image into an Excel document, manipulate an Excel document such as a chart programmatically. is needed. Elements such as tables. You may need to implement these operations across platforms. Excelize can easily meet these needs.

Open Source

GitHub: github.com/xuri/excelize

Doc: xuri.me/excelize/ja

2021-1-4, version 2.3.2 has been released. Notable are some new areas of functionality and numerous bug fixes.

A summary of the changes can be found in the Release Notes (https://github.com/360EntSecGroup-Skylar/excelize/releases/tag/v2.3.2).

Release notes

The most notable changes in this version are:

new function

• The PivotTable API AddPivotTable supports default columns and multiple data sources, related issues # 710
• GetCellValue supports custom date and time number formats, related issues # 703
• CalcCellValue has added expression functions that support AND, CLEAN, TRIM, LOWER, PROPER, UPPER and OR, related Problem # 701 and # 747
• Data validation added support for floating point decimal interval validation rules, related issues # 739
• AddChart added support for setting the width of linetypes and line end types in data series, related issues # 549 and # 654.
• Create a chart API AddChart Support for specifying whether to close a legend that does not overlap the chart

Improve compatibility

• Improved compatibility between line charts containing more than 6 data series and Kingsoft WPS & trade; applications, related issues # 627
• In some cases avoid redundancy of internal style data
• Dynamically analyze the core data components of the workbook
• Support for workbooks with multiple rows with the same row label in the worksheet, related issue # 732

Fixing the problem

• Fixed a panic issue that could occur when the lexical analyzer parses certain incorrect expressions, related issue # 711
• Fixed an issue where the worksheet was lost when renaming the worksheet to the same name, related issue # 713
• Fixed an issue where NewSheet could return the wrong worksheet index, related issue # 714
• Fixed panic issues, related issues # 715 and # 741 when applying cell number format in certain situations using the built-in number format ID.
• Corrected data accuracy of math engine, related problem # 727
• Fixed an issue with invalid copy line data in some cases, related issue # 729
• Fixed an issue where the default active worksheet was incorrect after deleting the worksheet in some cases, related issue # 735
• Fixed an issue where AddPicture would invalidate the specified adaptive size when inserting an image into a worksheet with multiple cells merged, related issue # 748
• Fixes an issue where merged cells are handled abnormally when copying rows in some cases, related issue # 752

Performance optimization

• Memory usage during streaming data is reduced by about 60%, related issue # 659
• A related issue # 722 that optimizes the impact of the internal method worksheetWriter on memory allocation at runtime.
• Add Picture API performance improvements, related issues # 706

Other

• Improved error handling and fixed crash when opening invalid spreadsheet file
• Multilingual documentation websites: English, French, Russian, Chinese, Japanese, Korean. It has been updated. Three new document languages: Arabic, German and Spanish
• Join the Slack, Telegram Group channels and welcome to meet other members of the community.