Sign in
Log inSign up
Excelize 2.2.0 Released

Excelize 2.2.0 Released

xuri's photo
xuri
·May 10, 2020

https://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.2.0. 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

  • Using the worksheet index instead of ID in the following functions: GetSheetName, GetSheetIndex, GetActiveSheetIndex and SetActiveSheet, relate issue #485
  • New function GetSheetList to get the worksheet, chart sheet and dialog sheet name list of workbook
  • New function AddChartSheet support create chart sheet, relate issue #451
  • New function UnsetConditionalFormat, support for remove conditional format, relate issue #571
  • New function DeleteDataValidation, support delete data validation, relate issue #348
  • New function SetCellRichText, support set rich text, relate issue #172
  • New functions InsertPageBreak and RemovePageBreak, support for insert and remove page break, relate issue #492
  • The AddPivotTable API changed, support for setting date field subtotal and names of the pivot table, relate issue #582
  • The AddPivotTable support to set filter for the pivot table, relate issue #598
  • The AddPivotTable allow empty filter, data, and rows in the pivot table
  • Export ExcelDateToTime function to convert excel date to time
  • Export Style structs to allow create the style for cells by given JSON or structure pointer, relate issue #470

Bug Fixes

  • Fix greaterThanOrEqual and lessThanOrEqual operators did not work when setting the conditional format for cell by SetConditionalFormat, resolve issue #608
  • Fix corrupt worksheet created by StreamWriter, resolve issue #576
  • Escape character in the formula, resolve issue #578
  • Fix the DuplicateRowTo function doesn't duplicate merged cells, resolve issue #586
  • Fix conditional formatting hides the adjacent borders by ignore empty conditional format style, resolve issue #200
  • Fix missing comments by GetComments, resolve issue #345
  • Fix reading wrong string by GetCellValue in some case, resolve issue #602
  • Check and fill the cell without r attribute in a row element, fix returned empty value when GetCellValue in some case
  • Allow empty or default cell style formats, resolve #628

Performance

  • Reduce redundant memory copy in getRowHeight

Miscellaneous

  • Remove calculated properties to make recalculate formulas in some spreadsheet applications, such as Kingsoft WPS™ Office
  • Add missing checking error in unit tests
  • Documentation website with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated