DEV Community ๐Ÿ‘ฉโ€๐Ÿ’ป๐Ÿ‘จโ€๐Ÿ’ป

DEV Community ๐Ÿ‘ฉโ€๐Ÿ’ป๐Ÿ‘จโ€๐Ÿ’ป is a community of 966,904 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
xuri
xuri

Posted on • Updated on

Excelize 2.2.0 Released

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

Top comments (0)

๐ŸŒš Browsing with dark mode makes you a better developer.

It's a scientific fact.