DEV Community

xuri
xuri

Posted on • Updated on

Excelize 2.3.1 is Released – Go library for spreadsheet (Excel) files, support to open the spreadsheet with password protection

github.com/xuri/excelize

Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX / XLSM / XLTM files. Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data.

GitHub: github.com/xuri/excelize

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

Release Notes

The most notable changes in this release are:

Notable Features

  • Support open spreadsheet with password protection by ECMA-376 document standard encryption, relate issue #199
  • Add checking and limits for the worksheet
  • Extend pivot table functionality: support set the header, style, and table options for the pivot table
  • Security vulnerabilities and patches

Improve the Compatibility

  • Compatible with Go 1.15, fix unit test failed on Windows and potential race condition, relate issue #689
  • Default row height compatibility with Apache OpenOffice and Kingsoft WPS™
  • Improve compatibility for phonetic hint and sheet tab color

Bug Fixes

  • Fix RemoveRow slice bounds out of range cause panic in some case, resolve #686
  • Fix stream writer generated corrupted files issue
  • Fix the scale for add picture not work, resolve #691

Miscellaneous

  • Unit tests update and typo fixed
  • Documentation website with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated
  • Welcome join the Slack channel to meet other members of our community

Top comments (1)

Collapse
 
alhamsya profile image
alhamsya

Cool