Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
Collective - Host: opensource - https://opencollective.com/excelize - Website: https://xuri.me/excelize - Code: https://github.com/xuri/excelize

ref #65, new formula functions: RRI, SLN and SYD

github.com/qax-os/excelize - 1df7f32cc641c747433b3f58e0de0deb58785bf3 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions IFNA and IFS and fix string compare result issue in arithmetic operations

github.com/qax-os/excelize - 5f907b78245a8a2601661e7f6b7ac6abba2d3812 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function AMORLINC

github.com/qax-os/excelize - 620f873186e9f69a05d88f79cfb899b42e584331 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions ACCRINTM and AMORDEGRC

github.com/qax-os/excelize - c89b64c53c8314b71374f85fabf29175646e10b2 authored about 3 years ago by xuri <[email protected]>
ref #65, new formula function: TIME

github.com/qax-os/excelize - cf8766df83f03152026c2301ff99eb7121d702ba authored about 3 years ago by xuri <[email protected]>
Update the test case of the formula function `MIRR`

github.com/qax-os/excelize - c64ce0f9ac1ffa251d6645d527263e3a9a7f854b authored about 3 years ago by Tammy <[email protected]>
This closes #1031, fix small float parsed error in some case

- new formula function: YEARFRAC, ref #65
- update the codecov version
- remove unused variable

github.com/qax-os/excelize - de38402f74bea9557188ad2c6f31c3127fd1bbfe authored about 3 years ago by xuri <[email protected]>
This closes #1030, fix date rounding error

github.com/qax-os/excelize - 58fd279dc845ebd9ccd4ba336d7c664824e70e43 authored about 3 years ago by xuri <[email protected]>
This closes #1029, support specify compact and outline for the pivot table

github.com/qax-os/excelize - aa8f6f02bdf933df6cffec6b408276d02ed9e6b0 authored about 3 years ago by xuri <[email protected]>
initialize formula function TRANSPOSE, ref #65 and remove unused exported error variable ErrToExcelTime

github.com/qax-os/excelize - 28841af9804243205a9693be0cb501ce2d980302 authored over 3 years ago by xuri <[email protected]>
Now support set row style in the stream writer

github.com/qax-os/excelize - e52e75528260745d87fb0962fe239f54c1b5b390 authored over 3 years ago by xuri <[email protected]>
This closes #1027 and closes #1028

* Fix build-in scientific number format failed
* An error will be returned if given an invalid c...

github.com/qax-os/excelize - 2d8b5b1885b3d5cd14c974df61a3d0d757efd7bd authored over 3 years ago by xuri <[email protected]>
This closes #1026, time parse accuracy issue and typo fixed

github.com/qax-os/excelize - 490f3063c2cb35a94d64f6a6859cce7b9dee276d authored over 3 years ago by xuri <[email protected]>
new formula function: DAYS, ref #65

github.com/qax-os/excelize - c05b9fe8a6e6cadad0de7821bd33fa5cc283c8e4 authored over 3 years ago by xuri <[email protected]>
This closes #833, closes #845, and closes #1022, breaking changes

- Close spreadsheet and row's iterator required
- New options `WorksheetUnzipMemLimit` have been...

github.com/qax-os/excelize - 790c363cceaaa09e91ad579e2d25cb13c1582bba authored over 3 years ago by xuri <[email protected]>
- new formula functions: DATEVALUE, ref #65

- fix ineffectual variable assignments
- timeout in go test

github.com/qax-os/excelize - 2add938798cdd1456616869298319528b0c76913 authored over 3 years ago by xuri <[email protected]>
new formula functions: WEIBULL and WEIBULL.DIST, ref #65

github.com/qax-os/excelize - 1ba3690764e90aa6f7bcb3cb1e095475d40e3d91 authored over 3 years ago by xuri <[email protected]>
new formula functions: Z.TEST and ZTEST, ref #65

github.com/qax-os/excelize - 4ef68729f5bf2150b06cbace068412b3dde2d1ae authored over 3 years ago by xuri <[email protected]>
This closes #1017, fix duplicate image caused by incorrect internal relationships ID calculation

github.com/qax-os/excelize - 52609ba52678642810363cba485e60f370850ddc authored over 3 years ago by xuri <[email protected]>
This closes #417 and closes #520, new API `GetCellType` has been added

github.com/qax-os/excelize - dad8f490cc2df664bf1e7c6770ecd89a0c0e7fe4 authored over 3 years ago by xuri <[email protected]>
This closes #262, support set line width of add the shape

github.com/qax-os/excelize - 72d84c0cbdd0ad748dba19e21d4e92ea077110c7 authored over 3 years ago by xuri <[email protected]>
This closes #993, closes #1014

