DEV Community

xuri
xuri

Posted on

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

#excelize #productivity #python #ai

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.10.1. 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

Removed three exported error variables: ErrStreamSetColStyle, ErrStreamSetColWidth, and ErrStreamSetPanes.

Notable Features

  • Added the ChartDataPoint data type
  • Added the DataPoint field to ChartSeries
  • Added the DropLines and HighLowLines fields to ChartAxis
  • Added the Name field to GraphicOptions
  • Added two constants: MaxGraphicAltTextLength and MaxGraphicNameLength
  • Added 7 exported error variables: ErrFillType, ErrFillGradientColor, ErrFillGradientShading, ErrFillPatternColor, ErrFillPattern, ErrMaxGraphicAltTextLength and ErrMaxGraphicNameLength
  • Added the exported function GetHyperLinkCells to retrieve hyperlink cells, related issue 1607
  • Added the exported function GetSheetProtection to retrieve sheet protection settings
  • The AddComment function now returns an error when adding a comment to a cell that already has one
  • Added support for inserting ICO images, related issue 2234
  • The CalcCellValue function now supports two formula functions: SORTBY and UNIQUE
  • The AddChart and AddChartSheet functions now support setting data point colors for doughnut, pie, and 3D pie charts, related issue 1904
  • The AddChart function now supports configuring font families for East Asian and complex-script fonts
  • The AddChart function now supports drop lines and high-low lines for area and line charts
  • The GetPictures function can now return partial formatting properties, related issue 2157
  • Added the SetColVisible function to the streaming writer to set column visibility, related issue 2075
  • Added the SetColOutlineLevel function to the streaming writer to group columns, related issue 2212
  • The AddShape and AddSlicer functions now support one-cell anchor positioning for shapes and slicers
  • The GetSlicers function now supports retrieving slicers with one-cell anchor positioning
  • The SetConditionalFormat, GetConditionalFormats, and UnsetConditionalFormat functions now support the 3 triangles, 3 stars, and 5 boxes icon set conditional formats, related issue 2038
  • The UnsetConditionalFormat function now supports deleting a conditional format rule or data validation for a specific cell within a cell range
  • The AddPicture and AddPictureFromBytes functions now support setting the picture name
  • The AddChart and AddShape functions now support setting names and alternative text for charts and shapes
  • The AddSlicer function now supports setting alternative text for slicers
  • Added validation for graphic names and alternative text length; returns an error when the length exceeds the limit
  • Added UTF-16-aware length checking and truncation

Improve the Compatibility

  • Removed empty rows on save, reducing the generated workbook file size

Bug Fixes

  • Fixed a v2.10.0 regression where the GetCellValue and GetRows functions returned shared string indexes for empty strings, resolve issue 2240
  • Fixed GetPivotTables panicking when retrieving pivot tables in some cases
  • Fixed a panic when reading cell values with certain number format codes containing Chinese month names, resolve issue 2224
  • Fixed a panic when opening encrypted workbooks in some cases, resolve issue 2237
  • Fixed missing column styles when using the streaming writer SetRow function
  • Fixed GetPictures not returning some cell images
  • Fixed workbook corruption caused by light theme color index overflow
  • Fixed DeleteDataValidation updating data validation cell ranges incorrectly with unordered cell references
  • Fixed SetConditionalFormat generating corrupted workbooks when setting time period conditional formatting rules
  • Fixed CalcCellValue failing to resolve references in some cases by trimming single quotes from sheet names
  • Fixed NewStyle creating duplicate styles when using the default font or fill, resolve issue 2254

Performance

  • Optimized CalcCellValue by adding a calculation cache and limiting processing to actual data ranges, resolve issues 2057 and 2223
  • Optimized CalcCellValue formula evaluation for VLOOKUP, reducing memory usage and execution time by about 50%, resolve issue 2139
  • Optimized GetMergeCells by speeding up overlap checks for merged cell ranges and reducing memory usage, resolve issue 2226
  • Optimized applying number format codes by converting using continued-fraction recurrence formulas

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#

Thank you

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

  • pjh591029530 (Simmons25)
  • Sang-Hyuk (SangHyuk)
  • wangacc
  • kenny-not-dead (Roman Sergeev)
  • pegasscience-cyber
  • jesusfelix951-lang
  • felixdevelopper-hue
  • shcabin
  • radam9
  • sqdtss
  • IvanHristov98 (Ivan Hristov)
  • yasarluo (Yasar Luo)
  • DengY11 (Yi Deng)
  • Kingson4Wu (Kingson4Wu)
  • zhuzhengyang (Zhu Zhengyang)
  • schbook
  • rhinewg
  • jpoz (James Pozdena)
  • sides-flow (Sides)
  • t4traw (Tatsuro Moriyama)
  • ijustyce (杨春)
  • d9c4
  • imirkin (Ilia Mirkin)
  • atmngw (Atsuki)
  • Flashcqxg
  • olivere (Oliver Eilhard)
  • susautw (Su, Rin)
  • ohauer (Olli Hauer)
  • yan00353-0729

Top comments (0)