qax-os/excelize v2.10.0 on GitHub

We are pleased to announce the release of version 2.10.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:

Breaking Change

Upgrade requirements Go language version is 1.24.0 or later, for upgrade of dependency package golang.org/x/crypto

Notable Features

Add new exported error variable ErrTransparency
Add new ChartDashType, CustomProperty and ZipWriter data types
Add new field Border to the ChartMarker data type
Add new field Font to the ChartLegend data type
Add new field Legend to the ChartSeries data type
Add new field Transparency to the Fill data type
Add new fields Dash and Fill to the ChartLine data type
Add new field TmpDir to the Options data type, support to specifies the custom temporary directory for creating temporary files, related issue #2024
Add new field Charset to the Font data type, support to explicitly specify font encodings when generating spreadsheets
Add new functions GetCustomProps and SetCustomProps support getting and setting workbook custom properties, related issue #2146
Add new function SetZipWriter, support set custom ZIP writer, related issue #2199
Add optional parameter withoutValues for the GetMergeCells function
The DeleteDataValidation function support delete data validation in extension list, and support delete data validation by given with multiple cell ranges with reference sequence slice or blank separated reference sequence string, related issue #2133
The AddChart function support set dash line and marker border type of charts
The AddChart function support to set font for chart legends, related issue #2169
The AddChart and AddChartSheet function support create 4 kinds of box and whisker stock charts: High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close and Volume-Open-High-Low-Close
The CalcCellValue function support BAHTTEXT formula function
Skip fallback to default font size when create style if font size less than minimum size
Support parse number format code with Hijri and Gregorian calendar
Support set transparency for chart and shape, related issue #2176
Support apply number format with the new 8 language: Corsican, Croatian, Croatian (Latin), Czech, Danish, Divehi, Dutch, Dzongkha language

Improve the Compatibility

Remove all leading equal symbol when set cell formula, for improve compatibility with Apple Numbers, related issue #2145
Using relative sheet target path in the internal workbook relationship parts

Bug Fixes

Fix a v2.9.1 regression bug, build failed on ARMv7 architectures, resolve issue #2132
Fix number format parser dropped empty literals in the end of the number format
Fix panic on get string item with invalid offset range, resolve issues #2019 and #2150
Fix panic on read unsupported pivot table cache sorce types, resolve issue #2161
Fix incorrect characters verification, count characters as single runes in characters length limitation checking, resolve issue #2167
Fix add pivot table caused workbook corrupted on Excel for Mac, resolve issue #2180
Fix incorrect month name abbreviations when read cell with the Tibetan language number format code
Fix special date number format result not consistent with Excel, resolve issue #2192

Performance

Optimize the GetSheetDimension function by parse worksheet XML in stream mode, speedup about 95%, memory usage reduce about 96%

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
ExcelizeCs NuGet .Net package release for C#
Add a new logo for Excelize

Thank you

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