OSDN -- Develop and Download Open Source Software
  • R/O
  • HTTP
  • SSH
  • HTTPS
Fork

excelize: List of commits

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets


All branches
RSS
Rev. Time Author
89b8593 2021-12-28 00:49:28 xuri

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
6b1e592 2021-12-26 15:55:53 xuri

This closes #1095, support to set and get document application properties
089cd36 2021-12-25 22:51:09 xuri

This closes #1097, initialized formula function XLOOKUP and update test
6051434 2021-12-19 14:36:24 xuri

ref #65, new formula functions MAXIFS and MINIFS
63fe422 2021-12-17 01:08:56 xuri

new formula function and update docs for formula functions

ref #65, new formula function: INDEX (array formula not support yet)
c0ac316 2021-12-14 01:38:16 xuri

ref #65: new formula function COUNTIFS
3371933 2021-12-13 01:02:25 xuri

ref #65: new formula functions: AVERAGEIF and COUNTIF
76aacfd 2021-12-12 01:07:01 xuri

ref #65: new formula function: SHEETS, and fix SHEET function count issue
b33e393 2021-12-10 17:48:02 jaby


This closes #1090 (#1092)

Keep track of operators per function
1b30406 2021-12-09 21:16:12 xuri

ref #65: new formula functions: ISFORMULA, ISLOGICAL and ISREF
5bf35f8 2021-12-09 10:40:11 jaby


This closes #1088 (#1089)

Support check string equality with the string value of a defined name
44a13aa 2021-12-07 01:26:53 xuri

Export 7 errors so users can act differently on different type of errors
3325c39 2021-12-06 23:37:25 Dokiy


Fix adjustMergeCellsHelper and add some test cases (#1082)

Signed-off-by: Dokiys <dokiychang@gmail.com>
7af55a5 2021-12-06 09:16:32 xuri

ref #65: new formula function ODDFPRICE
e0c6fa1 2021-12-04 14:11:01 xuri

Update docs for SetSheetStyle, and added 2 formula functions

ref #65: new formula functions DURATION and MDURATION
fix incorrect example in SetSheetStyle docs
577a07f 2021-12-03 01:19:11 xuri

Simplify code and update unit test

Improve unit test coverage for the functions: `NewStyle`, `SetActiveSheet`, `SearchSheet` and `deleteAndAdjustDefinedNames`
Simplify code and add comments for the function: `deleteAndAdjustDefinedNames`
aa359f1 2021-12-02 23:14:57 Michael Wiesenbauer


refactor DeleteSheet for better readability (#1078)

Signed-off-by: Michael Wiesenbauer <michael.wiesenbauer@ambos.io>
Co-authored-by: Michael Wiesenbauer <michael.wiesenbauer@fau.de>
4ca1b30 2021-12-02 01:48:20 xuri


Merge pull request #1077 from Dokiys/hotfix/get_num_fmt_id

Fix call getNumFmtID with builtInNumFmt return -1
45a1f08 2021-12-01 20:11:51 Dokiy

Fix call getNumFmtID with builtInNumFmt return -1
bb0eb4a 2021-12-01 01:10:31 xuri

This closes #1075, reload temporary files into memory on save
49c9ea4 2021-11-29 02:21:03 xuri

ref #65: new formula function YIELD
f26df48 2021-11-25 01:38:49 xuri

ref #65: new formula functions CONFIDENCE and CONFIDENCE.NORM
7907650 2021-11-24 01:09:35 xuri

This closes #1069, support time zone location when set cell value
9561976 2021-11-22 01:39:39 xuri

ref #65: new formula function VDB
a6c8803 2021-11-21 16:49:29 xuri

ref #65: new formula function XIRR
9b0aa7a 2021-11-20 12:31:17 xuri

This closes #1060, fix build-in time number format parse error
6b277c6 2021-11-18 09:06:14 xuri

Fix sheet deletion fail in some case
bc3c7d5 2021-11-17 01:25:36 xuri

ref #65: new formula function PRICE

- fix COUPPCD result accuracy issue
- update close spreadsheet example in documentation and README
bda8e7f 2021-11-16 01:40:44 xuri

This closes #1061, support multi-byte language on set header footer

typo fixed and simplify code for read the data values arguments of formula functions
7241036 2021-11-15 01:28:10 xuri

ref #65, new formula functions: COUPDAYBS, COUPDAYS and COUPDAYSNC
Show on old repository browser