DEV Community

xuri
xuri

Posted on

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

Excelize 2.8.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.8.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

  • Upgrade requirements Go language version is 1.18 or later, for upgrade of dependency package golang.org/x/net
  • Change the data type for the HeaderFooterOptions structure fields AlignWithMargins and ScaleWithDoc as a pointer, resolve issue #1645
  • Remove unused exported data structure ShapeColor

Notable Features

  • Add new exported function SetCellUint, related issue #1681
  • Add new exported function GetPictureCells for get all picture cells, related issue #1218
  • Add new exported function GetConditionalStyle for get the conditional format style definition, related issue #1690
  • Add new exported function GetHeaderFooter for get the worksheet header and footer
  • Add new exported function AddSlicer for adding table and pivot table slicers
  • Add new exported function GetPivotTables for get pivot tables
  • Add new exported function DeletePivotTable for delete pivot table
  • Add a new Name field in the PivotTableOptions to support specify pivot table name
  • New support 7 formula functions: DBCS, SEARCH, SEARCHB, TEXT, TEXTAFTER, TEXTBEFORE and xlfn.ANCHORARRAY
  • Add export ChartLineType enumeration to specify the chart line type, related issue #1706
  • Add new Border field in the Chart data type to set the chart area border
  • Add new Type field in the ChartLine type to set the line type
  • Add new exported source relationship and namespace NameSpaceSpreadSheetXR10, ContentTypeSlicer, ContentTypeSlicerCache, and SourceRelationshipSlicer
  • Add new exported extended URI ExtURIPivotCacheDefinition
  • Allow dot character in the defined name, table name, or pivot table name
  • Keep all cells value in the table range when deleting table
  • Support format cell value with fraction number format code
  • Support delete image files from the workbook internally when deleting pictures to reduce generated workbook size and resolve potential security issues
  • Support set the height and width for the comment box, related issue #1688
  • Support update conditional formatting, data validations, defined names, drawing objects, formula reference and volatile dependencies on inserting/deleting columns/rows, related issues #1306 and #1615
  • Support 6 new kinds of conditional formatting types: text, blanks, no blanks, errors, no errors and time period
  • Support calculate formula with multiple dash arithmetic symbol
  • Support copy conditional format and data validation on duplicate row, related issue #1729
  • Support unset custom row height if the height value is -1 when using the SetRowHeight function
  • The SetRowHeight function will return an error if given an invalid row height value
  • The AddChart function support set the data labels position for the chart, related issue #1704
  • The AddChart function support set solid color or transparent fill for chart area, plot area, and maker, add a new field Fill in Chart, ChartPlotArea, and ChartMarker data type, related issue #1786
  • The AddChart function support set chart axis font family, size and strike style, related issue #1809
  • Add new field DataLabelPosition in the ChartSeries data type, support to sets the position of the chart series data label
  • Add new field BubbleSize in the Chart data type, support set the bubble size in all data series for the bubble chart or 3D bubble chart
  • Add new exported ChartDataLabelPositionType data type
  • The GetPictureCells and GetPictures function support get embedded cell images created by Kingsoft WPS™ Office, related issue #664
  • The SetConditionalFormat function support set conditional formatting with multiple cell ranges, related issue #1783
  • Support to update defined names reference when rename worksheet, related issue #1792
  • Add new GetBaseColor function support get the preferred hex color code, related issue #1794
  • The calculation engine support date and formula type cells, related issue #1807
  • Cell value reading functions inherit the Options settings of the OpenReader, related issue #1815

Improve the Compatibility

  • Improve compatibility for absolute path drawing part
  • Improve compatibility for workbook internal tab ratio property value
  • Improve compatibility with empty custom number format code
  • Improve compatibility with the viewer which doesn't support default theme part namespace, related issue #1694
  • Improve delete cell comment shape compatibility with KingSoft WPS™ Office, related issue #1789
  • Saving workbook with sorted internal part path, make identically created workbooks hash checksum is same, related issue #1732

