Оффлайн
- Регистрация
- 1 Мар 2015
- Сообщения
- 1,481
- Баллы
- 155
Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLAM / XLSM / XLSX / XLTM / XLTX files. Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data.
GitHub:
We are pleased to announce the release of . Featured are a handful of new areas of functionality and numerous bug fixes.
Release Notes
The most notable changes in this release are:
Breaking Change
- Upgrade requirements Go language version is 1.23 or later, for upgrade of dependency package golang.org/x/crypto
- Change the data type of DataValidationType, DataValidationErrorStyle, DataValidationOperator, PictureInsertType from int to byte
- SetCellInt function required int64 data type parameter, resolve issue 2068
- When adding drawing objects such as pictures, charts, shapes, and form controls, the offset setting will no longer affect the size of the drawing object, related issue 2001
- Add new fields GapWidth and Overlap in the Chart data type
- Add new fields ShowDataTable and ShowDataTableKeys fields in the ChartPlotArea data type
- Add new field Alignment in the ChartAxis data type
- Add new field DataLabel in the ChartSeries data type
- Add new field PageOrder for PageLayoutOptions data type
- Add 2 new exported error variables: ErrPageSetupAdjustTo and ErrStreamSetColStyle
- Add 2 new exported enumerations: HeaderFooterImagePositionType and IgnoredErrorsType
- Add 2 new exported data types: CalcPropsOptions and HeaderFooterImageOptions
- Add 2 new functions: SetCalcProps and GetCalcProps support setting and getting workbook calculation properties
- Add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values, support apply number format for the Japanese calendar years, the Korean Danki calendar and the Republic of China year, related issue 1885
- Add new function AddHeaderFooterImage to support set graphics in a header and footer, related issue 1395
- Add new function AddIgnoredErrors support to ignored error for a range of cells, related issue 2046
- Add new function SetColStyle for streaming writer to support set columns style, related issue 2075
- The AddChart and AddChartSheet function support set chart axis text direction and rotation, related issue 2025
- The AddChart and AddChartSheet function support set gap width and overlap for column and bar chart, related issue 2033
- The AddChart and AddChartSheet function support set the format of the chart series data label, related issue 2052
- The AddChart and AddChartSheet function support set data table for chart, related issue 2117
- The AddFormControl function support set cell link for check box, related issue 2113
- The SetPageLayout function support set page order of page layout
- The DeletePicture function support delete one cell anchor image, related issue 2059
- An error will be return if the option value of the SetPageLayout function is invalid
- Support adjust data validations cross multiple worksheets, related issue 2072
- Support apply number format with hash and zero place holder, related issue 2058
- Support apply number format with ? symbol
- Support to insert one cell anchor drawing object when specified the positioning as "oneCell", related issue 2002
- Fix a v2.9.0 regression bug, corrupted workbook generated by open the workbook generated by stream writer, resolve issue 2015
- Fix redundant none type pattern fill generated, resolve issue 2014
- Fix missing vertical and horizontal border styles in some case, resolve issue 2048
- Fix conditional format's border styles missing in some case, resolve issue 2061
- Fix get pivot tables panic in some case, resolve issues 1954 and 2051
- Fix GetStyle function can not get VertAlign format
- Fix CalcCellValue function subexpressions aren't correctly calculated in some case, resolve issue 2083
- Fix delete wrong images in some case which caused by image reference detection issue
- Fix cell default style doesn't override by none-zero row style when set row by stream writer
- Fix redundant cols element generated by stream writer
- Fix panic on set chart title font, resolve issue 2102
- Fix panic on delete calc chain in some case
- Fix incorrect formula calculation result caused by shared formula parse error, resolve issue 2056
- Fix corrupted workbook generated when an inner ZIP64 file size exceeds 4GB
- Fix sheet name error in defined name after rename sheet, resolve issue 2126
- Use a 3 times faster deepcopy library github.com/tiendc/go-deepcopy instead of github.com/mohae/deepcopy, related issue 2029
- Fix performance regression in v2.9.0, reduce trim cell value memory allocation for blank cells
- Improve performance for calculate formula when formula contains whole column and row reference
- Rows iterator speedup about 20%, memory allocation reduce about 10%
- The dependencies module has been updated
- Unit tests and godoc updated
- with multilingual: Arabic, German, English, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Chinese Simplified and Chinese Traditional, which has been updated.
- NPM package release update for WebAssembly / JavaScript support
- PyPI package release update for Python
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
- wushiling50
- imirkin (Ilia Mirkin)
- Juneezee (Eng Zer Jun)
- Arpelicy
- zhuhaicity (ZhuHaiCheng)
- xxf0512 (xxf)
- gypsy1234
- mengpromax (MengZhongYuan)
- hly-717
- kurtinge (Kurt Inge Smådal)
- IvanHristov98 (Ivan Hristov)
- artur-chopikian (Artur Chopikian)
- romanshevelev (Roman Shevelev)
- LZCZ
- hm3248
- moisespsena (Moises P. Sena)
- paolobarbolini (Paolo Barbolini)
- timesince
- shcabin
- tgulacsi (Tamás Gulácsi)
- R3dByt3 (R3dByt3)
- Now-Shimmer