excelize Files

We are pleased to announce the release of 1.3.0.

Release Notes

The most notable changes in this release are:

API Changed

• Make row index consistent in function SetRowHeight() and GetRowHeight(), fix issue [#205]

Notable Features

• New function SetSheetRow() has been added for support write the whole line at once, relate issue [#96] and [#194]
• New functions GetColOutlineLevel(), GetRowOutlineLevel(), SetColOutlineLevel() and SetRowOutlineLevel() has been added for suppport creat group
• Add iterator method for Rows, new functions Columns(), Next() and Error() has been added
• Function SetCellValue() now supports bool and time.Duration type value
• Function AddTable() now supports set name of table, relate issue [#216]
• Function AddPicture() now supports set the positioning of a picture, relate issue [#214]
• Function GetCellValue() now supports read inlineStr type cell value, relate issue [#208] and pull request [#209]
• Function AddChart() now supports set custom chart size
• Add 3D, 3D 100%, clustered, stacked and 100% stacked bar and column series charts supported, relate issue [#160] and [#190]
• Add a hyperlink to image support for the function AddPicture(), relate issue [#185]
• Add protection properties associated with the cell support, relate issue [#191]
• Add categories or values on reverse order (orientation of the chart) support, and set auto or fixed maximum, minimum of the axis, relate issue [#202]

Bug Fixes

• Fix DeleteSheet() make broken file caused by activeTab tag calculation wrong, relate issue [#165]
• Fix read columns count wrong in specific worksheet data, relate issue [#175]
• Handle special shared string table file name xl/SharedStrings.xml to make library compatibility with 1C software, relate issue [#188]
• Fix checkCellInArea() index out of range when the merged cell reference is single coordinate, relate issue [#206]
• Fix set font-family doesn't work, relate issue [#222]

Performance

• Make SetCellStyle() quicker by skipping conversions in checkCellInArea(), and skipping area checks when we are sure the cell can't be before or past the current row/col
• Save bytes on memory instead of string, 11% memory savings, see Performance Figures