DEV Community: xuri

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

xuri — Wed, 04 Mar 2026 04:45:40 +0000

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

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

xuri — Fri, 17 Oct 2025 04:43:30 +0000

GitHub: github.com/xuri/excelize

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.

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:

DengY11 (Yi Deng)
JerryLuo-2005
aliavd1 (Ali Vatandoost)
xiaoq898
Now-Shimmer
Jameshu0513
mengpromax (MengZhongYuan)
Leopard31415926
hongjr03 (Hong Jiarong)
juefeng
black-butler
Neugls
Leo012345678
a2659802
torotake
crush-wu
zhuyanhuazhuyanhua
shcabin

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

xuri — Mon, 12 May 2025 16:40:37 +0000

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

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

xuri — Wed, 16 Oct 2024 06:52:00 +0000

GitHub: github.com/xuri/excelize

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

Change the data type for the ConditionalFormatOptions structure field Format as a pointer, resolve issue #1867

Notable Features

Add new functions DeleteSlicer and GetSlicers, related issue #810
Add new function MoveSheet to support changing sheet order in the workbook, related issue #1076
Add new AutoFitIgnoreAspect field in the GraphicOptions data type support for fill the cell with the image and ignore its aspect ratio
Add new TickLabelPosition field in the ChartAxis data type support for set label position of the chart
Add new fields ShowAll, InsertBlankRow and NumFmt field in the PivotTableField data type
Add new fields ClassicLayout, FieldPrintTitles and ItemPrintTitles in the PivotTableOptions data type
Introduce 2 new exported enumeration type ChartTickLabelPositionType and PictureInsertType
Introduce new exported ChartLineUnset enumeration value
Introduce 4 constants ExtURIDataField, ExtURIPivotField, ExtURIPivotFilter and ExtURIPivotHierarchy
Introduce new exported error variable ErrPivotTableClassicLayout
The MergeCell function support clear slave cells value when merging cells
The AddDataValidation, DeleteDataValidation and GetCellStyle functions support concurrency safe, related issues #1825
The GetDataValidations function support get data validations which storage in the extension lists, related issue #1835
The SetSheetName function support case sensitivity, related issue #1856
The GetPictureCells and GetPictures functions support for get the cell images inserted by IMAGE formula function and absolute paths for pictures
The SetCellHyperLink function support remove hyperlink by None linkType, related issue #1940
The AddChart function support create combo chart with same types, related issue #1940
The AddChart function support set line type of scatter chart
An error will be return if column header cell is empty in pivot table data range when create pivot table by AddPivotTable function, related issue #1945
Add support for applying number format expression with language/location tags and ID
Add support for apply number format for time and duration cell value, related issue #2004
New support formula function: DOLLAR

Improve the Compatibility

Improve compatibility for apply number format, support apply number format with alignment, resolve issue #1847
Improvement compatibility for the workbook internal part with a spreadsheet namespace prefix, resolve issue #1886
Improve compatibility for the workbook internal media files with absolute path, resolve issue #1888

Bug Fixes

Fix a v2.8.1 regression bug, auto filter doesn't work in the LibreOffice, resolve issue #1830
Fix a v2.8.1 regression bug, support to adjust data validation with multiple cell range, resolve issue #1831
Fix a v2.8.1 regression bug, error on duplicate rows, if conditional formatting or data validation has multiple cell range reference
Fix a v2.8.1 regression bug, incorrect cell value written if save multiple times, resolve issue #1906
Fix a v2.8.1 regression bug, spark lines duplicate when creating spark lines on multiple sheets, resolve issue #1910
The CalcCellValue function support calculate formula functions ISNUMBER, OR and FIND with matrix arguments, resolve issue #1819
Fix the CalcCellValue function calculation result round issue, resolve issue #1851
Fix the CalcCellValue function returns incorrect result of formula functions XIRR and XNPV, resolve issue #1989
Fix the RemoveCol returns error when deleting columns, resolve issue #1829
Fix incorrect result data type of the DATE formula function, resolve issue #1833
Fix panic on read workbook with internal row element without r attribute
Fix parentheses in formulas get cut out when inserting new columns or rows, resolve issue #1861
Fix incorrect data validation escape result in some cases
Fix some character can't be displayed in stream writer, resolve issue #1865
Saving workbook with sorted internal part path to keep same hash of identical files and fix incorrect MIME type, resolve issue #1889
Fix the AddChart function set axis format doesn't work in combo chart, resolve issue #1921
Fix the AddChart function set incorrect primary axis titles position
Fix the AddChart function set secondary vertical axis title is not displayed, resolve issue #1926
Fix the AddChart function set line type of line chart does not work
Fix the GetPivotTables function returns incorrect data range, resolve issue #1937
Fix the GetStyle function panic when theme without sysClr, resolve issue #1963
Fix the GetCellRichText function returns error when read cell without SST index, resolve issue #1999
Fix the SetSheetVisible function panic on none views sheet, resolve issue #1969
Fix percent sign missing in formatted result for zero numeric cell value, resolve issue #1942
Fix missing horizontal axis in scatter chart with negative values
Fix missing shape macro missing after adjusted drawing object, resolve issue #1957
Fix missing conditional formatting after remove column in some cases, resolve issue #1968
Fix read cell value with decimal value round issue, resolve issue #1979
Support to set cell value with an IEEE 754 "not-a-number" value or infinity, resolve issue #119