Bug Fixes

  • Add check for MID and MIDB formula functions num_chars arguments, prevent panic on specifying a negative number, resolve issue #1647
  • Fix empty calculate result with numeric arguments in LEN, LOWER, PROPER, REPT, UPPER, and IF formula functions
  • Fix calculate formula functions CHITEST and MMULT panic in some cases
  • Fix a v2.8.0 regression bug, error on set print area and print titles with built-in special defined name
  • Fix a v2.8.0 regression bug, corrupted workbooks generated by improving compatibility with internally indexed color and MRU colors styles parts
  • Fix a v2.8.0 regression bug, number format code apply result was empty, resolve issue #1658
  • Fix a v2.7.1 regression bug, the bubble is hidden in the bubble or 3D bubble chart
  • Fixed panic on AutoFilter by adding nil pointer guard for local sheet ID, resolve issue #1655
  • Fix corrupted workbooks generated when adding tables in some cases
  • Fix incorrect time number format result, resolve issue #1661
  • Supports getting formula string cell value, resolve issue #1665
  • Fix incorrect table ID generated in the workbook which contains single table cells
  • Fix missing relationship parts in the content types in some cases
  • Upgrade number format parser to fix missing literal tokens in some cases
  • Update built-in zh-cn and zh-tw language number format
  • Fix the incorrect custom number format ID allocated, resolve issue #1677
  • Fix updating a table's range by removing it and creating it again doesn't work, resolve issue #1682
  • Fix a potential issue that stream reader temporary files can not be clear, resolve issue #1680
  • Fix incorrect formula calculation result in some cases, resolve issue #1681
  • Fix concurrency race conditions on get cell value, resolve issue #1687
  • Fix some format missing on get style definition, resolve issue #1708
  • Fix number format scientific notation zero fill issues, resolve issue #1710
  • Fix panic on read workbook with internal row element without r attribute, resolve issue #1723
  • Fix GetCellRichText returns error on getting inline rich text cells
  • Fix invalid shared string table index on set cell value in some cases
  • Fix GetConditionalFormats panic on get conditional format without above average rules, resolve issue #1745
  • Fix incorrect adjust merged cells on remove rows, resolve issue #1749
  • Fix the SetConditionalFormat function creates incorrect multiple conditional formats rules priority, resolve issue #1770
  • Fix the GetConditionalFormats function doesn't return gradient data bar rule, resolve issue #1769
  • Fix the GetStyle or GetConditionalStyle function to returns incorrect DecimalPlaces field value, resolve issue #1777
  • Fix the CalcCellValue function does not return raw value when enable RawCellValue, resolve issue #1803

Performance

  • Improves performance for adding and removing pivot table and images
  • Reduce memory consumption by trimming the rows and cells, resolve issue #1712

Miscellaneous

  • The dependencies module has been updated
  • Unit tests and godoc updated
  • Documentation website with multilingual: Arabic, German, Spanish, English, French, Russian, Chinese, Japanese, and Korean, which has been updated

Thank you

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

  • fnickels (Francis Nickels III)
  • m12r (Matthias Endler)
  • Abdelaziz-Ouhammou
  • Juneezee (Eng Zer Jun)
  • yicixin (壹次心)
  • TeeRenJing (rjtee)
  • phperic (magicrabbit)
  • kjushka (Anton Petrov)
  • krstak (Marko Krstic)
  • lpxxn (Nick)
  • ByteFlyCoding
  • yangliyl (Yang Li)
  • 15535382838
  • TajangSec (Tajang)
  • lujin1 (lujin)
  • parkoo (Tian)
  • ZhangXiao1024 (ZX)
  • zcgly
  • bramvbilsen (Bram Vanbilsen)
  • user65536
  • tianaiyouqing (天爱有情)
  • cuishuang (cui fliter)
  • CooolNv (Xuesong)
  • yuegu520
  • oneweek20169902 (li)
  • 3zmx
  • 327674413
  • melf-xyzh (MELF晓宇)
  • L4nn15ter
  • rememberher (Jerry)
  • ooooooobh (cherry)
  • xxxwang1983
  • funa12
  • coolbit
  • taitaking (zhukewen)
  • kewenof
  • ivekkairi (Vivek Kairi)
  • edwardfward (Ed)

Top comments (0)