summaryrefslogtreecommitdiff
path: root/sheet.go
Commit message (Collapse)AuthorAge
* optimize code and comments: use println errors instead of panicxuri2020-01-03
|
* Improve code coverage unit testsxuri2019-12-29
|
* Improve compatibility, fix workbook's rels ID calc errorxuri2019-12-23
|
* Improve code coverage unit testsxuri2019-12-22
|
* 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 #426, handle empty workbook viewxuri2019-12-16
| |
* | Update XML namespacexuri2019-11-30
| |
* | Resolve #521, fix missing elements when parsingxuri2019-11-28
| |
* | Resolve #146, make the GetRow function read data as streaming. Ref: #382, #515xuri2019-11-23
| |
* | Reduce allocations when writingHarris2019-11-05
| | | | | | | | | | | | | | | | | | | | Fix #494 If a row is full, don't bother allocating a new one, just return it. Use the last populated row as a hint for the size of new rows. Simplify checkSheet to remove row map
* | Resolve #507, add the new function `DeleteDefinedName`xuri2019-10-26
| |
* | Fix corrupted Excel file issue #413xuri2019-10-23
| |
* | Optimize code of Getting/Setting Page Marginsxuri2019-10-17
| |
* | Added accessors for Getting/Setting Page Margins (#497)streboryaj2019-10-15
|/ | | | | | * Added accessors for Getting/Setting Page Margins * Added test cases
* Combine functions:xuri2019-09-16
| | | | | | workBookRelsWriter, drawingRelsWriter into relsWriter; drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader; addDrawingRelationships, addSheetRelationships into addRels
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* Get sheet names based on indexHarris2019-08-08
| | | | | | | | SheetID only seems to indicate the file name for the sheet. Check the sheets list based on index instead. Reordering sheets in Excel changes the order they appear in that list. Fixes #457
* New feature: sparkline supportedxuri2019-08-04
|
* Merge pull request #447 from dongkai16z/masterxuri2019-07-26
|\ | | | | Fix #443
| * Fix #443董凯2019-07-25
| |
* | Fix #442Sustainedhhh2019-07-25
|/
* Resolve #432, supplement the function of SetPageLayoutxuri2019-07-06
| | | SetPageLayout support to set fit to width and height
* New feature: group and ungroup sheets supportxuri2019-07-03
| | | | New functions `GroupSheets` and `UngroupSheets` added Refactor sheet index calculation
* Update GoDoc and typo fixedxuri2019-06-30
|
* New functions: SetDefinedName and GetDefinedName addedxuri2019-06-18
|
* Fixed #418, #420, #421, init adjust calculation chain supportxuri2019-06-08
| | | | Update testing case
* Resolve #404, get sheet map by target rels.xuri2019-05-17
|
* Resolve #394, init set header and footer supportxuri2019-05-05
|
* Resolve #392, compatible with strict relations name space inspectionxuri2019-04-27
|
* 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
* 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
* Fix out of range panic when removing formula.Aplulu2019-04-09
| | | | Fix file corruption issue when deleting a sheet containing a formula.
* 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
* Add benchmark for adding images to sheet (#367)Michael2019-03-23
| | | | | | | | * Add benchmark for adding images to sheet This should help track performance regressions in future changes. * Only transform sheet name if necessary
* resolve #360, fix axis parse issue when add / get pictures;xuri2019-03-20
| | | | typo fixed and go test updated
* 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 the issue corrupted xlsx after deleting formula of cell, reference #346xuri2019-02-22
|
* The function SetPageLayout support set paper sizekkxkkxkkgh2019-01-13
|
* 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
* Add RegSearchSheet (#316)r-uchino2018-12-26
|
* Fixes #308, refactor `NewSheet()`, `DeleteSheet()`, `SetActiveSheet()` and ↵xuri2018-12-15
| | | | `GetActiveSheetIndex()`
* Fix comments according to best practices by effective goxuri2018-12-11
|
* Add new logo for excelizexuri2018-12-05
|