Performance

Fix v2.8.0 regression speed slowdown and memory usage increase issue
Reduce memory usage for the GetRows function, related issue #1874
Optimize ColumnNumberToName function performance, reduce about 50% memory usage and 50% time cost

Miscellaneous

The dependencies module has been updated
Unit tests and godoc updated
Documentation website with multilingual: Arabic, German, English, Spanish, French, Japanese, Korean, Portuguese, Russian, Chinese Simplified and Chinese Traditional, which has been updated. Added Italian version of the document

Thank you

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

mirgong (helloWorld)
YueChenXu-Kimi (岳晨旭)
JackMin1314 (陈王)
paolobarbolini (Paolo Barbolini)
iEvan-lhr (Evan lu)
yetyear (yeahyear)
ha5ky (hu5ky)
lizhichao (vic)
realzuojianxiang (realzuojianxiang)
msackman (Matthew Sackman)
yyle88 (yangyile-yyle88)
yunkeweb (yunkeweb)
iraj720 (Nima)
jianxinhou
barlevd
18409615759 (nna)
qijinkui (xiaokui)
user1121114685 (联盟少侠)
wangsongyan
vsemichev (Vovka Morkovka)
zhayt (Aybek)
ShowerBandV (ShowerBandV)
imink (Patrick Wang)
samkeke (wxy)
pjh591029530
zhangyimingdatiancai
wanghaochen2024
centurion-hub
peng (Zhang Zhipeng)
slashdotdash (Ben Smith)
ArcholSevier
liuwangchao
Zncl2222 (Jian Yu, Chen)

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

xuri — Sun, 25 Feb 2024 19:32:01 +0000

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)

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

xuri — Sun, 27 Aug 2023 16:16:00 +0000

GitHub: github.com/xuri/excelize

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

Rename exported variable ErrTableNameLength to ErrNameLength
Rename exported type PaneOptions to Selection
Rename the Runs field to Paragraph in the exported Comment data type
Remove the Lang field in the Style data type
Removed exported ChartTitle data type, and using the RichTextRun data type instead of it
Changed the data type for the DecimalPlaces to pointer of integer
Change the default point to pixels conversion factor, resolve issues #279 and #1536
Change the AddShape function signature: func (f *File) AddShape(sheet, cell string, opts *Shape) error to func (f *File) AddShape(sheet string, opts *Shape) error

Notable Features

Add new exported error variables ErrExistsTableName and ErrorFormControlValue
Add new options ShortDatePattern, LongDatePattern, LongTimePattern and CultureInfo in the Options data type, related issue #1199
Add new exported data type CultureName enumeration for country code
New functions GetTables and DeleteTablesupport to get and remove tables, related issues #674 and #1454
New function GetStyle support to get style definitions, related issues #314, #1520 and #1521
Support applying cell value with placeholder, padding, rounds numbers, currency, accounting and switches argument number format, and support applying date and time number format for 812 language tags, related issue #660
New support 10 formula functions: ARRAYTOTEXT, FORECAST, FORECAST.LINEAR, FREQUENCY, INTERCEPT, ODDFYIELD, ODDLPRICE, ODDLYIELD, PROB, VALUETOTEXT
Add file path length limitation details in the error message
New function GetPanes support to get sheet panes and view selection
New functions AddFormControl, GetFormControls and DeleteFormControl support to form controls, related issues #301 and #1169
The AddChart function support set primary titles, related issue #1553
The AddChart function support creating chart with a secondary series axis, related issue #518
The AddChart function support formatting and setting rich text titles for the chart, related issue #1588
Add check for shape type for the AddShape function, an error will be returned if no shape type is specified
Support read cell values formatted by the Japanese calendar number format, related issue #1590
The GetPictures function support read one cell anchor pictures, related issue #1585
The NewConditionalStyle function support to create a conditional format with number format and protection, related issue #1610

Improve the Compatibility

Support checking cell value length with multi-bytes characters, related issue #1517
Prevent create duplicate tables and defined name with the same name
Improve the cell comment box shape size compatibility with KingSoft WPS
Support fallback to default column width in sheet format property, related issue #1536
Made case in-sensitive for internal worksheet XML path to improve compatibility, related issue #1591

