« Changelog History


excelize v1.3.0 Release Notes

Release Date: 2018-05-13 // almost 6 years ago

  • 🚀 We are pleased to announce the release of 1.3.0.

    🚀 Release Notes

    🚀 The most notable changes in this release are:

    🐎 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

    🔋 Feature

    • 🆕 New function SetSheetRow() has been added for support write 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 an 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;

    🛠 Bugfix

    • 🛠 Fix DeleteSheet() make broken file caused by activeTab tag calculation wrong, relate issue #165
    • 🛠 Fix read columns count wrong in specific xlsx data, relate issue #175
    • 🖐 Handle special shared string table file name xl/SharedStrings.xml to make lib compatibility with 1C software, relate issue #188
    • 🛠 Fix checkCellInArea() index out of range when merged cell ref is single coordinate, relate issue #206
    • 🛠 Fix set font family not works, relate issue #222

    API Changed

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