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

Why You Need to Study Javascript Fundamentals

>> Check out this classic DEV post <<