Bug Fixes

Escape XML characters after checking cell value length, fix stream writer generated file corrupted, resolve issues #1518, #1519 and #1530
Fix incorrect comment box size for multi-line plain text comments
Preventing format text cell value as a numeric, resolve issues #1523, #1528 and #1533
Fix race conditions for concurrency safety functions
Fix incorrect round millisecond for the date time
Fix incorrect number formatted result for date and time with 12 hours at AM
Fix incorrect formula functions SUMIFS and AVERAGEIFS result, resolve issue #1564
Fix basic arithmetic operator priority issues in the calculating engine, resolve issue #1599
Fix across worksheet reference issue for the formula calculation engine
Fix adjust table issue when after removing rows, resolve issue #1539
Support to get multiple images in one cell, resolve issue #1548
Fix the added picture position was incorrect in some cases, resolve issue #1560
Support adjusting the formula when inserting columns and rows, fix the workbook corruption caused by inserting columns or rows caused, resolve issue #1565
Formula function CONCAT, CONCATENATE support concatenation of multiple cell values, resolve issue #1569
Fix incorrect formula calculate results on a nested argument function which returns a numeric result, resolve issue #1582
Fix internal graphic object counter issues caused added picture was duplicated, resolve issue #1584
Fix read date time cell result was incorrectly caused by hours rounding issue, resolve issue #1587
Fix panic on getting merged cells with the same start and end axis

Performance

Optimizing regexp calls to improve performance, related issue #1532
This avoid unnecessary byte/string conversion, related issue #1541

Miscellaneous

The dependencies module has been updated
Simplify variable declaration and error return statements
Remove the built-in language number format code mapping with Unicode values
Remove the internal xlsxTabColor data type, using the xlsxColor data type instead of xlsxTabColor
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:

IAkumaI (Valery Ozarnichuk)
sillydong (Chen Zhidong)
fudali113 (fudali)
Juneezee (Eng Zer Jun)
joehan109
yicixin (壹次心)
vb6iscool
chengcxy (chengxinyao)
lidp20
JDavidVR (David)
fsfsx
cnmlgbgithub

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

xuri — Sun, 09 Apr 2023 16:23:00 +0000

GitHub: github.com/xuri/excelize

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

Remove the Color field in the ChartLine data type
Replace the data type ShapeParagraph with RichTextRun
Remove the Color field from the type Shape, and uses the Fill instead of it
Remove the exported type AutoFilterListOptions
Rename the exported type TableOptions to Table
The AddChart function require using ChartType enumeration value to specify the chart type
Change 7 functions signature:
- Change the func (f *File) AutoFilter(sheet, rangeRef string, opts *AutoFilterOptions) error to func (f *File) AutoFilter(sheet, rangeRef string, opts []AutoFilterOptions) error
- Change the func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *GraphicOptions) error to func (f *File) AddPictureFromBytes(sheet, cell string, pic *Picture) error
- Change the func (f *File) GetPicture(sheet, cell string) (string, []byte, error) to func (f *File) GetPictures(sheet, cell string) ([]Picture, error)
- Change the func (f *File) AddVBAProject(bin string) error to func (f *File) AddVBAProject(file []byte) error
- Change the func (f *File) GetComments() (map[string][]Comment, error) to func (f *File) GetComments(sheet string) ([]Comment, error)
- Change the func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error to func (f *File) AddTable(sheet string, table *Table) error
- Change the func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error to func (sw *StreamWriter) AddTable(table *Table) error

Notable Features

Add new functions SetSheetDimension and GetSheetDimension for workbook dimension supports, related issue #1463
The NewStyle function support to create of 17 kinds of fill variants styles
Increase max cell styles limit to 65430
The AddPicture function allowing insert BMP format images
The GetPictures function support to get multiple images in a cell
The SetConditionalFormat function support to creating a conditional format with a "stop if true" or "icon sets" rule
The SetConditionalFormat function support to set border color and create solid color for the color data bar, related issue #1462
The AddChart function support to set the format for the chart data series solid fill, related issue #1474
The AddChart function support to set the bubble size in a data series
The AddChart function support to specifies the values in second plot for the bar/pie of pie chart
The AddChart function support to set number format for chart data labels and axis, related issue #1499
The AddTable function support to specify if show header row of the table when create the table
The AddTable function support to validate table name, and added a new error constant ErrTableNameLength, related issue #1468
The AutoFilter function support to add multiple filter columns when create auto filter
The CalcCellValue function support to specify if applying number format style for the cell calculation result
The CalcCellValue function support double-byte chars for formula functions: LEFT, LEN, LENB, MID, MIDB, RIGHT and RIGHTB, related issue #1476
The CalcCellValue function now returns formula error string in the result, and using the error message in returns error, related issue #1490
Case-insensitive for the image file extension name, related issue #1503
The stream writer will be skip set cell value when got nil value, related issue #756
The GetCellHyperLink function support get cell hyperlink for merged cells
Add new exported data type ChartType for represents chart type enumeration

