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

89 Commits

Author SHA1 Message Date
barlevd 781c38481d
This closes #1889, refs #1732 and #1735 (#1890) 
Saving workbook with reverse sorted internal part path to keep same hash of identical files and fix incorrect MIME type
 2024-05-01 00:05:05 +08:00
Vivek Kairi ee2ef152d9
This closes #1815, cell value reading functions inherit the Options settings of the OpenReader (#1816) 
Co-authored-by: Vivek Kairi <vivek@zerodhafundhouse.com>
 2024-02-15 13:30:07 +08:00
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
user65536 a16182e004
This closes #1732, saving workbook with sorted internal part path (#1735) 2023-12-01 00:31:41 +08:00
xuri 7291e787bd
Support update volatile dependencies on inserting/deleting columns/rows 2023-11-02 00:15:41 +08:00
xuri 05689d6ade
This closes #1694, using namespace prefix in workbook theme XML 
- Improve compatibility with the viewer which doesn't support default theme part namespace
- ref #1690, support read background color style, and conditional format with default pattern type
- Update the unit tests
 2023-10-20 00:04:31 +08:00
fudali dfdd97c0a7
This closes #1199, support apply number format by system date and time options 
- Add new options `ShortDateFmtCode`, `LongDateFmtCode` and `LongTimeFmtCode`
- Update unit tests
 2023-05-06 20:34:18 +08:00
xuri 60b9d029a6
Breaking changes: changed the function signature for 4 exported functions 
- Change
    `func (f *File) AddVBAProject(bin string) error`
    to
    `func (f *File) AddVBAProject(file []byte) error`
- Change
    `func (f *File) GetComments() (map[string][]Comment, error)`
    to
    `func (f *File) GetComments(sheet string) ([]Comment, error)`
- Change
    `func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error`
    to
    `func (f *File) AddTable(sheet string, table *Table) error`
- Change
    `func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error`
    to
    `func (sw *StreamWriter) AddTable(table *Table) error`
- Rename exported data type `TableOptions` to `Table`
- Simplify the assert statements in the unit tests
- Update documents for the functions
- Update unit tests
 2023-03-25 13:30:13 +08:00
playGitboy 5878fbd282
This closes #1503, case-insensitive for the file extension name 2023-03-23 00:06:10 +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 ac564afa56
Remove internal error log print, throw XML deserialize error 2022-11-13 00:40:04 +08:00
xuri bd5dd17673
This is a breaking change, remove partial internal error log print, throw XML deserialize error 
- Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions
- Update unit tests
 2022-11-12 00:16:23 +08:00
xuri a410b22bdd
Fix the error on getting the range of merged cells on the worksheet which 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
 2022-10-28 00:31:55 +08:00
xuri adf9d37d82
This closes #1379, cleanup stream writer temporary files by the `Close` function 
- 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
 2022-10-26 00:04:23 +08:00
xuri 14c6a198ce
Support get cell value which contains a date in the ISO 8601 format 
- 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
 2022-10-24 00:52:09 +08:00
xuri 3d02726ad4
This closes #320, support custom chart axis font style 2022-10-14 00:48:16 +08:00
xuri fb1aab7add
This closes #744, the `Save`, `Write` and `WriteTo` function accept saving options 2022-09-08 22:20:21 +08:00
xuri 551fb8a9e4
This closes #1244 and closes #1314, improving the compatibility with Google Sheet 
- Format code with `gofmt`
 2022-08-13 11:21:59 +08:00
Regan Yue 0d4c97c88a
Optimizing line breaks for comments (#1281) 2022-07-17 12:18:25 +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
sceneq be5a4033c0
This closes #1229, rename ErrMaxFileNameLength to ErrMaxFilePathLength (#1230) 
Co-authored-by: sceneq
 2022-05-16 21:05:22 +08:00
xuri ecbc6e2fde
ref #65, new formula functions: T.INV and T.INV.2T 
- Typo fixed
 2022-04-04 00:21:33 +08:00
xuri 94f197c4fe
This improved formula calculate precision and added zero placeholder number format support 2022-03-19 00:05:47 +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 3ee3c38f9c
Fix file corrupted in some cases, check file extension and format code 
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`
 2022-01-23 00:48:26 +08:00
xuri 891e5baac1
ref #1096, reduce memory usage by about 50% for large data spreadsheet 2022-01-11 00:31: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
xuri 89b85934f6
This closes #1096, memory usage optimization and another 4 changes 
- 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
 2021-12-27 23:49:28 +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 bb0eb4a42b
This closes #1075, reload temporary files into memory on save 2021-12-01 00:10:31 +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 2ced00d6a8
This closes #872, support re-save the new spreadsheet after `SaveAs` 2021-07-09 00:04:58 +08:00
xuri 544ef18a8c
- Support concurrency iterate rows and columns 
- Rename exported field `File.XLSX` to `File.Pkg`
- Exported error message
 2021-07-05 00:03:56 +08:00
xuri 0e02329bed
This closes #861, support concurrency get cell picture and remove unused internal function `getSheetNameByID` 2021-07-04 12:13:06 +08:00
Zitao 24967a5c25
feat: stream write to zip directly (#863) 2021-06-22 14:06:08 +08:00
xuri be12cc27f1
This closes #652, new SetColWidth API, support set column width in stream writing mode, and export error message 2021-05-10 00:09:24 +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 89c262fc1d
Fixed #813, streaming data writer result missing after call normal API 
#65 formula function: COMPLEX
 2021-04-03 22:56:02 +08:00
xuri 2af96c0714
#65 fn: N, PERCENTILE.INC and T 
typo fixed
 2021-03-30 23:02:22 +08:00
xuri 36b7990d6b
lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX 2021-02-15 00:09:35 +08:00
xuri 2514bb16c6 Fix #724, standardize variable naming and update unit tests 2020-11-11 01:03:56 +08:00
Lijingfeng 93160287bb
Optimize memory usage when stream flush and save (#659) 
* 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>
 2020-10-05 22:17:11 +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 89465f41b5
Update dependency package version and docs for the OpenFile 2020-09-22 22:29:43 +08:00
xuri 324f87bcae
add checking and limits for the worksheet 2020-09-18 22:20:58 +08:00
xuri 01afc6e03f init ECMA-376 agile encryption support 2020-09-06 19:32:00 +08:00
xuri 15fd56853f
Update docs and typo fixed 2020-06-22 00:14:56 +08:00