- Fix formula percentages calculated incorrectly
- Make UpdateLinkedValue skip macro sheet
- Fix ...

github.com/qax-os/excelize - 684603befa0fbde2ee8db704e37a544f9d92d99d authored over 3 years ago by xuri <[email protected]>
This closes #998

- Support text comparison in the formula, also ref #65
- `GetCellValue`, `GetRows`, `GetCols`, `...

github.com/qax-os/excelize - 32b23ef42d3ecb393e102c5f63ab5125db354435 authored over 3 years ago by xuri <[email protected]>
Add set shared formula support and documentation for the `SetCellFormula`

github.com/qax-os/excelize - 2616aa88cb2b1e45c03ada60093f4dfe7fabfb87 authored over 3 years ago by xuri <[email protected]>
This closes #1008, added new formula functions MATCH and XOR, related issue #65

github.com/qax-os/excelize - 5e1fbd6bf703b9e3ff0eba48c7ee861b99778cba authored over 3 years ago by xuri <[email protected]>
Preserve XML control character in bstrUnmarshal result

github.com/qax-os/excelize - c3d1d7ddddd02d9d8d39204dd891250222bb9ee4 authored over 3 years ago by xuri <[email protected]>
This closes #1012, support specify the formula in the data validation range, and update the documentation for the `AddPicture`

github.com/qax-os/excelize - 7d9b9275bd14556bfcaab7f1d3690b1e54ab75e8 authored over 3 years ago by xuri <[email protected]>
Improve compatibility with row element with r="0" attribute

github.com/qax-os/excelize - cd030d4aa81582e8bc04d029c0be6e42eff9ea47 authored over 3 years ago by xuri <[email protected]>
- This fix panic and incorrect cell read on some case

- Make unit test on Go 1.7
- API documentation updated

github.com/qax-os/excelize - a2d449708cf72928394b4bc4aea41c0c6a606fa2 authored over 3 years ago by xuri <[email protected]>
This closes #1006, new fn: MONTH ref #65

Co-authored-by: xuri <[email protected]>

github.com/qax-os/excelize - 9b55f4f9f0b839934eb8113d2092c60a1a5b64b8 authored over 3 years ago by Stani <[email protected]>
* This closes #1004, new fn: MONTH ref #65

github.com/qax-os/excelize - 4d716fa7edde76ed838aefcd8c5945bcfe3ba8f3 authored over 3 years ago by Stani <[email protected]>
This closes #997, fix LOOKUP function to find nearest match (#1001)

github.com/qax-os/excelize - f280c03345dc2a207ac319182da182a0f0fbb963 authored over 3 years ago by Stani <[email protected]>
This closes #1002, new fn: DAY ref #65

Co-authored-by: Stani Michiels <[email protected]>
Co-authored-by: xuri <[email protected]>

github.com/qax-os/excelize - 935af2e356ff60c88761db1fc9a6be8f8c67a4f5 authored over 3 years ago by Stani <[email protected]>
This closes #994, fix LOOKUP function for Array form

github.com/qax-os/excelize - dca03c6230e596560ea58ca1edb27581cdd59aaa authored over 3 years ago by Stani <[email protected]>
This closes #989, closes #990

New API: `SetRowStyle` support for set style for the rows
Update documentation for the `GetRows`...

github.com/qax-os/excelize - a55f354eb3d0c6c1b9a543ff8ff98227aa6063a6 authored over 3 years ago by xuri <[email protected]>
This closes #844, support get shared formula

github.com/qax-os/excelize - b02f864eab5edb2155601b9dd640f99fbd442cb3 authored over 3 years ago by raochq <[email protected]>
Improve security and simplify code

- Make variable name more semantic
- Reduce cyclomatic complexities for the formula calculate fu...

github.com/qax-os/excelize - 48c16de8bf74df0fa94a30d29e2e7e3446d48433 authored over 3 years ago by xuri <[email protected]>
Speed up merge cells

github.com/qax-os/excelize - f6f14f507ee1adf4883cb1b12f27932a63afb286 authored over 3 years ago by three <[email protected]>
This closes #987: support nested calc for if formula (#988)

github.com/qax-os/excelize - 61d0ed1ff26fbe47b4bfdc6adbc6db09743beb3a authored over 3 years ago by bailantaotao <[email protected]>
This closes #986, fix set data validation drop list failed in some cases

Update documentation for `GetCellValue` and simplify code

github.com/qax-os/excelize - 43a057b1eaeb810495618d70c2dc2d3e5df1fea4 authored over 3 years ago by xuri <[email protected]>
Reduce cyclomatic complexities for the formula calculate function and update documentation for the API: `MergeCell` and `GetCellValue`

github.com/qax-os/excelize - c49e7aab306437f0e721620af4a24364edf4d601 authored over 3 years ago by xuri <[email protected]>
This closes #979, fix the data validation deletion issue and tidy the internal function in the source code

github.com/qax-os/excelize - cf9fbafdd805874267a0f5d27fd1c720b148ec91 authored over 3 years ago by xuri <[email protected]>
Update dependencies module and bump version 2.4.1

github.com/qax-os/excelize - 933159f9391f9be1b41b51e85885722124f8a7aa authored over 3 years ago by xuri <[email protected]>
Improve compatibility for SetRichText (#976)

- support escaped string literal
- maximum character limit added
- fix missing preserve charac...

github.com/qax-os/excelize - eaf9781e7e51d5aacf238c9cb39a249097abed33 authored over 3 years ago by Arnie97 <[email protected]>
Fix data validation issues (#975)

* Fix `SetDropList` to allow XML special characters

* This closes #971, allow quotation marks...

github.com/qax-os/excelize - 7ac37edfebebc9bee201fad001e2f2f8b780a9a8 authored over 3 years ago by Arnie97 <[email protected]>
This closes #971, closes #972 and closes #974

- Escape XML character in the drop list
- Fix incorrect character count limit in the drop list
- ...

github.com/qax-os/excelize - 7dbf88f221f278075d4ff9e153b21236d0826c33 authored over 3 years ago by xuri <[email protected]>
change go module import path to github.com/xuri/excelize

github.com/qax-os/excelize - e9ae9b45b20a5df7e3aa15afcfac83ecb13394c6 authored over 3 years ago by xuri <[email protected]>
This closes #882, support set rows height and hidden row by stream writer

github.com/qax-os/excelize - f9e9e5d2e07b087e2d4fb2487193aea8c240ab0e authored over 3 years ago by xuri <[email protected]>
Improvement compatibility with invalid first-page number attribute in the page layout

github.com/qax-os/excelize - 5ce3fe8cb89f5f278b3857bab8e69c117c2a6027 authored over 3 years ago by xuri <[email protected]>
Fix code security issue

github.com/qax-os/excelize - 1ec0207fb5fe772e47b257ab2b0c26ff85f94598 authored over 3 years ago by xuri <[email protected]>
This closes #883, fix missing pivot attribute of conditional formatting

github.com/qax-os/excelize - ec0ca8ba50a3a59048c51e360301230f45dfc978 authored over 3 years ago by xuri <[email protected]>
This closes #879, fix delete defined name failed in some case

github.com/qax-os/excelize - fbcfdeae90b7e755a70c6ceef27346c7d0552937 authored over 3 years ago by xuri <[email protected]>
This closes #848 and closes #852, fix reading decimals precision

github.com/qax-os/excelize - f62c45fe0c111774fc69a31a42d5f3add10e5095 authored over 3 years ago by xuri <[email protected]>
This closes #873, make the sheet names are not case sensitive for `NewSheet`, `GetSheetIndex`, `DeleteSheet`

github.com/qax-os/excelize - b14b74bf560f192f658d66fdbf719190f691bc5f authored over 3 years ago by xuri <[email protected]>
Prevent panic when incorrect range is provided as PivotTableRange to (#874)

github.com/qax-os/excelize - ee8098037dc71028e755ae62dfeb823c0e7b366e authored over 3 years ago by Deepak S <[email protected]>
This closes #872, support re-save the new spreadsheet after `SaveAs`

github.com/qax-os/excelize - 2ced00d6a82f993094858e60127d4f817ad788e3 authored over 3 years ago by xuri <[email protected]>
Fix missing set each cell's styles when set columns style

github.com/qax-os/excelize - 4f0d676eb765472d1fe7a29cacd165b982785bd2 authored over 3 years ago by xuri <[email protected]>
Make the functions `SetSheetRow`, `New Style` and `SetCellStyle` concurrency safety

github.com/qax-os/excelize - 90d200a10ba4d8c2ae2eff47ad8e1cca0ab28e76 authored over 3 years ago by xuri <[email protected]>
Support concurrency add picture

github.com/qax-os/excelize - b7fece51736977e7d84aca30ecce7f6b3a1251f2 authored over 3 years ago by xuri <[email protected]>
- Support concurrency iterate rows and columns

- Rename exported field `File.XLSX` to `File.Pkg`
- Exported error message

github.com/qax-os/excelize - 544ef18a8cb9949fcb8833c6d2816783c90f3318 authored over 3 years ago by xuri <[email protected]>
This closes #861, support concurrency get cell picture and remove unused internal function `getSheetNameByID`

github.com/qax-os/excelize - 0e02329bedf6648259fd219642bb907bdb07fd21 authored over 3 years ago by xuri <[email protected]>
fix: LocalSheetID in DefinedName should be equal to SheetIndex instead of SheetID (#868)

github.com/qax-os/excelize - 5ec61310dc55c9af93d66e6d225f721738416d1f authored over 3 years ago by vettich <[email protected]>
This closes #866, support use the defined name to reference the data range in pivot table options

- Fix incorrect scope when getting defined name
- Update docs: use column number instead of index...

github.com/qax-os/excelize - f27624acddfb51916e028f421568840595dbad67 authored over 3 years ago by xuri <[email protected]>
feat: stream write to zip directly (#863)

github.com/qax-os/excelize - 24967a5c25499f92b4e58b8d6f8a92a46a7acc7a authored over 3 years ago by Zitao <[email protected]>
encode the escaped string literal which not permitted in an XML 1.0 document

github.com/qax-os/excelize - 2cfcf9eb5ff2f332dad0c6adead53ef0500001db authored over 3 years ago by xuri <[email protected]>
fix getRowHeight actually get the height of the next row (#860)

github.com/qax-os/excelize - c62ced7ca7a6cf715f62bd10981560a809c723dd authored over 3 years ago by strong <[email protected]>
make the caller of `getRowHeight` function adapt row number change, update comment: use rows number instead of rows index.

github.com/qax-os/excelize - bffb5d6b41f409258a2f0c126a04127f31e28a06 authored over 3 years ago by xuri <[email protected]>
string pattern match context check instead of regex lookahead assertion

github.com/qax-os/excelize - e354db69b0bdd02357c221af9ef09695dd8fd122 authored over 3 years ago by xuri <[email protected]>
skip XML control character in the escape literal string, and update dependencies

github.com/qax-os/excelize - 5faa36430cd77ae256a79cb52a7808d540da50da authored over 3 years ago by xuri <[email protected]>
support escaped string literal basic string and use GitHub Action instead of TravisCI

- Note that: travis-ci.org will shutdown on June 15th, 2021, and I don't have enough permission ...

github.com/qax-os/excelize - 83e12cc4e5242904366a51f642596acbc9f9dd56 authored over 3 years ago by xuri <[email protected]>
Create go.yml

github.com/qax-os/excelize - 38162539b61b2b429b0498198ed58e1ef53d284b authored over 3 years ago by xuri <[email protected]>
This closes #858 (#859)

* fixes https://github.com/360EntSecGroup-Skylar/excelize/issues/858

* fixes https://github.c...

github.com/qax-os/excelize - bafe087a61ca85b16fc69fda280f03eb2d7551dc authored over 3 years ago by jaby <[email protected]>
fixes #856 (#857)

github.com/qax-os/excelize - 2c90b3f53559076af661e3aebabfad9643a77c40 authored over 3 years ago by jaby <[email protected]>
This closes #855, fix missing formula cell when getting rows value

github.com/qax-os/excelize - d932e62a127da177769ec3f35aae985ca0a516db authored over 3 years ago by xuri <[email protected]>
This closes #409 Remove UTC timezone requirement from date.go (#853)

According to issue #409

There is absolutely no reason for the timezone to be in UTC, and conv...

github.com/qax-os/excelize - 58f9287559b26ec44a9a68c4351efa88327be51d authored over 3 years ago by Alluuu <[email protected]>
Merge pull request #851 from si9ma/feat_disable_axis

feat: add disable option for chart xAxis and yAxis

github.com/qax-os/excelize - 31d88a26241c32add01deff37ccc69cfe9efd03b authored over 3 years ago by xuri <[email protected]>
feat: add disable option for chart xAxis and yAxis

github.com/qax-os/excelize - faa50c3326f05833e560653f368b80cb2cf0fac0 authored over 3 years ago by si9ma <[email protected]>
Merge pull request #847 from qwaszx102938/master

fix the bug that there was no count attribute in sharedStrings file, fix the bug that setting O...

github.com/qax-os/excelize - 056dc8454edb59758f06040195d40703c8b63900 authored over 3 years ago by xuri <[email protected]>
fix the bug when there was no count attribute in sharedStrings file

github.com/qax-os/excelize - 2f74ec171d8c42367666014fa661eab26f088e68 authored over 3 years ago by william <[email protected]>
This closes #842, avoid empty rows in the tail of the worksheet

github.com/qax-os/excelize - 5bf3ea61547df2a36757f14bfba47bf22b747079 authored over 3 years ago by xuri <[email protected]>
* This closes #841, fix incorrect build number format in PR #839

github.com/qax-os/excelize - c8c62c2d2a7da3f8e03ad081a9227bcb47f38c45 authored over 3 years ago by ice <[email protected]>
"15" is the correct 24 hours time format in go (#839)

* "15" is the correct 24 hours time format in go
* fix number format convert issue and remove t...

github.com/qax-os/excelize - 37342f6d81b27adbcdc6cf6cf9ccdc68f92cdb46 authored over 3 years ago by ice <[email protected]>
This closes #838, fix wrong worksheet XML path of the stream writer in some case

github.com/qax-os/excelize - a1e1db1e6f2faa8286afb1e9291c51fa084b66f7 authored over 3 years ago by xuri <[email protected]>
This closes #652, new SetColWidth API, support set column width in stream writing mode, and export error message

github.com/qax-os/excelize - be12cc27f1d774154b17763c071e1dc6f91eab8c authored over 3 years ago by xuri <[email protected]>
#65 fn: BESSELK and BESSELY

github.com/qax-os/excelize - 423bc26d1f87db55bab5704afebf4509269bbc7e authored over 3 years ago by xuri <[email protected]>
compatibility with non-standard page setup attributes

github.com/qax-os/excelize - 0e0237e62dcdbdd9ef5686d37171b1d5a61fac2b authored over 3 years ago by xuri <[email protected]>
This closes #834, fix invalid file path and duplicate namespace when re-creating worksheet

github.com/qax-os/excelize - 438fd4b3f958dc3edbbe4915e866ac639a3135f1 authored over 3 years ago by xuri <[email protected]>
Fixe issue generated file corrupted caused by incorrect default XML namespace attributes

github.com/qax-os/excelize - 7e429c5b464b53f305e94cc355f14ba9e1d9849c authored over 3 years ago by xuri <[email protected]>
#826, support merge cell in streaming mode

github.com/qax-os/excelize - af5e87dbcf5a89201072f5ca07d532258ece278f authored over 3 years ago by xuri <[email protected]>
This closes #825, closes #829, closes #830, fix issue when get and add comments on multi authors

github.com/qax-os/excelize - a13ef5545ec79108477910346ae4cab82ab8bbda authored over 3 years ago by xuri <[email protected]>
Fixed #825, improves compatibility for comments with absolute XML path

github.com/qax-os/excelize - e5c5ecc379434b7ef4ffcbb9dcf58526cafda66a authored over 3 years ago by xuri <[email protected]>
Fixed #823, 12/24 hours time format parsing error

github.com/qax-os/excelize - f5a20fa03f2abd9edfa2f9da66680e987fffae79 authored over 3 years ago by xuri <[email protected]>
update dependencies module and bump version 2.4.0

github.com/qax-os/excelize - d42834f3a82cebe6b54fd67b1f7f50582ea287dc authored over 3 years ago by xuri <[email protected]>
#65 fn: IRR nad MIRR

github.com/qax-os/excelize - 80d832022f8633b2829eb3586f35866d393f1959 authored over 3 years ago by xuri <[email protected]>
#65 fn: FV, FVSCHEDULE, NPER, NPV and PDURATION

github.com/qax-os/excelize - 471f4f8d2ba13a7ee50039aef0bc3df16c329818 authored over 3 years ago by xuri <[email protected]>
#65 fn: DB, DDB, DOLLARDE, DOLLARFR, EFFECT, ISPMT and NOMINAL

github.com/qax-os/excelize - 68dd5b345c666bc76aedfe1ae396b1fa04238ba6 authored over 3 years ago by xuri <[email protected]>
fixed the negative values series missing chart color, #65 fn: CUMIPMT and CUMPRINC

github.com/qax-os/excelize - a13b21fe07e7d19a40529837b7148bc0261b9ae7 authored over 3 years ago by xuri <[email protected]>
Support specifies that each data marker in the series has a different color

github.com/qax-os/excelize - 1559dd31be6f394ed78129d763c4677cc26bb51c authored almost 4 years ago by xuri <[email protected]>
#65 fn: IPMT, PMT and PPMT

github.com/qax-os/excelize - a8197485b5ca94f18f454eaae34af74500bd4dc3 authored almost 4 years ago by xuri <[email protected]>
Fixed #819, read empty after streaming data writing

#65 fn: IMAGINARY, IMARGUMENT, IMCONJUGATE and IMDIV

github.com/qax-os/excelize - 737b7839a25d530d6a1908fc6c4c33e1c047cdd6 authored almost 4 years ago by xuri <[email protected]>