summaryrefslogtreecommitdiff
path: root/rows.go
Commit message (Collapse)AuthorAge
* Compatibility improvementxuri2019-09-24
|
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* Handle multi row inline stringsHarris2019-08-09
| | | | | | | | | The inline string struct is actually the same as the shared strings struct, reuse it. Note that Go version 1.10 is required. Fixes #462
* Further improve read performanceHarris2019-08-07
| | | | | | | | | | | | | Instead of re-encoding the full sheet to change the namespaces in the encoded bytes, read the sheet again and do the byte replacements there. In this case, file access ends up being more performant than marshaling the sheet back to XML. In the SharedStrings test, ensure the strings are actually read. Fix #439
* Only parse xml once when readingHarris2019-08-05
| | | | | | | | | | We were parsing the whole sheet twice since the sheet reader already reads in all the rows. getTotalRowsCols function is unused after these changes so it has been deleted as well. Closes #439
* Optimize code, fix golint issuesxuri2019-06-20
|
* Fix #424, refactor merged cells adjusterxuri2019-06-12
|
* Fixed #418, #420, #421, init adjust calculation chain supportxuri2019-06-08
| | | | Update testing case
* 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
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 01:27:11 +0000