Improve the Compatibility

Add support for workbook function groups
Add support for strict theme namespace, related issue #1447
Fix panic caused by the workbook relationship part not exist
Improve compatibility with SST index which contains blank characters, related issue #1508

Bug Fixes

Fix decimal number format round issue in some cases
Fix incorrect cell type when modifying string cell with the time number, resolve issue #1464
Fix cell resolver caused incorrect calculation result, resolve issue #1469
Fix conditional format data bar min/max value doesn't work, resolve issue #1492
Supports 0 row height and column width, resolve issue #1461

Performance

Improve performance for apply number format with month name, related issue #1455
Speed up for checking merged cells, related issue #1448

Miscellaneous

A pure WebAssembly / Javascript port of Go Excelize library named excelize-wasm NPM package has been production-ready use
The dependencies module has been updated
Unit tests and godoc updated
Using the specialized name in variables and functions
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:

liron-l (Liron Levin)
nathj07 (Nathan Davies)
Josh-Weston (Josh Weston)
jaby
FlowingSPDG (Shugo Kawamura)
barismar (Baris Mar Aziz)
doingNobb (张涛)
rpoetrap (Rizki Putra)
huangshaokun
CHANTXU64 (ChantXu64)
playGitboy

Excelize 2.7.0 Released - Go language API for spreadsheets (Excel) files

xuri — Sun, 08 Jan 2023 16:19:00 +0000

GitHub: github.com/xuri/excelize

We are pleased to announce the release of version 2.7.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.16 or later, for migration of deprecation package ioutil
Checking and return error for invalid sheet name instead of trim invalid characters
The GetCellStyle function no longer return master cell style of the merge cell range
Rename 5 exported data types and error constant:
- Rename PivotTableOption to PivotTableOptions
- Rename FormatHeaderFooter to HeaderFooterOptions
- Rename FormatSheetProtection to SheetProtectionOptions
- Rename SparklineOption to SparklineOptions
- Rename ErrExistsWorksheet to ErrExistsSheet
Remove 54 exported types, get more details from the release page on the official documentation website
Change 21 functions signature, get more details from the release page on the official documentation website
- SetPageLayout
- GetPageLayout
- SetPageMargins
- GetPageMargins
- GetSheetIndex
- SetSheetName
- GetSheetVisible
- DeleteSheet
- NewSheet
- NewConditionalStyle
- NewStyle
- AddChart
- AddChartSheet
- AddShape
- AddPicture
- AddPictureFromBytes
- AddTable and stream mode AddTable function
- AutoFilter
- SetPanes
- SetConditionalFormat
Introduce new function to instead of existing functions:
- Use SetSheetProps instead of SetSheetPrOptions and SetSheetFormatPr
- Use GetSheetProps instead of GetSheetPrOptions and GetSheetFormatPr
- Use SetSheetView instead of SetSheetViewOptions
- Use GetSheetView instead of GetSheetViewOptions
- Use SetWorkbookProps instead of SetWorkbookPrOptions
- Use GetWorkbookProps instead of GetWorkbookPrOptions
- Use InsertRows instead of InsertRow for support inserting multiple rows at once
- Use InsertCols instead of InsertCol for support inserting multiple columns at once
Add CellTypeFormula, CellTypeInlineString, CellTypeSharedString and remove CellTypeString in CellType enumeration
The parameter has been changed for the AddComment function, support create rich-text in comments, related issue #1204
Remove internal error log print, an error will be returned when XML deserialize error, add error return value for the GetComments, GetDefaultFont and SetDefaultFont functions

Notable Features

