summaryrefslogtreecommitdiff
path: root/rows.go
Commit message (Collapse)AuthorAge
* godoc update and typo fixedxuri2019-04-20
|
* Resolve #382, rewrite prepareSheetXML to scale linearly (#383)Michael2019-04-16
| | | | | | | | | | | | | | * Rewrite prepareSheetXML to scale linearly We don't need to backfill columns into every row for most purposes Provided makeContiguousColumns for setting styles where we do need it for a specific region. Added a benchmark to monitor progress. For 50,000 rows this went from about 11 seconds to 1 second. The improvements are more dramatic as the row/column count increases. * Assigning that row value was redundant
* Resolve #369,#370xuri2019-04-15
| | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
* Resolve #377, avoid empty column in GetRows resultxuri2019-04-07
|
* 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
* Fixed PR #356 regression RemoveCol() broken (#365)Veniamin Albaev2019-03-21
|
* Typo fixed and godoc updatedxuri2019-03-20
|
* 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
* update go test and function docscaozhiyi2019-03-07
|
* update README and functions docs (#351)Kimxu2019-03-07
| | | | | | * update README and functions docs * update README and functions docs
* Implement consistent row addressing by Excel row number starting with 1 (#350)Veniamin Albaev2019-03-06
| | | | | | | | | | | | | | | * Implement consistent row addressing by Excel row number starting with 1 1. Added second versions for all row manipulation methods with zero-based row addressing. 2. Fixed methods documentation to explicitly describe which row addressing used in method. 3. Added WARNING to README.md. 4. Cosmetic change: All row test moved to file `rows_test.go`. * TravisCI: go1.12 added to tests matrix * BACKWARD INCOMPARTIBLE: Use only Excel numbering logic from 1 row * README updated
* 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.
* Fixes #195: Make GetRows return value avoid empty cellRafael Barros2019-01-01
| | | | | | | | * #195: proposed resolution to the issue * Make GetRows return value avoid empty cell * Update test file to fix broken testing.
* README updatedxuri2019-01-01
|
* Duplicate row (#317)Veniamin Albaev2018-12-26
| | | | | | * go mod tidy applied * File.DuplicateRow() method added
* Fix the issue caused by missing tradition to strict conversion for ↵xuri2018-10-18
| | | | `sharedStringsReader()`, relate issue #276
* 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
|
* - Add error return value for functions: `AddChart()`, `AddComment()`, ↵xuri2018-05-27
| | | | | | `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` - go test has been updated
* Simplify testing code, add test case for outline functions and update the godoc.xuri2018-05-11
|
* Added functions to set and get outline level for columns and rows.Ilya Kuznetsov2018-05-07
|
* Merge branch 'master' into lunny/refactorxuri2018-05-07
|\
| * Merge test cases and use strict error checking.Ri Xu2018-05-07
| |
* | save bytes on memory instead of stringLunny Xiao2018-05-07
|/
* add iterator method for rowsLunny Xiao2018-05-05
|
* Fix typo and adding Chinese version document.Ri Xu2018-04-23
|
* - Support to read inlineStr type cell value, relate issue #208, PR #209;Ri Xu2018-04-09
| | | | - go test and godoc has been updated
* - Make row index consistent in function `SetRowHeight` and `GetRowHeight`, ↵Ri Xu2018-04-02
| | | | | | fix issue #205; - go test and godoc has been updated
* Handle special shared string table file name `xl/SharedStrings.xml`, relate ↵Ri Xu2018-03-02
| | | | issue #188
* Fix read columns count wrong in specific xlsx data, relate issue #175Ri Xu2018-01-06
|
* Bugfix: use sheet name in func `AddChat`, relate issue #138Ri Xu2017-10-20
| | | | Signed-off-by: Ri Xu <xuri.me@gmail.com>
* 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
* Function `GetCellValue()` performance improvement by avoid repeating ↵Ri Xu2017-06-29
| | | | deserialization, relate issue #70.
* - Unify the index row number index of functions `SetRowHeight()` and ↵Ri Xu2017-06-29
| | | | | | | `GetRowHeight()` relate issue #68; - Unify the return value data type of functions `SetColWidth()` and `GetColWidth()`; - go test updated
* API changed, use `NewFile()` instead of `CreateFile()` and use `SaveAs()` ↵Ri Xu2017-06-28
| | | | instead of `WriteTo()`.
* - 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
* - New functions: `GetSheetVisible()` and `GetRowVisible()` added, relate ↵Ri Xu2017-06-14
| | | | | | issue #61; - go test updated
* Init auto filter support, relate issue #59.Ri Xu2017-06-08
|
* - 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
* - Font bold, italic and underline style support. Relate issue #45;Ri Xu2017-04-25
| | | | | - Function `GetRows()` doc updated, relate issue #43; - go test and embed template updated
* - Initialize char support, relate issue #31;Ri Xu2017-04-23
| | | | | | | | - Doc for function `GetRows()` updated, relate issue #43; - Fix doc typo in `xmlContentTypes.go`; - Default template updated; - Readme updated; - go test updated
* Performance improvementRi Xu2017-03-12
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 17:42:24 +0000