Excelize

We are pleased to announce the release of version 1.4.1. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the [Release Notes](https://github.com/xuri/excelize/releases/tag/v1.4.1). A full list of changes is available in the [change log](https://github.com/xuri/excelize/compare/v1.4.0...v1.4.1).

Release Notes
------------
The most notable changes in this release are:

Notable Features

* New function [`WriteTo()`](https://pkg.go.dev/github.com/xuri/excelize#File.WriteTo) has been added, it implements io.WriterTo to write the file
* New function [`SearchSheet()`](https://pkg.go.dev/github.com/xuri/excelize#File.SearchSheet) has been added to get coordinates by given worksheet name, cell value, and regular expression. Relate issue 277
* New functions [`ProtectSheet()`](https://pkg.go.dev/github.com/xuri/excelize#File.ProtectSheet) and [`UnprotectSheet()`](https://pkg.go.dev/github.com/xuri/excelize#File.UnprotectSheet) has been added to prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, relate issue 273
* New functions [`GetMergeCells()`](https://pkg.go.dev/github.com/xuri/excelize#File.GetMergeCells) has been added, support to get all merged cells from a worksheet currently
* Add support to flip outline summaries, relate issue 304
* Support `go module`
* Support set and get TopLeftCell properties of sheet view options, relate issue 310
* The function [`AddChart()`](https://pkg.go.dev/github.com/xuri/excelize#File.AddChart) now support to create 2D / 3D area, stacked area, 100% stacked area charts, relate issue 311

Bug Fixes

* Fix the issue caused by missing tradition to strict conversion for `sharedStringsReader()`, resolve issue 276
* Fix unknown option in chart format JSON struct tag
* Fix nil pointer dereference when getting cell formula in some case, resolve issue 290
* Make the function [`GetRows()`](https://pkg.go.dev/github.com/xuri/excelize#File.GetRows) return value avoid empty rows in the tail of the worksheet, resolve issue 195
* Fix [`GetSheetMap()`](https://pkg.go.dev/github.com/xuri/excelize#File.GetSheetMap) failed in some case, resolve issue 297
* Fix delete worksheet index error in some case, resolve issue 308

Miscellaneous

* Tests refactoring, resolve issue 322
* Add a new logo for excelize, numerous documentation updates

We are pleased to announce the release of 1.4.0.

Release Notes
------------
The most notable changes in this release are:

Breaking Change

* Add error return value for functions: `AddChart()`, `AddComment()`, `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()`

Notable Features

* New function [`GetComments()`](https://pkg.go.dev/github.com/xuri/excelize#File.GetComments) has been added for support retrieves all comments and returns a map of worksheet name to the worksheet comments
* New functions [`RGBToHSL()`](https://pkg.go.dev/github.com/xuri/excelize#RGBToHSL) and [`HSLToRGB()`](https://pkg.go.dev/github.com/xuri/excelize#HSLToRGB) has been added for support convert RGBA, HSL color
* New function [`NewDataValidation()`](https://pkg.go.dev/github.com/xuri/excelize#NewDataValidation) and series functions [`DataValidation.SetDropList()`](https://pkg.go.dev/github.com/xuri/excelize#DataValidation.SetDropList), [`DataValidation.SetError()`](https://pkg.go.dev/github.com/xuri/excelize#DataValidation.SetError), [`DataValidation.SetInput()`](https://pkg.go.dev/github.com/xuri/excelize#DataValidation.SetInput), [`DataValidation.SetRange()`](https://pkg.go.dev/github.com/xuri/excelize#DataValidation.SetRange), [`DataValidation.SetSqref()`](https://pkg.go.dev/github.com/xuri/excelize#DataValidation.SetSqref) and [`DataValidation.SetSqrefDropList()`](https://pkg.go.dev/github.com/xuri/excelize#DataValidation.SetSqrefDropList) has been added for suppport data validation
* New function [`AddPictureFromBytes()`](https://pkg.go.dev/github.com/xuri/excelize#File.AddPictureFromBytes) has been added, relate issue 259
* Function `GetCellFormula()` now supports shared formula types, relate issue 227
* Support to parse dates further in future
* Use min/mid/max value for 2 and 3 color scale conditional formatting

Bug Fixes

* Improved commenting formatting, fix expands all comment boxes stacked all in one place
* Fix create worksheet by `NewSheet()` cause file issue, related issue 249

Performance

* Performance optimization 20% faster, 14% memory savings on set cell values. See [Performance Figures](https://github.com/xuri/excelize/wiki#performance-figures)
* Use [github.com/mohae/deepcopy](github.com/mohae/deepcopy) to deep copy worksheets instead of the internal `deepcopy` function that was using [encoding/gob](https://blog.golang.org/gobs-of-data) serialization and deserialization

We are pleased to announce the release of 1.3.0.

Release Notes
------------
The most notable changes in this release are:

Breaking Change

* 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()`](https://pkg.go.dev/github.com/xuri/excelize#File.GetColOutlineLevel), [`GetRowOutlineLevel()`](https://pkg.go.dev/github.com/xuri/excelize#File.GetRowOutlineLevel), [`SetColOutlineLevel()`](https://pkg.go.dev/github.com/xuri/excelize#File.SetColOutlineLevel) and [`SetRowOutlineLevel()`](https://pkg.go.dev/github.com/xuri/excelize#File.SetRowOutlineLevel) has been added for suppport creat group
* Add iterator method for [`Rows`](https://pkg.go.dev/github.com/xuri/excelize#Rows), new functions [`Columns()`](https://pkg.go.dev/github.com/xuri/excelize#Rows.Columns), [`Next()`](https://pkg.go.dev/github.com/xuri/excelize#Rows.Next) and [`Error()`](https://pkg.go.dev/github.com/xuri/excelize#Rows.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](https://github.com/xuri/excelize/wiki#performance-figures)

We are pleased to announce the release of 1.2.0.

Release Notes
------------
The most notable changes in this release are:

* Performance optimization
* Improvement Golang 1.9 compatibility
* Stacked bar chart supported
* 24-hour time format supported
* API changed, use worksheet name instead of "sheet" + index
* Rename import path to `github.com/360EntSecGroup-Skylar/excelize`
* Add new functions `SetSheetViewOptions` and `GetSheetViewOptions`

We are pleased to announce the release of v1.1.0.

Release Notes
------------
The most notable changes in this release are:

* Feature: Conditional format support
* Count and trim sheet name in UTF-8
* Bugfix: deep copy issue with function `CopySheet()`

We are pleased to announce the release of version 0.0.3. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the [Release Notes](https://github.com/xuri/excelize-py/releases/tag/v0.0.3).

Release Notes

The most notable changes in this release are:

Notable Features

There are 99 normal mode functions available in this version

- add_chart
- add_chart_sheet
- add_comment
- add_form_control
- add_picture
- add_picture_from_bytes
- add_pivot_table
- add_shape
- add_slicer
- add_sparkline
- add_table
- add_vba_project
- auto_filter
- calc_cell_value
- close
- copy_sheet
- delete_chart
- delete_comment
- delete_defined_name
- delete_picture
- delete_sheet
- delete_slicer
- duplicate_row
- duplicate_row_to
- get_active_sheet_index
- get_app_props
- get_cell_formula
- get_cell_hyperlink
- get_cell_rich_text
- get_cell_style
- get_cell_value
- get_col_outline_level
- get_col_style
- get_col_visible
- get_default_font
- get_row_visible
- get_rows
- get_sheet_dimension
- get_sheet_index
- get_sheet_name
- get_style
- get_tables
- get_workbook_props
- group_sheets
- insert_cols
- insert_page_break
- insert_rows
- merge_cell
- move_sheet
- new_conditional_style
- new_sheet
- new_stream_writer
- new_style
- protect_sheet
- protect_workbook
- remove_col
- remove_page_break
- remove_row
- save
- save_as
- search_sheet
- set_active_sheet
- set_cell_bool
- set_cell_formula
- set_cell_hyperlink
- set_cell_int
- set_cell_rich_text
- set_cell_str
- set_cell_style
- set_cell_value
- set_col_outline_level
- set_col_style
- set_col_visible
- set_col_width
- set_conditional_format
- set_default_font
- set_defined_name
- set_doc_props
- set_header_footer
- set_page_layout
- set_page_margins
- set_panes
- set_row_height
- set_row_outline
- set_row_style
- set_row_visible
- set_sheet_background
- set_sheet_background_from_bytes
- set_sheet_col
- set_sheet_dimension
- set_sheet_name
- set_sheet_props
- set_sheet_row
- set_sheet_view
- set_sheet_visible
- set_workbook_props
- ungroup_sheets
- unmerge_cell
- update_linked_value

7 utility functions
- cell_name_to_coordinates
- column_name_to_number
- column_number_to_name
- coordinates_to_cell_name
- new_file
- open_file
- open_reader

7 streaming mode functions

- add_table
- flush
- insert_page_break
- merge_cell
- set_col_width
- set_panes
- set_row