Add new functions GetDataValidations and GetConditionalFormats for get data validations and conditional formats, related issue #827
Add new functions ProtectWorkbook and UnprotectWorkbook for workbook protection supports
Add new function SetSheetCol for set worksheet column cells, related issue #1247
Add new function GetColStyle for set column styles, related issue #1293
Add new function SetSheetBackgroundFromBytes for set background picture by given image data, related issue #1405
Add new export variable IndexedColorMapping
Add 20 export types: AutoFilterListOptions, AutoFilterOptions, Chart, ChartAxis, ChartDimension, ChartLegend, ChartLine, ChartMarker, ChartPlotArea, ChartSeries, ChartTitle, ConditionalFormatOptions, PaneOptions, Panes, GraphicOptions, Shape, ShapeColor, ShapeLine, ShapeParagraph and TableOptions
New support 2 formula functions: AGGREGATE and SUBTOTAL
The Save, Write and WriteTo function now accept saving options, related issue #744
The AddChart function support specify if smooth line of the line chart, related issue #1290
The AddChart function support set custom line color in the charts, related issue #1345
The AddChart function support custom chart axis font style, related issue #320
The AddChart function support create 3D line chart
The functions SetColWidth, GetColWidth, SetColVisible, GetColVisible, SetColStyle and GetColStyle now support concurrency safe
An error will be returned when set the not exist style ID, related issue #1323
An error will be returned when setting the stream row without ascending row numbers, to avoid potential mistakes, related issue #1139
The stream writer will be apply style in RowOpts for each cell, related issue #1354
The stream writer support to set panes, related issue #1047
The stream writer support to set inline rich text cell
The stream writer support to insert the page break
New 7 exported errors: ErrUnprotectWorkbook, ErrUnprotectWorkbookPassword, ErrStreamSetPanes, ErrSheetNameBlank, ErrSheetNameInvalid, ErrSheetNameLength and ErrSheetNameSingleQuote has been added
Introduce 5 new export data types: HeaderFooterOptions, PageLayoutMarginsOptions, PageLayoutOptions, SheetPropsOptions, and ViewOptions
Support to set summary columns to appear to the right of detail in an outline
Support to set and get font color with theme and tint, related issue #1369
Support get cell value which contains a date in the ISO 8601 format
Support set and get font color with indexed color
Support update column style when inserting or deleting columns
The workbook Close function now support cleanup stream writer temporary files
The AddPicture function now allowing insert SVG format images

Improve the Compatibility

Stream writer writes inline string type for string cell value, related issue #1377
Skip empty rows when saving the spreadsheet to reduce file size, related issue #1383

Bug Fixes

Fix decimal number format round issue with build-in number format, resolve issue #1328, #1368 and #1373
Fix apply AM/PM number format issue in some case, resolve issue #1338
Fix the panic when delete comments caused by slice bounds out of range, resolve issue #1343
Fix the panic when get cell value in some case, resolve issue #1384 and #1415
Fix default number format parse issue with a long string of digits, resolve issue #1360
Fix creating a sheet with an empty name cause a corrupted file, resolve issue #1361
Fix get image content was empty after inserting image
Fix generate workbook corruption after insert columns/rows in some case
Delete shared formula in calc chain when writing a formula cell, to fix generate workbook corruption in some case
Normalize the sheet name to fix behavior regression between 2.6.0 & 2.6.1, resolve issue #1365
Fix the formula calculation result issue of the OR function
Fix error on inserting columns or rows on the worksheet which contains one cell merged cell range
Fix error on getting the range of merged cells on the worksheet which contains one cell merged cell range
Fix getting incomplete rich text cell value in some cases
Escape XML characters for stream writer to avoid with corrupt file, resolve issue #1391
Fix formula function ADDRESS result error with empty worksheet name, resolve issue #1396
Fix insert picture problem in some cases, resolve issue #1404

Performance

Improve performance for stream writer merging cells, time cost decrease over 90% and reduce memory usage by about 86% at most
Improving performance for stream writer SetRow function, reduces memory usage over and speedup about 19%

Miscellaneous

The dependencies module has been updated
Unit tests and godoc updated
Using the specialized name in variables and functions
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:

cdenicola (Cooper de Nicola)
chenliu1993
davidborry
patsak (Kostya Privezentsev)
dafengge0913
Beeb0p (Artem Tarasenko)
invzhi
zhangzitao (Zitao)
jtwatson (Joseph Watson)
carbin-gun (charles.deng)
harrison3000 (Harrison)
strivek (GaoFei)
gonghaibinx
martinmr (Martin Martinez Rivera)
zclark (Zach Clark)
March0715 (March)
renxiaotu
devloppper
jianxinhou
nesstord
Bayzet (Bayzet Tlyupov)
guoweikuang (郭伟匡)
qinyuguang (Gin)
liron-l (Liron Levin)

Excelize 2.6.1 Released - Go language API for spreadsheets (Excel) files

xuri — Sun, 21 Aug 2022 16:27:29 +0000

GitHub: github.com/xuri/excelize

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

Compatibility

Rename exported type TabColor to TabColorRGB
Rename exported constant TotalColumns to MaxColumns
Rename exported variable ErrMaxFileNameLength to ErrMaxFilePathLength
Rename exported variable ErrWorkbookExt to ErrWorkbookFileFormat
Remove exported variable ErrEncrypt
Change worksheet name case-insensitive

Notable Features

