DEV Community

xuri
xuri

Posted on

Excelize 2.9.1 Released - Powerful open-source library for spreadsheet (Excel) document

#go #excel #excelize #opensource

Excelize 2.9.1 Released

Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLAM / XLSM / XLSX / XLTM / XLTX 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.9.1. Featured are a handful of new areas of functionality and numerous bug fixes.

Release Notes

The most notable changes in this release are:

Breaking Change

  • Upgrade requirements Go language version is 1.23 or later, for upgrade of dependency package golang.org/x/crypto
  • Change the data type of DataValidationType, DataValidationErrorStyle, DataValidationOperator, PictureInsertType from int to byte
  • SetCellInt function required int64 data type parameter, resolve issue 2068
  • When adding drawing objects such as pictures, charts, shapes, and form controls, the offset setting will no longer affect the size of the drawing object, related issue 2001

Notable Features

  • Add new fields GapWidth and Overlap in the Chart data type
  • Add new fields ShowDataTable and ShowDataTableKeys fields in the ChartPlotArea data type
  • Add new field Alignment in the ChartAxis data type
  • Add new field DataLabel in the ChartSeries data type
  • Add new field PageOrder for PageLayoutOptions data type
  • Add 2 new exported error variables: ErrPageSetupAdjustTo and ErrStreamSetColStyle
  • Add 2 new exported enumerations: HeaderFooterImagePositionType and IgnoredErrorsType
  • Add 2 new exported data types: CalcPropsOptions and HeaderFooterImageOptions
  • Add 2 new functions: SetCalcProps and GetCalcProps support setting and getting workbook calculation properties
  • Add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values, support apply number format for the Japanese calendar years, the Korean Danki calendar and the Republic of China year, related issue 1885
  • Add new function AddHeaderFooterImage to support set graphics in a header and footer, related issue 1395
  • Add new function AddIgnoredErrors support to ignored error for a range of cells, related issue 2046
  • Add new function SetColStyle for streaming writer to support set columns style, related issue 2075
  • The AddChart and AddChartSheet function support set chart axis text direction and rotation, related issue 2025
  • The AddChart and AddChartSheet function support set gap width and overlap for column and bar chart, related issue 2033
  • The AddChart and AddChartSheet function support set the format of the chart series data label, related issue 2052
  • The AddChart and AddChartSheet function support set data table for chart, related issue 2117
  • The AddFormControl function support set cell link for check box, related issue 2113
  • The SetPageLayout function support set page order of page layout
  • The DeletePicture function support delete one cell anchor image, related issue 2059
  • An error will be return if the option value of the SetPageLayout function is invalid
  • Support adjust data validations cross multiple worksheets, related issue 2072
  • Support apply number format with hash and zero place holder, related issue 2058
  • Support apply number format with ? symbol
  • Support to insert one cell anchor drawing object when specified the positioning as "oneCell", related issue 2002

Bug Fixes

  • Fix a v2.9.0 regression bug, corrupted workbook generated by open the workbook generated by stream writer, resolve issue 2015
  • Fix redundant none type pattern fill generated, resolve issue 2014
  • Fix missing vertical and horizontal border styles in some case, resolve issue 2048
  • Fix conditional format's border styles missing in some case, resolve issue 2061
  • Fix get pivot tables panic in some case, resolve issues 1954 and 2051
  • Fix GetStyle function can not get VertAlign format
  • Fix CalcCellValue function subexpressions aren't correctly calculated in some case, resolve issue 2083
  • Fix delete wrong images in some case which caused by image reference detection issue
  • Fix cell default style doesn't override by none-zero row style when set row by stream writer
  • Fix redundant cols element generated by stream writer
  • Fix panic on set chart title font, resolve issue 2102
  • Fix panic on delete calc chain in some case
  • Fix incorrect formula calculation result caused by shared formula parse error, resolve issue 2056
  • Fix corrupted workbook generated when an inner ZIP64 file size exceeds 4GB
  • Fix sheet name error in defined name after rename sheet, resolve issue 2126

Performance

  • Use a 3 times faster deepcopy library github.com/tiendc/go-deepcopy instead of github.com/mohae/deepcopy, related issue 2029
  • Fix performance regression in v2.9.0, reduce trim cell value memory allocation for blank cells
  • Improve performance for calculate formula when formula contains whole column and row reference
  • Rows iterator speedup about 20%, memory allocation reduce about 10%

Miscellaneous

  • The dependencies module has been updated
  • Unit tests and godoc updated
  • Documentation website with multilingual: Arabic, German, English, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Chinese Simplified and Chinese Traditional, which has been updated.
  • excelize-wasm NPM package release update for WebAssembly / JavaScript support
  • excelize PyPI package release update for Python

Thank you

Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:

  • wushiling50
  • imirkin (Ilia Mirkin)
  • Juneezee (Eng Zer Jun)
  • Arpelicy
  • zhuhaicity (ZhuHaiCheng)
  • xxf0512 (xxf)
  • gypsy1234
  • mengpromax (MengZhongYuan)
  • hly-717
  • kurtinge (Kurt Inge Smådal)
  • IvanHristov98 (Ivan Hristov)
  • artur-chopikian (Artur Chopikian)
  • romanshevelev (Roman Shevelev)
  • LZCZ
  • hm3248
  • moisespsena (Moises P. Sena)
  • paolobarbolini (Paolo Barbolini)
  • timesince
  • shcabin
  • tgulacsi (Tamás Gulácsi)
  • R3dByt3 (R3dByt3)
  • Now-Shimmer

Top comments (0)