summaryrefslogtreecommitdiff
path: root/excelize.go
Commit message (Collapse)AuthorAge
* godoc update and typo fixedxuri2019-04-20
|
* add unit tests to functionsxuri2019-04-16
|
* Resolve #369,#370xuri2019-04-15
| | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
* refactor: handler error instead of panic,xuri2019-03-23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Exported functions: SetCellStyle InsertCol RemoveCol RemoveRow InsertRow DuplicateRow DuplicateRowTo SetRowHeight GetRowHeight GetCellValue GetCellFormula GetCellHyperLink SetCellHyperLink SetCellInt SetCellBool SetCellFloat SetCellStr SetCellDefault GetCellStyle SetCellValue MergeCell SetSheetRow SetRowVisible GetRowVisible SetRowOutlineLevel GetRowOutlineLevel GetRows Columns SearchSheet AddTable GetPicture AutoFilter GetColVisible SetColVisible GetColOutlineLevel SetColOutlineLevel SetColWidth GetColWidth inner functions: adjustHelper adjustMergeCells adjustAutoFilter prepareCell setDefaultTimeStyle timeToExcelTime addDrawingChart addDrawingVML addDrawingPicture getTotalRowsCols checkRow addDrawingShape addTable
* Huge refactorig for consistent col/row numbering (#356)Veniamin Albaev2019-03-20
| | | | | | | | | | | | | | | | | | | * Huge refactorig for consistent col/row numbering Started from simply changing ToALphaString()/TitleToNumber() logic and related fixes. But have to go deeper, do fixes, after do related fixes and again and again. Major improvements: 1. Tests made stronger again (But still be weak). 2. "Empty" returns for incorrect input replaces with panic. 3. Check for correct col/row/cell naming & addressing by default. 4. Removed huge amount of duplicated code. 5. Removed ToALphaString(), TitleToNumber() and it helpers functions at all, and replaced with SplitCellName(), JoinCellName(), ColumnNameToNumber(), ColumnNumberToName(), CellNameToCoordinates(), CoordinatesToCellName(). 6. Minor fixes for internal variable naming for code readability (ex. col, row for input params, colIdx, rowIdx for slice indexes etc). * Formatting fixes
* Resolve #106, #294 performance optimization for add hyperlinkxuri2019-02-26
|
* Resolve #274, performance optimization for add images, charts and shapesxuri2019-02-25
|
* Resolve #235, performance optimization for add comments (#347)BluesJhao2019-02-25
|
* resolve the issue corrupted xlsx after deleting formula of cell, reference #346xuri2019-02-22
|
* New feature: File.DuplicateRowTo() duplicate row to specified row position.Veniamin Albaev2019-01-10
| | | | | | | | DuplicateRowTo() is similar to DuplicateRow() but copies specified row not just after specified source row but to any other specified position below or above source row. Also I made minor modifications of tests: using filepath.Join() instead of direct unix-way paths strings to avoid possible tests fails on other OS.
* Resolve #318, add new functions andzhangleijlu2019-01-06
|
* README updatedxuri2019-01-01
|
* New feature: the function `SearchSheet` now support regular expression, ↵xuri2018-12-26
| | | | relate pull request #316
* Duplicate row (#317)Veniamin Albaev2018-12-26
| | | | | | * go mod tidy applied * File.DuplicateRow() method added
* Merge pull request #313 from sairoutine/feature/get_merge_cellsxuri2018-12-19
|\ | | | | Add GetMergeCells
| * Add GetMergeCellssairoutine2018-12-19
| |
* | Add new logo for excelizexuri2018-12-05
| |
* | resolve #276, add OfficeOpenXML-XMLSchema-Strict mode supportxuri2018-10-17
| |
* | Comments style changed.xuri2018-09-14
| |
* | Comments style changed.xuri2018-09-14
| |
* | Comments style changed.xuri2018-09-14
| |
* | Fix golint errors under confidence 0.1xuri2018-09-12
|/
* Fixes #256 and format document.xuri2018-08-06
|
* - Initialize theme support;xuri2018-07-07
| | | | | - RGBA, HSL color convert has been added; - go test updated
* - Add error return value for functions: `AddChart()`, `AddComment()`, ↵xuri2018-05-27
| | | | | | `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` - go test has been updated
* - Bugfix: set font family not works, relate issue #222;xuri2018-05-08
| | | | | - Remove useless function `replaceWorkSheetsRelationshipsNameSpace()`; - Make test cases use strict error checking
* save bytes on memory instead of stringLunny Xiao2018-05-07
|
* - Function `SetCellValue()` time.Duration support added, relate issue #176;Ri Xu2018-01-05
| | | | - go test updated
* Bugfix: corrupted xlsx after write operation, relate issue #152.Ri Xu2017-11-16
| | | | Signed-off-by: Ri Xu <xuri.me@gmail.com>
* Merge pull request #141 from WingGao/wingxuri2017-11-03
|\ | | | | fix OpenReader no sheet error
| * fix OpenReader no sheet errorWing Gao2017-10-27
| |
* | - Bugfix: use sheet name in func `AddPicture`, relate issue #142;Ri Xu2017-10-31
|/ | | | - godoc updated
* Bugfix: read sheet name error, relate issue #137Ri Xu2017-10-18
| | | | Signed-off-by: Ri Xu <xuri.me@gmail.com>
* Performance optimization, use the array index instead of the value in range.Ri Xu2017-10-16
|
* Improve code readability.Ri Xu2017-09-30
|
* - API changed, use worksheet name instead of "sheet" + index, related issue ↵Ri Xu2017-09-13
| | | | | | #25, #43, #47, #51, #89, #101, #116 and #120. - go test updated
* - Init insert/remove column/row support. Relate issue #77 and #82;Ri Xu2017-07-24
| | | | - Readme and go test updated
* Bugfix: unable to read the value of the merged cell, relate issue #78Ri Xu2017-07-05
|
* - New function `NewStyle()` added and function `SetCellStyle()` has been ↵Ri Xu2017-06-29
| | | | | | exported, relate issue #72; - go test and go doc updated
* Function `GetCellValue()` performance improvement by avoid repeating ↵Ri Xu2017-06-29
| | | | deserialization, relate issue #70.
* - Make function `TitleToNumber()` exportable, note that function ↵Ri Xu2017-06-27
| | | | | | `ToAlphaString()` return value calculation changes, get more info from go doc. Relate issue #63; - Readme and go doc updated
* - Function `formattedValue()` performance improvement by avoid repeating ↵Ri Xu2017-06-26
| | | | | | deserialization, relate issue #64; - Make function `ToAlphaString()` exportable, relate issue #63
* - Handle pre-defined number format set of cell when set cell value with ↵Ri Xu2017-06-23
| | | | | | `time.Time` data type, related issue #62; - go doc updated
* - Fixed coordinate parse error in function `SetCellStyle()`, relate issue #60;Ri Xu2017-06-12
| | | | - Simplified code
* Priority cell style, when the cell and the column at the same time with the ↵Ri Xu2017-05-30
| | | | style attribute. Relate issue #54 and #56.
* Set cell support column style predefined detection, relate issue #54.Ri Xu2017-05-26
|
* Code optimize.Ri Xu2017-05-24
|
* - Formatted cell data support, fix issue #48;Ri Xu2017-05-05
| | | | | - Function `SetCellValue()` support `time.Time` data type parameter, relate issue #49; - go doc and go test updated
* - Fix SheetCount count error;Ri Xu2017-04-01
| | | | | - Optimize deserialization operations; - README updated, add go version required notice
* Performance enhancements, remove redundant XML element checking logic. ↵Ri Xu2017-03-31
| | | | Relate issue #29. The benchmark report of the current version of this library is shown on the wiki page.