summaryrefslogtreecommitdiff
path: root/rows.go
Commit message (Collapse)AuthorAge
* extend cell value load to support custom datetime format (#703)Artem Kustikov2020-10-04
| | | | | | | | | | | | | | | | | | | | | | | | | * extend cell value load to support custom datetime format * cleanup incorrect imports * fix numeric values conversion as done in legacy Excel * fix tests coverage * revert temporary package name fix * remove personal info from test XLSX files * remove unused dependencies * update format conversion in parseTime * new UT to increase code coverage * Resolve code review issue for PR #703 * Rename broken file name generated by unit test Co-authored-by: xuri <xuri.me@gmail.com>
* add checking and limits for the worksheetxuri2020-09-18
|
* Default row height compatibility with Apache OpenOffice and Kingsoft WPS, ↵xuri2020-08-22
| | | | unit test update and typo fixed
* Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 ↵xuri2020-08-15
| | | | potential race condition
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|
* Resolve #667, support shared string table without unique countxuri2020-07-15
|
* support case-sensitive doc parts to improve compatibilityxuri2020-07-09
|
* Resolve #32, fix missing leading/leading spaces when working with SSTxuri2020-07-01
|
* GetCols support the row element without r attribute in the worksheetxuri2020-06-28
|
* support the row element without r attribute in the worksheetxuri2020-06-27
|
* Update docs and typo fixedxuri2020-06-22
|
* make columns iterator read cell streamingly and add max column limit on ↵xuri2020-06-22
| | | | ColumnNumberToName
* speedup get cell value from shared string tablexuri2020-05-27
|
* Fix #622, storage string to SST (shared string table)xuri2020-05-26
|
* Merge pull request #410xuri2020-05-17
|
* handle the cell without r attribute in a row elementxuri2020-04-24
|
* Performance improvementsxuri2020-04-05
|
* fix reading wrong string from xml such as belowfoxmeder2020-04-02
| | | | <sheetData><row r="1"><c r="A1" s="1" t="s"><v>0</v></c><c r="B1" s="1" t="s"></c></row></sheetData>
* remove ineffectual variable assignments and simplify codexuri2020-03-29
|
* Update rows.goxxb-at-julichina2020-02-28
|
* Fix #586, duplicate row with merged cellsxuri2020-02-25
|
* Resolve #580, revert commit ↵xuri2020-02-19
| | | | https://github.com/360EntSecGroup-Skylar/excelize/commit/5ca7231ed408ac264f509ff52b5d28ff4fbda757
* optimize code and comments: use println errors instead of panicxuri2020-01-03
|
* Fix #551, handle empty rows in streaming readingxuri2019-12-31
|
* Improve code coverage unit testsxuri2019-12-29
|
* Update comments for the xmlNewDecoder (#542)match-meng2019-12-20
|
* Resolve #539 Merge branch 'v2'xuri2019-12-20
|\ | | | | | | | | | | # Conflicts: # rows.go # sheet.go
| * Fix #539 Fixed error opening excel file created in encoding d… (#540)Alex Geer2019-12-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Fixed issue #539 Fixed error opening excel file created in encoding different from UTF-8, added logging of possible errors when decoding XML if the function does not provide exit with an error * Added test for CharsetReader * Fixed #discussion_r359397878 Discussion: https://github.com/360EntSecGroup-Skylar/excelize/pull/540#discussion_r359397878 * Fixed go fmt * go mod tidy and removed unused imports * The code has been refactored
* | Fix #529, handle empty inline rich textxuri2019-12-11
| |
* | Resolve #146, make the GetRow function read data as streaming. Ref: #382, #515xuri2019-11-23
| |
* | fix #503 rows next issueducquangkstn2019-10-18
|/
* 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