summaryrefslogtreecommitdiff
path: root/excelize.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
* Go 1.16 and later required, migration of deprecation package `ioutil`xuri2022-10-13
| | | | | | - Improving performance for stream writer `SetRow` function, reduces memory usage over and speedup about 19% - Update dependencies module - Update GitHub workflow
* Stream writer support to set inline rich text cell (#1121)charles.deng2022-10-10
| | | Co-authored-by: zhengchao.deng <zhengchao.deng@meican.com>
* Support to set summary columns to appear to the right of detail in an outlinexuri2022-10-08
| | | | | | - Simplify calculation engine code - Update documentation for the functions - Update dependencies module
* Using the specialized name in a variable and making comments clearxuri2022-09-18
| | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
* This closes #744, the `Save`, `Write` and `WriteTo` function accept saving ↵xuri2022-09-08
| | | | options
* This made library allowing insert EMZ and WMZ format imagexuri2022-08-21
| | | | - Update dependencies module
* This closes #849, add new function `DeleteComment` for delete comment (#1317)NaturalGao2022-08-19
| | | | - Update unit tests for the delete comment - Add 3 errors function for error messages
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* Fix potential file corrupted and change worksheet name case-insensitivexuri2022-07-18
| | | | | | - Using sheet ID instead of sheet index when delete the cell in calculation chain - Update documentation for exported functions - Using `sheet` represent the sheet name in the function parameters
* This closes #1262, support for dependence formulas calculationxuri2022-07-10
| | | | | - Add export option `MaxCalcIterations` for specifies the maximum iterations for iterative calculation - Update unit test for the database formula functions
* This closes #1257, fix incorrect worksheet header footer fields orderxuri2022-06-21
|
* This update docs and tests for workbook encryptionxuri2022-05-31
|
* 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 #1217, support update cell hyperlinkxuri2022-05-01
| | | Ref #1129, make `SetRowStyle` overwrite style of the cells
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* 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
* 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%
* This closes #993, closes #1014xuri2021-09-06
| | | | | | - Fix formula percentages calculated incorrectly - Make UpdateLinkedValue skip macro sheet - Fix conditional format bottom N not working
* This closes #998xuri2021-09-05
| | | | | | | - Support text comparison in the formula, also ref #65 - `GetCellValue`, `GetRows`, `GetCols`, `Rows` and `Cols` support to specify read cell with raw value, ref #621 - Add missing properties for the cell formula - Update the unit test for the `CalcCellValue`
* Improve compatibility with row element with r="0" attributexuri2021-08-23
|
* - This fix panic and incorrect cell read on some casexuri2021-08-22
| | | | | - Make unit test on Go 1.7 - API documentation updated
* 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
* Support concurrency add picturexuri2021-07-06
|
* - 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`
* 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
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* Fix UpdateLinkedValue which returns an error when has graph sheet (#793)yuki20062021-03-04
| | | | | | | | | * Fixed UpdateLinkedValue which returns an error when there is a graph sheet Signed-off-by: yuuki.ono <yagfair@gmail.com> * fix refactoring from review Signed-off-by: yuuki.ono <yagfair@gmail.com>
* Update excelize.go (#765)Ray2021-01-20
| | | miss a char as 'l' in the excel.
* Fixed #732, support single line with repeated row element in the sheet dataxuri2020-11-18
|
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* using POSIX directory separator in zip path with Windowsxuri2020-11-06
|
* Compatibility improvement: parse document core part (workbook) dynamicallyxuri2020-11-04
|
* 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
|
* init ECMA-376 agile encryption supportxuri2020-09-06
|
* support ECMA-376 document standard encryption, ref #199xuri2020-09-02
|
* Resolve #199, init password protection spreadsheet supportxuri2020-09-01
|
* using Mutex lock and update benchmarkxuri2020-08-16
|
* Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 ↵xuri2020-08-15
| | | | potential race condition
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|