summaryrefslogtreecommitdiff
path: root/file.go
Commit message (Collapse)AuthorAge
* Remove internal error log print, throw XML deserialize errorxuri2022-11-13
|
* This is a breaking change, remove partial internal error log print, throw ↵xuri2022-11-12
| | | | | | | XML deserialize error - Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions - Update unit tests
* Fix the error on getting the range of merged cells on the worksheet which ↵xuri2022-10-28
| | | | | | | | contains one cell merged cell range - Parse workbook default theme for custom theme color support in the feature - Variables name typo fix - Add system foreground and background color as RGB in the IndexedColorMapping list
* This closes #1379, cleanup stream writer temporary files by the `Close` functionxuri2022-10-26
| | | | | | - Fix error on inserting columns or rows on the worksheet which contains one cell merged cell range - Fix getting incomplete rich text cell value in some cases - Unit tests updated
* Support get cell value which contains a date in the ISO 8601 formatxuri2022-10-24
| | | | | | | | - Support set and get font color with indexed color - New export variable `IndexedColorMapping` - Fix getting incorrect page margin settings when the margin is 0 - Update unit tests and comments typo fixes - ref #65, new formula functions: AGGREGATE and SUBTOTAL
* This closes #320, support custom chart axis font stylexuri2022-10-14
|
* This closes #744, the `Save`, `Write` and `WriteTo` function accept saving ↵xuri2022-09-08
| | | | options
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* Optimizing line breaks for comments (#1281)Regan Yue2022-07-17
|
* This initialized support for encryption workbook by password, ref #199xuri2022-05-29
| | | | - Remove exported variable `ErrEncrypt`
* make workbook open filed exception message clearxuri2022-05-20
| | | | | - New exported constant `ErrWorkbookPassword` - Rename exported constant `ErrWorkbookExt` to `ErrWorkbookFileFormat`
* This closes #1229, rename ErrMaxFileNameLength to ErrMaxFilePathLength (#1230)sceneq2022-05-16
| | | Co-authored-by: sceneq
* ref #65, new formula functions: T.INV and T.INV.2Txuri2022-04-04
| | | | - Typo fixed
* This improved formula calculate precision and added zero placeholder number ↵xuri2022-03-19
| | | | format support
* This closes #1148, resolve limitations when adding VBA project to the workbookxuri2022-02-17
| | | | | | | | Added two exported functions `SetWorkbookPrOptions` and `GetWorkbookPrOptions` to support setting and getting the code name property of the workbook Re-order fields of the workbook properties group to improve the compatibility Go Modules dependencies upgrade Put workbook related operating in new `workbook.go` source code Library introduction docs block updated
* Fix file corrupted in some cases, check file extension and format codexuri2022-01-23
| | | | | | Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case New exported error ErrWorkbookExt has been added, and check file extension on save the workbook Format source code with `gofumpt`
* ref #1096, reduce memory usage by about 50% for large data spreadsheetxuri2022-01-11
|
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* This closes #1096, memory usage optimization and another 4 changesxuri2021-12-27
| | | | | | | | - Unzip shared string table to system temporary file when large inner XML, reduce memory usage about 70% - Remove unnecessary exported variable `XMLHeader`, we can using `encoding/xml` package's `xml.Header` instead of it - Using constant instead of inline text for default XML path - Rename exported option field `WorksheetUnzipMemLimit` to `UnzipXMLSizeLimit` - Unit test and documentation updated
* Export 7 errors so users can act differently on different type of errorsxuri2021-12-07
|
* This closes #1075, reload temporary files into memory on savexuri2021-12-01
|
* This closes #833, closes #845, and closes #1022, breaking changesxuri2021-09-19
| | | | | | - Close spreadsheet and row's iterator required - New options `WorksheetUnzipMemLimit` have been added - Improve streaming reading performance, memory usage decrease about 93.7%
* Improve security and simplify codexuri2021-08-15
| | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message
* This closes #872, support re-save the new spreadsheet after `SaveAs`xuri2021-07-09
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #861, support concurrency get cell picture and remove unused ↵xuri2021-07-04
| | | | internal function `getSheetNameByID`
* feat: stream write to zip directly (#863)Zitao2021-06-22
|
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* Fixed #813, streaming data writer result missing after call normal APIxuri2021-04-03
| | | | #65 formula function: COMPLEX
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* Optimize memory usage when stream flush and save (#659)Lijingfeng2020-10-05
| | | | | | | | | | | | | | | | | | * use io.Copy from stream temp file to zip Writer * fix nil * log * build * delete log * fix compatibility for office * Update go module Co-authored-by: lijingfeng <lijingfeng@laiye.com> Co-authored-by: xuri <xuri.me@gmail.com>
* 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>
* Update dependency package version and docs for the OpenFilexuri2020-09-22
|
* add checking and limits for the worksheetxuri2020-09-18
|
* init ECMA-376 agile encryption supportxuri2020-09-06
|
* Update docs and typo fixedxuri2020-06-22
|
* add limits for total columns, row and filename lengthxuri2020-05-29
|
* Resolve #172, init rich text supportxuri2020-04-06
|
* Improve code coverage unit testsxuri2019-12-29
|
* 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
* 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
|
* Fix potential memory leakzaddok2019-08-09
| | | Fix potential memory leak where zw is not Close() when an error occurs.
* Resolve #369,#370xuri2019-04-15
| | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
* Resolve #106, #294 performance optimization for add hyperlinkxuri2019-02-26
|
* Resolve #274, performance optimization for add images, charts and shapesxuri2019-02-25
|
* Resolve #235, performance optimization for add comments (#347)BluesJhao2019-02-25
|