summaryrefslogtreecommitdiff
path: root/sheet.go
Commit message (Collapse)AuthorAge
* 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
|
* resolve #297, fix GetSheetMap() failedtaomin5977153792018-11-24
| | | | Change-Id: I585a4a017867b89bd39cb6e711467a46eaa757be
* New function `UnprotectSheet()` has been addedq5235912018-11-04
|
* resolve #273 new feature: protect sheet supportHcySunYang2018-11-02
| | | new feature: protect sheet support, relate issue #273
* New function: `SearchSheet()`, relate issue #277peng2018-10-27
|
* resolve #276, add OfficeOpenXML-XMLSchema-Strict mode supportxuri2018-10-17
|
* Merge branch 'master' into masterxuri2018-09-27
|\
| * Comments style changed.xuri2018-09-14
| |
| * Comments style changed.xuri2018-09-14
| |
| * Comments style changed.xuri2018-09-14
| |
| * New function `AddPictureFromBytes()` has been added, this resolve #259 and ↵xuri2018-09-14
| | | | | | | | close #271.
| * Fix golint errors under confidence 0.1xuri2018-09-12
| |
| * Fixes #256 and format document.xuri2018-08-06
| |
| * Bugfix: create worksheet cause file issue. Relate issue #249.xuri2018-07-17
| |
| * CopySheet() using reflect instead of encoding/gobOlivier Mengué2018-06-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Use github.com/mohae/deepcopy to deep copy worksheets instead of the internal deepcopy function that was using encoding/gob serialization and deserialization. Rationale: 1/ using `encoding/gob` is much slower than [`mohae/deepcopy`](https://github.com/mohae/deepcopy/) 2/ When building an application this implementation of `deepcopy` drags the `encoding/gob` package into the binary. And this package is much bigger than `mohae/deepcopy` (which only depends on `time` and `reflect`). ``` $ LC_ALL=C stat -f "%6z %N" $(go env GOPATH)/pkg/$(go env GOOS)_$(go env GOARCH)/github.com/mohae/deepcopy.a $(go env GOROOT)/pkg/$(go env GOOS)_$(go env GOARCH)/encoding/gob.a 10508 .../pkg/darwin_amd64/github.com/mohae/deepcopy.a 541818 .../pkg/darwin_amd64/encoding/gob.a ```
* | Documentation:Sebastian Willing2018-06-11
|/ | | | | | | * Add information about return value of NewSheet() * Minor documentation language fixes Samples: * Added sample go file for dumping a XLSX file to the console
* - Add error return value for functions: `AddChart()`, `AddComment()`, ↵xuri2018-05-27
| | | | | | `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` - go test has been updated
* - Performance optimization 20% faster, 14% memory savings on set cell values;xuri2018-05-15
| | | | | - Using the canonical syntax in issue template and contributing guide; - go test has been updated
* Improve unit testing, remove redundant code.xuri2018-05-14
|
* save bytes on memory instead of stringLunny Xiao2018-05-07
|
* Fix document typo.Ri Xu2018-05-03
|
* - Support to set the positioning of a picture, relate issue #214;Ri Xu2018-04-26
| | | | - go test and godoc has been updated
* - Update the function `NewSheet()` to handle when already exists a worksheet ↵Ri Xu2018-03-16
| | | | | | of the same name, relate pull request #196; - go test and godoc has been updated
* Readme and godoc has been updated.Ri Xu2018-03-06
|
* - Fix `DeleteSheet()` make broken file, relate issue #165;Ri Xu2017-12-04
| | | | - godoc updated
* - Bugfix: use sheet name in func `AddPicture`, relate issue #142;Ri Xu2017-10-31
| | | | - godoc updated
* Bugfix: use sheet name in func `AddChat`, relate issue #138Ri Xu2017-10-20
| | | | Signed-off-by: Ri Xu <xuri.me@gmail.com>
* Improve code readability.Ri Xu2017-09-30
|
* godoc updated.Ri Xu2017-09-13
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 02:36:00 +0000