Excelize is a library written in pure Go and providing a set of functions that allow you to write to and read from XLSX files. Support reads and writes XLSX file generated by Microsoft Excelβ’ 2007 and later. Support save file without losing original charts of XLSX. This library needs Go version 1.8 or later. The full API docs can be seen using go's built-in documentation tool, or online at go.dev and docs reference.
We are pleased to announce the release of version 2.0.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 change log.
Release Notes
The most notable changes in this release are:
API Changed
The following table lists the changes to the API for v2.0.0 compared to the v1.4.1:
Function | Add error return |
Row Number Change* | Delete | New Addition |
---|---|---|---|---|
ToALphaString | Γ | Γ | β | Γ |
TitleToNumber | Γ | Γ | β | Γ |
SplitCellName | Γ | Γ | Γ | β |
JoinCellName | Γ | Γ | Γ | β |
ColumnNameToNumber | Γ | Γ | Γ | β |
ColumnNumberToName | Γ | Γ | Γ | β |
CellNameToCoordinates | Γ | Γ | Γ | β |
CoordinatesToCellName | Γ | Γ | Γ | β |
SetCellFloat | Γ | Γ | Γ | β |
SetCellStyle | β | Γ | Γ | Γ |
InsertCol | β | Γ | Γ | Γ |
RemoveCol | β | Γ | Γ | Γ |
RemoveRow | β | β | Γ | Γ |
InsertRow | β | β | Γ | Γ |
DuplicateRow | β | Γ | Γ | Γ |
DuplicateRowTo | β | Γ | Γ | Γ |
SetRowHeight | β | Γ | Γ | Γ |
GetRowHeight | β | Γ | Γ | Γ |
GetCellValue | β | Γ | Γ | Γ |
GetCellFormula | β | Γ | Γ | Γ |
GetCellHyperLink | β | Γ | Γ | Γ |
SetCellHyperLink | β | Γ | Γ | Γ |
SetCellInt | β | Γ | Γ | Γ |
SetCellBool | β | Γ | Γ | Γ |
SetCellStr | β | Γ | Γ | Γ |
SetCellDefault | β | Γ | Γ | Γ |
GetCellStyle | β | Γ | Γ | Γ |
SetCellValue | β | Γ | Γ | Γ |
MergeCell | β | Γ | Γ | Γ |
SetSheetRow | β | Γ | Γ | Γ |
SetRowVisible | β | β | Γ | Γ |
GetRowVisible | β | β | Γ | Γ |
SetRowOutlineLevel | β | β | Γ | Γ |
GetRowOutlineLevel | β | β | Γ | Γ |
GetRows | β | Γ | Γ | Γ |
Columns | β | Γ | Γ | Γ |
SearchSheet | β | Γ | Γ | Γ |
GetPicture | β | Γ | Γ | Γ |
GetColVisible | β | Γ | Γ | Γ |
SetColVisible | β | Γ | Γ | Γ |
GetColOutlineLevel | β | Γ | Γ | Γ |
SetColOutlineLevel | β | Γ | Γ | Γ |
SetColWidth | β | Γ | Γ | Γ |
GetColWidth | β | Γ | Γ | Γ |
GetMergeCells | β | Γ | Γ | Γ |
ProtectSheet | β | Γ | Γ | Γ |
UnprotectSheet | β | Γ | Γ | Γ |
UpdateLinkedValue | β | Γ | Γ | Γ |
SetSheetVisible | β | Γ | Γ | Γ |
adjustHelper | β | Γ | Γ | Γ |
adjustMergeCells | β | Γ | Γ | Γ |
adjustAutoFilter | β | Γ | Γ | Γ |
prepareCell | β | Γ | Γ | Γ |
setDefaultTimeStyle | β | Γ | Γ | Γ |
timeToExcelTime | β | Γ | Γ | Γ |
addDrawingChart | β | Γ | Γ | Γ |
addDrawingVML | β | Γ | Γ | Γ |
addDrawingPicture | β | Γ | Γ | Γ |
getTotalRowsCols | β | Γ | Γ | Γ |
checkRow | β | Γ | Γ | Γ |
addDrawingShape | β | Γ | Γ | Γ |
addTable | β | Γ | Γ | Γ |
workSheetReader | β | Γ | Γ | Γ |
copySheet | β | Γ | Γ | Γ |
* From version 2.0.0 all row manipulation methods uses Excel row numbering starting with 1
instead of zero-based numbering which take place in some methods in earlier versions, related issue #349.
Feature
- New function
DuplicateRowTo()
has been added for duplicate row to specified row position - The function
SetPageLayout()
now support to set page orientation, related issue #318 - The function
SetPageLayout()
now support to set page size
Bug Fixes
- Fix the issue that create a blank fill if no fill is specified in the style format
- Fix the issue that data validation list in the excel sheet disappears formula characters greater than
255
, related issue #339 - Fix the issue corrupted xlsx after deleting formula of cell, related issue #346
- Fix the issue that
GetComment()
returns incorrect mapping between worksheets and comments in some case, related issue #345 - Fix the issue #346, resolve the issue corrupted xlsx after deleting formula of cell
- Fix the issue #377, avoid empty column in GetRows result
Performance
- Performance optimization, faster for add comments, related issue #347, faster add images, charts and shapes, related issue #274
- Adding the same image should create a drawing referencing the already stored copy of the image, related issue #359
Miscellaneous
- Typo fixed and godoc updated
- Tests made stronger again, go1.12 added to tests matrix
Top comments (0)