New support 34 formula functions: CONVERT, COVARIANCE.S, DAVERAGE, DAYS360, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP, EDATE, EOMONTH, EUROCONVERT, GROWTH, HYPERLINK, MINVERSE, MMULT, NETWORKDAYS, NETWORKDAYS.INTL, PEARSON, RSQ, SKEW.P, SLOPE, STDEVPA, STEYX, TREND, WEEKNUM, WORKDAY, WORKDAY.INTL
New function DeleteComment support to delete comment, related issue #849
The AddShape function now support assigning a macro to the shape
Add support for the 1900 and 1904 date system, related issue #1212
Add support update cell hyperlink, related issue #1217
The AddPicture function now allowing insert EMF, WMF, EMZ and WMZ format images, related issue #1225
Make workbook open failed exception message clear, new exported variable ErrWorkbookPassword for the error message on receiving the incorrect workbook password
New exported constants MinFontSize, MinColumns and MaxCellStyles
Add array formula support for the formula calculation engine
Support for workbook encryption by password, related issue #199
RichTextRun support set superscript and subscript by vertAlign attribute
The DeleteDataValidation function support deleting all data validations in the worksheet, related issue #1254
Formula calculation engine support percentile symbol in condition criteria expression
Formula calculation engine support dependence formulas calculation, related issue #1262
Add export option MaxCalcIterations for specifies the maximum iterations for iterative calculation
Add export type ColorMappingType for color transformation types enumeration
Support adjust table range when removing and inserting column/row
Support set and get color index, theme and tint for sheet tab, related issue #1283
Add new export function GetRowOpts for rows iterator, to support get rows properties, related issue #1296

Improve the Compatibility

Improve the compatibility with invalid internal styles count, resolve issue #1211
Improve the compatibility with Google Sheet, resolve issue #1244
Stream writer now skips writing nil values when set cells value for the row, related issue #1299

Bug Fixes

Fix generated file corrupted when the same field is used for pivot table data and rows/columns, resolve issue #1203
Fix get incorrect rich text value caused by missing cell type checking, resolve issue #1213
Fix incorrect cell data types casting results when number formatting, resolve issue #1219
Fix the read cell is empty when the cell is in 0 placeholder number format style, resolve issue #1312 and #1313
Fix set cell value with column and row style inherit issue, resolve issue #1163
Fix panic when adding pane on empty sheet views worksheet
Fix the problem of multi arguments formula calculation in some case
Fix generated file corrupted caused by incorrect worksheet header footer fields order, resolve issue #1257
Fix set cell value failed in some case, resolve issue #1264
Fix the panic when set or get sheet view options on the sheet without views options
Fix generated workbook corruption caused by empty created or modified dcterms in the document core properties
Fix doc properties missing after creating new worksheet, resolve issue #1298

Performance

Improve performance for set sheet row and the merging cells, fix performance impact when resolving issue #1129
Optimization formula calculation performance
Reduces memory usage and speedup the AddComment function, resolve issue #1310

Miscellaneous

The dependencies module has been updated
Unit tests and godoc updated, made the test case compatible with go1.19
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:

@JDavidVR (David)
@sceneq
@juneezee (Eng Zer Jun)
@MichealJl (jialei)
@ww1516123
@z-hua (z.hua)
@xdlrt (yeshu)
@eaglexiang (Eagle Xiang)
@MJacred
@ReganYue (Regan Yue)
@thomascharbonnel (Thomas Charbonnel)
@ee0703 (EE)
@NaturalGao (NaturalGao)
@Sangua633

Excelize 2.6.0 Released - Go language API for spreadsheets (Excel) files

xuri — Sun, 10 Apr 2022 16:35:07 +0000

GitHub: github.com/xuri/excelize

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

Compatibility

Rename exported constants NameSpaceDublinCoreMetadataIntiative to NameSpaceDublinCoreMetadataInitiative for typo fix
Rename exported variable ErrUnsupportEncryptMechanism to ErrUnsupportedEncryptMechanism
Rename exported variable ErrDataValidationFormulaLenth to ErrDataValidationFormulaLength
Rename exported variable ErrDefinedNameduplicate to ErrDefinedNameDuplicate
Remove exported variable XMLHeaderByte
Remove second useless parameter isCurrentSheet and error returns of the function SetSqrefDropList
Remove TotalRows of row iterator

Notable Features

