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

#65 fn: IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, and IMSECH

github.com/qax-os/excelize - 99963f89c70234a804521f6897354a82e996142c authored almost 4 years ago by xuri <[email protected]>
#65 fn: IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN

github.com/qax-os/excelize - 3345e89b96fa058273da732be48d01cff4f69960 authored almost 4 years ago by xuri <[email protected]>
Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMEXP, IMLN and IMLOG10

github.com/qax-os/excelize - f8f699a172bd0219a8736b19091dd3eaa9eb3b25 authored almost 4 years ago by xuri <[email protected]>
Fixed #813, streaming data writer result missing after call normal API

#65 formula function: COMPLEX

github.com/qax-os/excelize - 89c262fc1d525f74bb0e2fb61ae7a3d10d07a12a authored almost 4 years ago by xuri <[email protected]>
#65 fn: BESSELI and BESSELJ

github.com/qax-os/excelize - 6e812a27c6e74a141e301c0f19484743ea437c52 authored almost 4 years ago by xuri <[email protected]>
#65 fn: VAR.P and VARP and fix Yoda conditions issue

github.com/qax-os/excelize - a002a2417e9cc9d8dc3d405d2d96f7dd24710082 authored almost 4 years ago by xuri <[email protected]>
#65 fn: QUARTILE and QUARTILE.INC

github.com/qax-os/excelize - 9d4bf88b4700eeb5c50d4cc6efb0a2d73e5e8b7f authored almost 4 years ago by xuri <[email protected]>
#65 fn: N, PERCENTILE.INC and T

typo fixed

github.com/qax-os/excelize - 2af96c07149e2b79a06375bdc735c0a8c1f6646e authored almost 4 years ago by xuri <[email protected]>
#65 fn: PERCENTILE and PERMUTATIONA

github.com/qax-os/excelize - 6d7bd7cd8aaeba3a0969b6f035f0a5a53209a184 authored almost 4 years ago by xuri <[email protected]>
#65, new fn: POISSON.DIST, POISSON, SKEW, and STDEV.S

github.com/qax-os/excelize - 3903c106a4391d408fb9f72713038f7e4e6367de authored almost 4 years ago by xuri <[email protected]>
This closes #809, and add new fn: HARMEAN

github.com/qax-os/excelize - e1abdb0e5a0ecae47dd0116c9165f4ad6e492856 authored almost 4 years ago by xuri <[email protected]>
#64 fn: NORM.DIST, NORMDIST, NORM.INV, NORMINV, NORM.S.DIST, NORMSDIST, NORM.S.INV, and NORMSINV

github.com/qax-os/excelize - ab2c1c8fe1ef787c1f692bcf26c7bbe0cca2c5b3 authored almost 4 years ago by xuri <[email protected]>
Merge pull request #808 from JDavidVR/patch-1

updated SetDefinedName's localSheetId attr to use sheetIndex

github.com/qax-os/excelize - bd83c27ffc11915d0f6ffaa904ed999364434792 authored almost 4 years ago by xuri <[email protected]>
updated SetDefinedName's localSheetId attr to use sheetIndex

Excelize 2.3.2 OUT:

