summaryrefslogtreecommitdiff
path: root/lib.go
Commit message (Collapse)AuthorAge
* Pre-allocate some memory when reading files (#510)Michael2019-10-24
|
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* godoc update and typo fixedxuri2019-04-20
|
* 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
* 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
* Faster TitleToNumber (#343)Olivier Mengué2019-02-02
| | | | | | | | | | | | * TestTitleToNumber: more test cases * TitleToNumber: drop use of math.Pow() Compute using pure integers * TitleToNumber: simplify Remove unecessary casts to int
* README updatedxuri2019-01-01
|
* resolve #273 new feature: protect sheet supportHcySunYang2018-11-02
| | | new feature: protect sheet support, relate issue #273
* resolve #276, add OfficeOpenXML-XMLSchema-Strict mode supportxuri2018-10-17
|
* 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
|
* GoDoc updated.xuri2018-07-13
|
* 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 ```
* - Add error return value for functions: `AddChart()`, `AddComment()`, ↵xuri2018-05-27
| | | | | | `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` - go test has been updated
* save bytes on memory instead of stringLunny Xiao2018-05-07
|
* make SetCellStyle quicker by skipping conversions in checkCellInArea, and ↵mbresson2018-01-19
| | | | | | skipping area checks when we are sure the cell can't be before or past the current row/col Signed-off-by: Matthieu Bresson
* Add SetSheetViewOptions and GetSheetViewOptions (#145)Olivier Mengué2017-11-16
| | | | | | | | | | | | | | | | | | | | | | Two new methods: - SetSheetViewOptions(sheetName string, viewIndex int, opts ...SheetViewOption) error - GetSheetViewOptions(sheetName string, viewIndex int, opts ...SheetViewOptionPtr) error The option values are given by the user through types that have privates methods that implement the private SheetViewOption and SheetViewOptionPtr interfaces: - DefaultGridColor(bool) - RightToLeft(bool) - ShowFormulas(bool) - ShowGridLines(bool) - ShowRowColHeaders(bool) Examples: err := xl.SetSheetViewOptions("Sheet1", -1, excelize.ShowGridLines(true)) var showGridLines excelize.ShowGridLines err := xl.GetSheetViewOptions("Sheet1", -1, &showGridLines) Fixes #145.
* Optimize code.Ri Xu2017-09-06
|
* Update lib.golichaofei2017-09-05
|
* Update lib.golichaofei2017-09-05
|
* Bugfix: deep copy issue with function `CopySheet()`, relate PR #108.Ri Xu2017-08-19
|
* - 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
* - Function `formattedValue()` performance improvement by avoid repeating ↵Ri Xu2017-06-26
| | | | | | deserialization, relate issue #64; - Make function `ToAlphaString()` exportable, relate issue #63
* - New feature: border setting support (Related issue #21);Ri Xu2017-03-06
| | | | | | - Function parameter code is simplified; - Fix element `Tint` value parsing error in worksheet; - Update go test
* Standardize input and outputJosh Fyne2017-02-16
|
* - Improved performance when reading large files, call Token to read tokens ↵Ri Xu2017-02-12
| | | | | | | one by one instead Unmarshal. Related issue #20 ; - Fix go test typo; - Update README
* Support set work sheet background image.Ri Xu2017-01-24
|
* Fix issue #17, update README and fix typo.Ri Xu2017-01-23
|
* Format commants, break comments after 80 characters.Ri Xu2017-01-18
|
* - New function `SetSheetName` and `SetColWidth` added, support rename sheet ↵Ri Xu2017-01-18
| | | | | | | and set column width; - Add escape characters of sheet name; - Update go test and fix typo
* - Performance improvement, remove `replaceRelationshipsID` and ↵Ri Xu2016-12-31
| | | | | | `workBookCompatibility` functions; - New functions `GetActiveSheetIndex`, `GetSheetName` and `GetSheetMap` added.
* - Fix issue: sheet protection and conditional formatting proprietary missing ↵Ri Xu2016-12-26
| | | | | | after save; - Update workbook and sheet relationships and self-close tag replacement hack functions
* Update godoc of package.Ri Xu2016-10-19
|
* Use conjunction with strings.Map to split Axis and update godoc.Ri Xu2016-09-12
|
* Move execute checkRow logic when XLSX file open, speed up library write file.Ri Xu2016-09-07
|
* Open file error return added and UpdateLinkedValue function added to fix ↵Ri Xu2016-09-06
| | | | linked values within a spreadsheet are not updating.
* Fix issue #2 change project to object-oriented style and update readme file.Ri Xu2016-09-05
|
* Fix issue #4 use builtin `map` instead of home-built.Ri Xu2016-09-05
|
* Format code with golint rulesRi Xu2016-09-02
|
* 1) Update readme file credits and go report badge added; 2) Remove use less ↵Ri Xu2016-08-31
| | | | function; 3) Update test file.
* Init commit.Ri Xu2016-08-30