ProtectSheet now support protect sheet with specify algorithm: XOR, MD4, MD5, SHA1, SHA256, SHA384, and SHA512
UnprotectSheet now support specified the second optional password parameter to remove sheet protection with password verification
New support 71 formula functions: AVERAGEIFS, BETADIST, BETA.DIST, BETAINV, BETA.INV, BINOMDIST, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV, CHIINV, CHITEST, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.T, CORREL, COVAR, COVARIANCE.P, CRITBINOM, ERROR.TYPE, EXPON.DIST, EXPONDIST, F.DIST, F.DIST.RT, FDIST, F.INV, F.INV.RT, FINV, FORMULATEXT, F.TEST, FTEST, GAMMA.DIST, GAMMADIST, GAMMA.INV, GAMMAINV, GAMMALN.PRECISE, GAUSS, HOUR, HYPGEOM.DIST, HYPGEOMDIST, INDIRECT, LOGINV, LOGNORM.DIST, LOGNORMDIST, LOGNORM.INV, MODE, MODE.MULT, MODE.SNGL, NEGBINOM.DIST, NEGBINOMDIST, PHI, SECOND, SERIESSUM, SUMIFS, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, T.DIST, T.DIST.2T, T.DIST.RT, TDIST, TIMEVALUE, T.INV, T.INV.2T, TINV, T.TEST, TTEST, TYPE
Check file extension on save the workbook
Support workbook views mode and ruler display settings
Improve number format support, introduced NFP (number format parser) dependencies module for custom dates and times number format and text place holder support, include local month name and AM/PM format in 19 languages (Afrikaans, Bangla, Chinese, English, French, German, Austria, Irish, Italian, Russian, Spanish, Thai, Tibetan, Turkish, Welsh, Wolof, Xhosa, Yi and Zulu) support for number format, related issues #660, #764, #1093, #1112, #1133
New exported functions SetWorkbookPrOptions and GetWorkbookPrOptions to support setting and getting the FilterPrivacy and CodeName properties of the workbook, resolve limitations when adding VBA project to the workbook, related issue #1148
Formula engine now support calculation with the none parameter formula function after infix operator notation
Support to read boolean data type cell value
Support set hole size when create the doughnut chart by AddChart function, resolve issue #1172
Export 4 errors ErrPasswordLengthInvalid, ErrUnsupportedHashAlgorithm, ErrUnsupportedNumberFormat, ErrWorkbookExt so users can act differently on the different type of errors

Improve the Compatibility

Improve compatibility with LibreOffice, fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces, resolve issue #1122
Improve the compatibility with alternate content, support preserve alternate content in the workbook, worksheet, and drawingML
Improve the compatibility with page setup DPI fields

Bug Fixes

Fix missing page setup of worksheet after re-saving the spreadsheet, resolve issue #1117
Fix merged cells doesn't updated after opertaion in some cases
Fix style parsing issue, which causes bold and other style missing, resolve issue #1119
Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case
Correct cells style in merge range, make cell support inheritance columns/rows style, resolve issue #1129
Fix incorrect style ID returned on getting cell style in some cases
Fix incorrect build-in number format: 42
Fixed parsing decimal precision issue in some case
SetCellDefault support non-numeric value, resolve issue #1139
Fixed show sheet tabs setting was missing on save as spreadsheet in some cases, resolve issue #1160
Fix nested formula calculation result error, resolve issue #1164
Fix a part of formula function calculation result precision issue and inconsistent result precision of formula calculation under x86 and arm64 processor (CPU) architecture
This fix scientific notation parsing issue in some case
Fix the issue that the chart axis maximum and minimum didn't work when the value is 0

Performance

Improve streaming reading performance, based on the previously released version, reduce memory usage by about 50% at most for reading large data spreadsheet, and reduce 80% GC times for the row's iterator

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

Excelize 2.5.0 Released - Go language API for spreadsheets (Excel) files

xuri — Sun, 02 Jan 2022 16:38:44 +0000

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&tradde; 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.5.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:

Compatibility

Close spreadsheet and row's iterator required, the user should be close the stream after using the row's iterator, and close the spreadsheet after opening an existing spreadsheet
Change ReadZipReader as an implementation of the File, extract spreadsheet with given options, and support extract in memory or touching the filesystem
Remove unnecessary exported variable XMLHeader, we can using encoding/xml package's xml.Header instead of it
Remove unused exported error variable ErrToExcelTime

Notable Features