```
<sheets>
<sheet name="Q-P-QP-11" sheetId="55" r:id="rId1"/>...

github.com/qax-os/excelize - d08a6d243761a6214f8fef3181b689251bb72de0 authored almost 4 years ago by David <[email protected]>
related issue #65 fn: FIXED

github.com/qax-os/excelize - 874d59cee02b5fab36e7cf5e2595c473f65f6c9d authored almost 4 years ago by xuri <[email protected]>
#65 fn: DATEDIF

github.com/qax-os/excelize - d3227393efb037bc13a4b5f7b150715f22761b4d authored almost 4 years ago by xuri <[email protected]>
This closes #804, fixes can't add timelines and slicers for a pivot table in generated spreadsheet

github.com/qax-os/excelize - 9af00b9b98daa2beca7bbf7805b88da4963a8cd1 authored almost 4 years ago by xuri <[email protected]>
#65 fn: NOW and TODAY, and update dependencies

github.com/qax-os/excelize - 2350866d460c883fbd0b3a403a62b943a5f6aca5 authored almost 4 years ago by xuri <[email protected]>
support ShowError option in Pivot table (#802)

github.com/qax-os/excelize - b83a36a8aead4b76c2c4025283590e1afd7e500a authored almost 4 years ago by jinhyuk-kim-ca <[email protected]>
#625, support setting formula for cell in streaming API

github.com/qax-os/excelize - 7e12b560ce40fc756fa5347d25a64ea48f9710ac authored almost 4 years ago by xuri <[email protected]>
fix incorrect default column from GetColWidth

github.com/qax-os/excelize - 71bd5e19598db4dae85d983d1f79251451cb2d9a authored almost 4 years ago by xuri <[email protected]>
Fix UpdateLinkedValue which returns an error when has graph sheet (#793)

* Fixed UpdateLinkedValue which returns an error when there is a graph sheet

Signed-off-by: y...

github.com/qax-os/excelize - dbe88d723ef8ab3d2fbb1b94aa4c5b2486b0e679 authored almost 4 years ago by yuki2006 <[email protected]>
Add support for setting hyperlink display & tooltip (closes #790) (#794)

github.com/qax-os/excelize - a12dfd3ce6402f22baeb6415af271d8545c74f71 authored almost 4 years ago by James Allen <[email protected]>
#65 fn: LARGE, SMALL, SUBSTITUTE, refactor ARABIC

github.com/qax-os/excelize - 7ef1892f320879670c4e9a8536a70281d782625e authored almost 4 years ago by xuri <[email protected]>
This improves compatibility for absolute XML path, Windows-style directory separator and inline namespace;

github.com/qax-os/excelize - afe2ebc26143330a15b4396b9be6ca04797a5e8e authored almost 4 years ago by xuri <[email protected]>
handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, FINDB

github.com/qax-os/excelize - 5a0d885315521a4e703f9de401e2dda834285d5f authored almost 4 years ago by xuri <[email protected]>
check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTB

github.com/qax-os/excelize - d84050921eddf5c4221f8723477be2ac93f56ecc authored almost 4 years ago by xuri <[email protected]>
add GetCellRichText method and test (#789)

github.com/qax-os/excelize - bbb8ebfa8cc648ec09094d16eddebb03240baecf authored almost 4 years ago by tonnyzhang <[email protected]>
This closes #787, avoid duplicate rich text string items, new formula fn: BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX

github.com/qax-os/excelize - 283339534741d3f0ff01c2ed2adc7c87445edf07 authored almost 4 years ago by xuri <[email protected]>
ref: #756, set cell as blank when SetCellValue with nil #756, new formula fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR

github.com/qax-os/excelize - 9154d500cf50621e15bf4a2bb9f6b5045d7b72d2 authored almost 4 years ago by xuri <[email protected]>
#65 fn: DEC2BIN, DEC2HEX, DEC2OCT

github.com/qax-os/excelize - ae6f56b9531d6dce437a719523c1a9c67b97f776 authored almost 4 years ago by xuri <[email protected]>
#65 fn: KURT, STDEV, STDEVA

github.com/qax-os/excelize - b3493c54168c0f05b8623775640304128fd472e9 authored almost 4 years ago by xuri <[email protected]>
This closes #785, support to change tab color; new formula function: FISHER, FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT

github.com/qax-os/excelize - bddea1262b9219df224d19b24928d8da78a2f8c0 authored almost 4 years ago by xuri <[email protected]>
lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX

github.com/qax-os/excelize - 36b7990d6ba1036823abf7a01ec8cf74509d4910 authored almost 4 years ago by xuri <[email protected]>
add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, NOT, REPT, SHEET, TRUE

github.com/qax-os/excelize - ca6b1577a7d1508e61e7084ee67ab0dd759b305e authored almost 4 years ago by xuri <[email protected]>
binary search in range lookup and new formula function: LOOKUP

github.com/qax-os/excelize - ec45d67e59318ad876b38d6ef96402732b601071 authored almost 4 years ago by xuri <[email protected]>
This improves compatibility for worksheet relative XML path and multi rules auto filter

github.com/qax-os/excelize - 3648335d7f45d5cf204c32345f47e8938fe86bfb authored almost 4 years ago by xuri <[email protected]>
This closes #782, fix unmerge all cells cause corrupted file

github.com/qax-os/excelize - 3783d1d01b458a56a4de6aba4a2d10605bfbc876 authored almost 4 years ago by xuri <[email protected]>
init new formula function: HLOOKUP

github.com/qax-os/excelize - 23c73ab527731f9d414e81f7ea15e2ae1a72a290 authored almost 4 years ago by xuri <[email protected]>
fix custom row height check issue

github.com/qax-os/excelize - 30549c5e90884789fff6599d6e773d1ca56ba962 authored almost 4 years ago by xuri <[email protected]>
handle end element event in the worksheet row/column iterator XML SAX parser

github.com/qax-os/excelize - 2fb135bc94bbb0c487563d166fd24786fab7280a authored almost 4 years ago by xuri <[email protected]>
init new formula function: VLOOKUP

github.com/qax-os/excelize - 66d85dae1367c106acd373baa5087e4bd712e3f9 authored almost 4 years ago by xuri <[email protected]>
This closes #774, closes #775 and closes #776

- correct adjust calculation chain in duplicate rows
- correct adjust defined name in the workboo...

github.com/qax-os/excelize - 1f329e8f968014e26351a729ba7e6e3c846e96db authored almost 4 years ago by xuri <[email protected]>
update formula functions test

github.com/qax-os/excelize - db7b4ee36200df4b4838c2111e81808016b4f6ef authored almost 4 years ago by xuri <[email protected]>
Fix hyperbolic cotangent calculation incorrect and unit test

github.com/qax-os/excelize - 4ac32278ff3e8951307274ceb4dd0043d606d5a0 authored almost 4 years ago by xuri <[email protected]>
Nested formula function support cell references as arguments

github.com/qax-os/excelize - 76c72e0a3060a7231f4ffb1437a2d86c7715e656 authored almost 4 years ago by xuri <[email protected]>
refactor formula calculation framework, add new function CHOOSE, and update dependencies module

github.com/qax-os/excelize - dd77cfe44c0d5481adb3af9a8e67b31d450a99e0 authored almost 4 years ago by xuri <[email protected]>
value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause … (#770)

* value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause ineffective omitempty tag...

github.com/qax-os/excelize - 219add2f0e4ae591141330648d410b60f5c0dbcf authored almost 4 years ago by Eagle Xiang <[email protected]>
new formula fn: IF, LEN; not equal operator support and faster numeric precision process

github.com/qax-os/excelize - b84bd1abc06457f6383013b8a600fc8c95eed2ed authored almost 4 years ago by xuri <[email protected]>
Fixed #766, change order, and added fields of workbook fields

github.com/qax-os/excelize - e568319bbca22011690a54c5f5741da2b50d0c7c authored almost 4 years ago by xuri <[email protected]>
Update excelize.go (#765)

miss a char as 'l' in the excel.

github.com/qax-os/excelize - 58ecf81630e693646d4e70d5f7f33dcb8dafaeb0 authored almost 4 years ago by Ray <[email protected]>
Fixed #764, add a condition for round precision

github.com/qax-os/excelize - 1bc5302007e04b83ed542fee993e9a79aea9e370 authored almost 4 years ago by xuri <[email protected]>
support to set print black and white and specified the first printed page number

github.com/qax-os/excelize - b260485f29038ca8df9993edb1c021672b3df7e4 authored almost 4 years ago by xuri <[email protected]>
Support to adjust print scaling of the worksheet

github.com/qax-os/excelize - 054bb9f0612ab7bd5836c3817d105a9b0c9e6059 authored almost 4 years ago by xuri <[email protected]>
This closes #756, not set the empty string for the cell when SetCellValue with nil

github.com/qax-os/excelize - a26675517e6326a7e3d3391f9de79d5efeb8bb90 authored about 4 years ago by xuri <[email protected]>
Update the tips message for Go modules user

github.com/qax-os/excelize - 22dc6ff33c24e25c0281401272c852f81c10a9f1 authored about 4 years ago by 龚尚 <[email protected]>
AddChart support disable legend of the chart

github.com/qax-os/excelize - 71829c520235b733870563f30dceef9ef4dbbb98 authored about 4 years ago by xuri <[email protected]>
This closes #752, fix incorrectly merged cells on duplicate row, and new formula function: LOWER, PROPER, UPPER

github.com/qax-os/excelize - 576bfffbe6add78e719fc4fab851f40f5779a4d3 authored about 4 years ago by xuri <[email protected]>
This closes #657 and closes #748, AddChart support custom marker symbol and symbol size, fix AddPicture auto fit failure with multi merged cells

github.com/qax-os/excelize - 77978ac68d3808060e58df41ebede4b9f3631641 authored about 4 years ago by xuri <[email protected]>
new formula func CLEAN and TRIM, change import path to v2 (#747)

github.com/qax-os/excelize - ad79505173302fdd7619288b793497052e25a148 authored about 4 years ago by Zhang Zhipeng <[email protected]>
Number format read fix (#741)

* fix UT-generated file names to be ignored
* fix cell value load with invalid number format ID...

github.com/qax-os/excelize - 61057c58d34c78232ad0a5c1702ea9fa25a7641a authored about 4 years ago by Artem Kustikov <[email protected]>
support range validation for decimal (#739)

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

github.com/qax-os/excelize - 95d8920c8e99684eb4e5068e38d3e7e5d0409d4e authored about 4 years ago by jacentsao <[email protected]>
Fixed #735, refresh active tab after delete sheet

github.com/qax-os/excelize - 13e0ed2a69af0ff0ba20e50fb23dd4909a39b69d authored about 4 years ago by xuri <[email protected]>
Fixed #727, rounding numeric with precision for formula calculation

github.com/qax-os/excelize - 599a8cb0bceb6cb14d3018360bb4c5140753c2b3 authored about 4 years ago by xuri <[email protected]>
Fixed #732, support single line with repeated row element in the sheet data

github.com/qax-os/excelize - 92c8626f814c3bcb91e30f83de8e68c9b8bb9a5f authored about 4 years ago by xuri <[email protected]>
Fix row duplicate mechanism (#729)

github.com/qax-os/excelize - 2be4bfd410744201f96e79804ef644d26c47f49f authored about 4 years ago by Eugene Androsov <[email protected]>
Fix #724, standardize variable naming and update unit tests

github.com/qax-os/excelize - 2514bb16c682679485dfb5298e1a5797b97bdcd7 authored about 4 years ago by xuri <[email protected]>
using POSIX directory separator in zip path with Windows

github.com/qax-os/excelize - 5dd0b4aec2931079e064f1fb393b034ce4934540 authored about 4 years ago by xuri <[email protected]>
Fix race conditions

github.com/qax-os/excelize - cdc57db3b3758781bd053228bfb32879b3adf3de authored about 4 years ago by xuri <[email protected]>
Compatibility improvement: parse document core part (workbook) dynamically

github.com/qax-os/excelize - c82a185af83b8b3934efcb0b227e494a18f426ea authored about 4 years ago by xuri <[email protected]>
optimize memory allocation (#722)

* optimize marshal

* optimize mem alloc

* add benchmark testing

* add NewSheetWithRowNu...

github.com/qax-os/excelize - fcca8a38389c7a7f99639dc142b9b10c827ac7ce authored about 4 years ago by Ted <[email protected]>
Update conversion between integer types and unit tests

github.com/qax-os/excelize - 9d470bb38f992d9f0da2168b7a576f9e212b7a88 authored about 4 years ago by xuri <[email protected]>
New formula function AND (#701) and update doc for the NewSheet (#714)

github.com/qax-os/excelize - b812e9a1a8ebe9ab22c51553eb46b1f1cff1f7c1 authored about 4 years ago by xuri <[email protected]>
This closes #714 and closes #715, fix wrong worksheet index returned by NewSheet in some case, fix panic on formatted value with no built-in number format ID

github.com/qax-os/excelize - 4834a058aa3f953a7010704f2358633ae6e1d492 authored about 4 years ago by xuri <[email protected]>
Fix #706, #713 improve AddPicture performance, fix missing worksheet when rename with same names

github.com/qax-os/excelize - 520aa679f34bafbc00626151075b0b123eceb516 authored about 4 years ago by xuri <[email protected]>
Fix #701, init new formula function AND and OR, prevent formula lexer panic on retrieving the top token type

github.com/qax-os/excelize - 02530e8c8ad94308458a33ac694e6ac9d3af4c87 authored about 4 years ago by xuri <[email protected]>
- Resolve #711, update docs for the GetSheetIndex

- Update unit test

github.com/qax-os/excelize - ac3dce0beaef6cbf2b08db4a1e2b2a8d100c77ca authored about 4 years ago by xuri <[email protected]>
- Resolve #627, improve multi-series line chart compatibility with KingSoft WPS

- Avoid to create duplicate style
- Update unit test for the auto filter
- Init code scanning alerts

github.com/qax-os/excelize - d1926675f81fcf9afb658e1e51cd4e43d0d05bc9 authored about 4 years ago by xuri <[email protected]>
Optimize memory usage when stream flush and save (#659)

* use io.Copy from stream temp file to zip Writer

* fix nil

* log

* build

* delete l...

github.com/qax-os/excelize - 93160287bb7fa6479c73ee031b5ed771972a17a8 authored over 4 years ago by Lijingfeng <[email protected]>
extend cell value load to support custom datetime format (#703)

* extend cell value load to support custom datetime format

* cleanup incorrect imports

* f...

github.com/qax-os/excelize - f2b8798a34aab4411a50861a4cdf47203edc3a19 authored over 4 years ago by Artem Kustikov <[email protected]>
Merge pull request #710 from lbraconnier2/Pivot-failed-in-case-of-multi-columns-and-multi-data

fix pivot fails in case of multi columns and multi data

github.com/qax-os/excelize - 9055a835a8c77b757e14cde22cc9daa3f9f0c66c authored over 4 years ago by xuri <[email protected]>
fix pivot fails in case of multi columns and multi data

github.com/qax-os/excelize - 2bd359bd01312bedd1b5f76f68765d1d66fa9a95 authored over 4 years ago by Ludovic Braconnier <[email protected]>
Pivot table generation fails when no Columns and multiple Data are provided. (#708)

fix to create pivot table in case there is no input from Columns

Co-authored-by: Jin Kim <jin...

github.com/qax-os/excelize - c49222023756d6740877f286cb7d3e7a5a0950eb authored over 4 years ago by jinhyuk-kim-ca <[email protected]>
Update dependency package version and docs for the OpenFile

github.com/qax-os/excelize - 89465f41b5a29ac2e1debe16b8cb6f59c344f917 authored over 4 years ago by xuri <[email protected]>
add checking and limits for the worksheet

github.com/qax-os/excelize - 324f87bcaed9ec775c0b79627956a093ad481d36 authored over 4 years ago by xuri <[email protected]>
Update docs and test case for the pivot table

github.com/qax-os/excelize - 96917e4617c9e7eb15c0ee1723a042f169321430 authored over 4 years ago by xuri <[email protected]>
Extend pivot table funtionality (#692)

Add different pivot options
Add header options to pivot table opts
Add Style name options to p...

github.com/qax-os/excelize - 97bffe608dfefe69a64fb450ae654ca798c710db authored over 4 years ago by Eugene Androsov <[email protected]>
init ECMA-376 agile encryption support

github.com/qax-os/excelize - 01afc6e03f1d28f1806ecd1f3c6c043f6755bd01 authored over 4 years ago by xuri <[email protected]>
improve compatibility for phonetic hint and sheet tab color

github.com/qax-os/excelize - 1111de2fdb7da9aa9f039f5173a6dafa6d98029c authored over 4 years ago by xuri <[email protected]>
support ECMA-376 document standard encryption, ref #199

github.com/qax-os/excelize - 98f1a699033b76a1482edc03d533dd1f67bcd2d6 authored over 4 years ago by xuri <[email protected]>
Resolve #199, init password protection spreadsheet support

github.com/qax-os/excelize - 4177c1585e312bee00c1592af3df6423c366e806 authored over 4 years ago by xuri <[email protected]>
Default row height compatibility with Apache OpenOffice and Kingsoft WPS, unit test update and typo fixed

github.com/qax-os/excelize - 88de2f8d510b0959bbb672b80656d207bd0bc927 authored over 4 years ago by xuri <[email protected]>
resolved #691, fix the scale for add picture not work

github.com/qax-os/excelize - 3c8c8c55c8128c5bb94fe28451f58fbc5fb4a118 authored over 4 years ago by xuri <[email protected]>
using Mutex lock and update benchmark

github.com/qax-os/excelize - 4e4baac3bc1cd11026a35fb59b6a0d7903a44070 authored over 4 years ago by xuri <[email protected]>
update stream writer fields offset

github.com/qax-os/excelize - bc704c854f270f5b53eaa6980c76950ad86410c7 authored over 4 years ago by xuri <[email protected]>
Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 potential race condition

github.com/qax-os/excelize - c3e92a51d744bc8420e0626b06ee3a0efd030341 authored over 4 years ago by xuri <[email protected]>
Merge branch 'master' into v2

github.com/qax-os/excelize - cb6f8852bb764ffc1f9b637faaf594353476e17c authored over 4 years ago by xuri <[email protected]>
test on Go 1.5 on Travis CI and update docs for the CalcCellValue

github.com/qax-os/excelize - 3cf3101fd99ad8901eac94ba4d15ad10cf3777a1 authored over 4 years ago by xuri <[email protected]>
Fix issue #686 RemoveRow slice bounds out of range (#687)

fix Hyperlinks update error

github.com/qax-os/excelize - c98fd7e5d05ee35d636304bb9864bb2943996c23 authored over 4 years ago by Wang Yaoshen <[email protected]>
This closes #677 and closes #679, fix panic when enabling compiler inline flags

github.com/qax-os/excelize - 843bd24e56450791ad122a2f3875956a0a70ec6e authored over 4 years ago by xuri <[email protected]>