Excelize v1.3.0
- Released this on: May 13, 2018
- GitHub Release: https://github.com/xuri/excelize/releases/tag/v1.3.0
Release Notes
The most notable changes in this release are:
Breaking Change
- Make row index consistent in function
SetRowHeight
andGetRowHeight
, fix issue #205
Notable Features
- New function
SetSheetRow
has been added for support write the whole line at once, related issue #96 and #194 - New functions
GetColOutlineLevel
,GetRowOutlineLevel
,SetColOutlineLevel
andSetRowOutlineLevel
has been added for support create group - Add iterator method for
Rows
, new functionsColumns
,Next
andError
has been added - Function
SetCellValue
now supportsbool
andtime.Duration
type value - Function
AddTable
now supports set name of table, related issue #216 - Function
AddPicture
now supports set the positioning of a picture, related issue #214 - Function
GetCellValue
now supports readinlineStr
type cell value, related 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, related issue #160 and #190
- Add a hyperlink to image support for the function
AddPicture
, related issue #185 - Add protection properties associated with the cell support, related issue #191
- Add categories or values on reverse order (orientation of the chart) support, and set auto or fixed maximum, minimum of the axis, related issue #202
Bug Fixes
- Fix
DeleteSheet
make broken file caused byactiveTab
tag calculation wrong, related issue #165 - Fix read columns count wrong in specific worksheet data, related issue #175
- Handle special shared string table file name
xl/SharedStrings.xml
to make library compatibility with 1C software, related issue #188 - Fix
checkCellInArea
index out of range when the merged cell reference is single coordinate, related issue #206 - Fix set font-family doesn't work, related issue #222
Performance
- Make
SetCellStyle
quicker by skipping conversions incheckCellInArea
, 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