summaryrefslogtreecommitdiff
path: root/lib.go
Commit message (Collapse)AuthorAge
* Fixed #819, read empty after streaming data writingxuri2021-04-08
| | | | #65 fn: IMAGINARY, IMARGUMENT, IMCONJUGATE and IMDIV
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* This improves compatibility for absolute XML path, Windows-style directory ↵xuri2021-02-27
| | | | separator and inline namespace;
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* This closes #774, closes #775 and closes #776xuri2021-02-02
| | | | | | | | - correct adjust calculation chain in duplicate rows - correct adjust defined name in the workbook when delete worksheet - use absolute reference in the auto filters defined name to make it compatible with OpenOffice - API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format - Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`
* new formula fn: IF, LEN; not equal operator support and faster numeric ↵xuri2021-01-27
| | | | precision process
* Compatibility improvement: parse document core part (workbook) dynamicallyxuri2020-11-04
|
* optimize memory allocation (#722)Ted2020-11-03
| | | | | | | | | | | | | | | * optimize marshal * optimize mem alloc * add benchmark testing * add NewSheetWithRowNum testing * sync struct fields order * add BenchmarkNewSheetWithStreamWriter * delete NewSheetWithRowNum and benchmark test
* Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 ↵xuri2020-08-15
| | | | potential race condition
* This closes #677 and closes #679, fix panic when enabling compiler inline flagsxuri2020-08-06
|
* improvement compatibility for the XML ignorable namespacexuri2020-07-20
|
* Update test for addTablexuri2020-07-19
|
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|
* support case-sensitive doc parts to improve compatibilityxuri2020-07-09
|
* Update docs and typo fixedxuri2020-06-22
|
* make columns iterator read cell streamingly and add max column limit on ↵xuri2020-06-22
| | | | ColumnNumberToName
* add limits for total columns, row and filename lengthxuri2020-05-29
|
* add test for ReadZipReader, close #642xuri2020-05-23
|
* Improved error handling and stoped the crash due to fatel error (#593) close ↵sachin-puranik2020-05-23
| | | | #624
* - transform the range to the matrix on the first arg of the formulaxuri2020-05-21
| | | | | - typo fix - reset cell with and height when insert picture into merged cell with autofit
* init formula calculation engine, ref #65 and #599xuri2020-05-03
|
* Performance improvementsxuri2020-04-05
|
* Improve code coverage unit testsxuri2019-12-29
|
* Improve compatibility, fix workbook's rels ID calc errorxuri2019-12-23
|
* 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
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 01:27:44 +0000