excelize Files

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 the 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 the 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 ignoring 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