p30928647
/
excelize
1
0
Fork 1
Code Issues Pull Requests Projects Releases 23 Wiki Activity
1,253 Commits 2 Branches 23 Tags 18 MiB
Commit Graph

22 Commits

Author SHA1 Message Date
3zmx 50e23df865
ref #65, support _xlfn.ANCHORARRAY formula function (#1784) 
- Initial formula array calculation support
- Update unit test and documentation
 2024-01-18 15:31:43 +08:00
xuri 792656552b
This closes #1777, fix the GetStyle or GetConditionalStyle function to returns incorrect DecimalPlaces field value 
- Update documentation for the NewStyle function
- Update unit tests
- Update dependencies Go module
- Update GitHub workflow dependencies package version
- Update copyright agreement statement
 2024-01-09 20:56:20 +08:00
xuri fb6ce60bd5
This closes #1523, preventing format text cell value as a numeric 
- Simplify variable declaration and error return statements
- Remove the internal `xlsxTabColor` data type
- Using the `xlsxColor` data type instead of `xlsxTabColor`
- Update unit test, improve code coverage
 2023-04-19 00:05:59 +08:00
xuri b39626fae9
This fixed worksheet protection issue 
- Update example code in the documentation
- Update unit tests
- Rename `PictureOptions` to `GraphicOptions`
- Adjust partial options fields data types for the `PictureOptions` and `Shape` structure
- Update dependencies module
 2023-01-02 11:47:31 +08:00
xuri 7363c1e333
Go 1.16 and later required, migration of deprecation package `ioutil` 
- Improving performance for stream writer `SetRow` function,  reduces memory usage over and speedup about 19%
- Update dependencies module
- Update GitHub workflow
 2022-10-13 00:13:36 +08:00
xuri fb1aab7add
This closes #744, the `Save`, `Write` and `WriteTo` function accept saving options 2022-09-08 22:20:21 +08:00
Sangua633 cfa2d603dd
Support encrypt workbook with password #199 (#1324) 2022-08-20 15:51:03 +08:00
xuri 8fde918d98
This update docs and tests for workbook encryption 2022-05-31 11:14:42 +08:00
xuri 7a6d5f5ebe
This initialized support for encryption workbook by password, ref #199 
- Remove exported variable `ErrEncrypt`
 2022-05-29 19:37:10 +08:00
xuri 63adac2589
make workbook open filed exception message clear 
- New exported constant `ErrWorkbookPassword`
- Rename exported constant `ErrWorkbookExt` to `ErrWorkbookFileFormat`
 2022-05-20 20:46:29 +08:00
xuri 8a335225c7
Format code, update documentation and remove exported variable `XMLHeaderByte` 2022-03-24 00:19:30 +08:00
xuri f87c39c41d
This closes #1148, resolve limitations when adding VBA project to the workbook 
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
 2022-02-17 00:09:11 +08:00
xuri 2245fccca0
Typo fix, rename exported constants, dependencies modules and copyright update 
Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
 2022-01-09 00:20:42 +08:00
Jonham.Chen af5c4d00e8
feat: implement SHA-512 algorithm to ProtectSheet (#1115) 2022-01-08 10:32:13 +08:00
xuri 44a13aa402
Export 7 errors so users can act differently on different type of errors 2021-12-07 00:26:53 +08:00
xuri 790c363cce This closes #833, closes #845, and closes #1022, breaking changes 
- Close spreadsheet and row's iterator required
- New options `WorksheetUnzipMemLimit` have been added
- Improve streaming reading performance, memory usage decrease about 93.7%
 2021-09-19 11:06:54 +08:00
xuri 48c16de8bf
Improve security and simplify code 
- 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
 2021-08-15 00:06:40 +08:00
xuri f8f699a172
Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMEXP, IMLN and IMLOG10 2021-04-04 15:29:43 +08:00
xuri 2af96c0714
#65 fn: N, PERCENTILE.INC and T 
typo fixed
 2021-03-30 23:02:22 +08:00
xuri ac3dce0bea
- Resolve #711, update docs for the GetSheetIndex 
- Update unit test
 2020-10-12 00:05:27 +08:00
Artem Kustikov f2b8798a34
extend cell value load to support custom datetime format (#703) 
* 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>
 2020-10-04 21:07:39 +08:00
xuri 01afc6e03f init ECMA-376 agile encryption support 2020-09-06 19:32:00 +08:00