New API: SetRowStyle support for set style for the rows, related issue #990
New API: GetCellType support for get the cell's data type, related issue #417 and #520
New API: SetAppProps and GetAppProps support to set and get document application properites, related issue #1095
GetCellValue, GetRows, GetCols, Rows and Cols support to specify read cell with raw value, related issue #621
New support 95 formula functions: ACCRINT, ACCRINTM, ADDRESS, AMORDEGRC, AMORLINC, AVEDEV, AVERAGEIF, CHIDIST, CONFIDENCE, CONFIDENCE.NORM, COUNTIF, COUNTIFS, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, DATEVALUE, DAY, DAYS, DELTA, DEVSQ, DISC, DURATION, ERF, ERF.PRECISE, ERFC, ERFC.PRECISE, GEOMEAN, GESTEP, IFNA, IFS, INDEX, INTRATE, ISFORMULA, ISLOGICAL, ISREF, ISOWEEKNUM, MATCH, MAXA, MAXIFS, MDURATION, MINIFS, MINUTE, MONTH, ODDFPRICE, PERCENTILE.EXC, PERCENTRANK.EXC, PERCENTRANK.INC, PERCENTRANK, PRICE, PRICEDISC, PRICEMAT, PV, QUARTILE.EXC, RANK, RANK.EQ, RATE, RECEIVED, RRI, SHEETS, SLN, STANDARDIZE, STDEV.P, STDEVP, SWITCH, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, TEXTJOIN, TIME, TRANSPOSE, TRIMMEAN, VALUE, VAR, VAR.S, VARA, VARPA, VDB, WEEKDAY, WEIBULL, WEIBULL.DIST, XIRR, XLOOKUP, XNPV, XOR, YEAR, YEARFRAC, YIELD, YIELDDISC, YIELDMAT, Z.TEST, ZTEST, related issue #1002
Formula calculation engine support nested calc for IF formula, related issue #987
Formula calculation engine support get shared formula, related issue #844
Formula calculation engine support text comparison, related issue #998
Support specify the formula in the data validation range, related issue #1012
Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack
SetCellFormula now support set the shared formula
UpdateLinkedValue will skip macro sheet, related issue #1014
Fix AddPicture created duplicate image in some cases, caused by incorrect internal relationships ID calculation, related issue #1017
AddShape support set line width of add the shape, related issue #262
New options UnzipXMLSizeLimit have been added, support to specifies the memory limit on unzipping worksheet and shared string table in bytes
An error will be returned if given an invalid custom number format when creating a new style, related issue #1028
Now support set row style in the stream writer
Stream writer will create a time number format for time type cells, related issue #1107
Now support specify compact and outline for the pivot table, related issue #1029
Support get current rows/columns and total rows/columns in the stream reader, related PR #1054
Now support time zone location when set cell value, related issue #1069
Export 7 errors so users can act differently on different type of errors

Improve the Compatibility

Improve compatibility with row element with r="0" attribute
Preserve XML control character
Improve the compatibility of style settings with Apple Numbers, related issue #1059
Support multi-byte language on set header footer, related issue #1061
Preserve horizontal tab character when set the cell value, related issue #1108

Bug Fixes

Fix the data validation deletion failed, resolve issue #979
Fix set data validation drop list failed in some cases, resolve issue #986
Fix formula calculation engine LOOKUP doesn't handle array form correctly, resolve issue #994
Fix formula calculation engine LOOKUP can only find exact match, resolve issue #997
Fix formula percentages calculated incorrectly, resolve issue #993
Fix panic caused by incorrect cell read on some case
Fix conditional format bottom N not working
Fix time parse accuracy issue, resolve issue #1026 and #1030
Fix build-in scientific number format failed, resolve issue #1027
Fix small float parse error in some case, resolve issue #1031
Fix worksheet deletion failed in some case
Fix build-in time number format parse error, resolve issue #1060
Fix NewStyle returned incorrect style ID in some case
Fix merged cell range error after row/column insert/deletion in some corner case

Performance

Merge cell time cost speed up, time cost decrease over 90%
Improve streaming reading performance, unzip shared string table to system temporary file when large inner XML, memory usage decreased about 60%, related issue #1096
Worksheet list read speed up
Merge column styles to reduce spreadsheet size, resolve issue #1057

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

5th Anniversary of the Excelize Open Source 🎉

xuri — Tue, 31 Aug 2021 15:44:38 +0000

Excelize (github.com/xuri/excelize) since 2016 has become the popular choice to process spreadsheets documents among cloud-native and especially among Go language developers. Deep in essence and known for their professional support and well capabilities, Excelize is being widely used by large Internet companies, SME customers, and startup companies. Now, for the 5th anniversary of the Excelize open source, it has been released 16 versions, more than 100 contributors have participated in code contributing. I would like to thank all those who support the development and contributions of the project, and I'm very happy to be able to help anyone in need it. For me personally, creating and maintaining an open-source project requires not only the ability to write code, write documentation, and community management, the more important thing is how to keep the enthusiasm, happy, energetic, and efficient output state.

Excelize Star History

Excelize Contributors

In the future, I'll continue to work with developers in the community to optimize functions, capabilities, and performance, including to:

Make more API support concurrency safety
Keep to optimization performance for generating or reading data from a worksheet with huge amounts of data
More formula functions support in the calculation engine
Complex conditional format settings, data prediction support, etc.
Support more Chart style settings
PivotTable, PivotChart, Slicer
Number format parsing
Workbook encryption
More API will be support in the streaming reading and writing mode

At last, welcome to contribute to Excelize.