-
Notifications
You must be signed in to change notification settings - Fork 593
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
fix(deps): update module github.com/xuri/excelize/v2 to v2.9.0 #5086
base: master
Are you sure you want to change the base?
Conversation
ℹ Artifact update noticeFile name: go.modIn order to perform the update(s) described in the table above, Renovate ran the
Details:
|
6b0344a
to
ccb2d00
Compare
fadc57e
to
42ac5f7
Compare
b1ba07b
to
2d7b9e5
Compare
Quality Gate passedIssues Measures |
87892ca
to
56ade96
Compare
7f48d53
to
8e1b263
Compare
10e4772
to
5a97e22
Compare
b9c9f86
to
2326d41
Compare
007a7e1
to
160a05d
Compare
e0c5619
to
a9bef61
Compare
999efcd
to
a326c4a
Compare
a326c4a
to
3a9d4e9
Compare
Quality Gate passedIssues Measures |
This PR contains the following updates:
v2.4.1
->v2.9.0
Release Notes
xuri/excelize (github.com/xuri/excelize/v2)
v2.9.0
Compare Source
We are pleased to announce the release of version 2.9.0. Featured are a handful of new areas of functionality and numerous bug fixes.
A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.
Release Notes
The most notable changes in this release are:
Breaking Change
ConditionalFormatOptions
structure fieldFormat
as a pointer, resolve issue #1867Notable Features
DeleteSlicer
andGetSlicers
, related issue #810MoveSheet
to support changing sheet order in the workbook, related issue #1076AutoFitIgnoreAspect
field in theGraphicOptions
data type support for fill the cell with the image and ignore its aspect ratioTickLabelPosition
field in theChartAxis
data type support for set label position of the chartShowAll
,InsertBlankRow
andNumFmt
field in thePivotTableField
data typeClassicLayout
,FieldPrintTitles
andItemPrintTitles
in thePivotTableOptions
data typeChartTickLabelPositionType
andPictureInsertType
ChartLineUnset
enumeration valueExtURIDataField
,ExtURIPivotField
,ExtURIPivotFilter
andExtURIPivotHierarchy
ErrPivotTableClassicLayout
MergeCell
function support clear slave cells value when merging cellsAddDataValidation
,DeleteDataValidation
andGetCellStyle
functions support concurrency safe, related issues #1825GetDataValidations
function support get data validations which storage in the extension lists, related issue #1835SetSheetName
function support case sensitivity, related issue #1856GetPictureCells
andGetPictures
functions support for get the cell images inserted by IMAGE formula function and absolute paths for picturesSetCellHyperLink
function support remove hyperlink byNone
linkType, related issue #1940AddChart
function support create combo chart with same types, related issue #1940AddChart
function support set line type of scatter chartAddPivotTable
function, related issue #1945Improve the Compatibility
Bug Fixes
CalcCellValue
function support calculate formula functions ISNUMBER, OR and FIND with matrix arguments, resolve issue #1819CalcCellValue
function calculation result round issue, resolve issue #1851CalcCellValue
function returns incorrect result of formula functions XIRR and XNPV, resolve issue #1989RemoveCol
returns error when deleting columns, resolve issue #1829r
attributeAddChart
function set axis format doesn't work in combo chart, resolve issue #1921AddChart
function set incorrect primary axis titles positionAddChart
function set secondary vertical axis title is not displayed, resolve issue #1926AddChart
function set line type of line chart does not workGetPivotTables
function returns incorrect data range, resolve issue #1937GetStyle
function panic when theme withoutsysClr
, resolve issue #1963GetCellRichText
function returns error when read cell without SST index, resolve issue #1999SetSheetVisible
function panic on none views sheet, resolve issue #1969Performance
GetRows
function, related issue #1874ColumnNumberToName
function performance, reduce about 50% memory usage and 50% time costMiscellaneous
Thank you
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
v2.8.1
Compare Source
We are pleased to announce the release of version 2.8.1. Featured are a handful of new areas of functionality and numerous bug fixes.
A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.
Release Notes
The most notable changes in this release are:
Breaking Change
golang.org/x/net
HeaderFooterOptions
structure fieldsAlignWithMargins
andScaleWithDoc
as a pointer, resolve issue #1645ShapeColor
Notable Features
SetCellUint
, related issue #1681GetPictureCells
for get all picture cells, related issue #1218GetConditionalStyle
for get the conditional format style definition, related issue #1690GetHeaderFooter
for get the worksheet header and footerAddSlicer
for adding table and pivot table slicersGetPivotTables
for get pivot tablesDeletePivotTable
for delete pivot tableName
field in thePivotTableOptions
to support specify pivot table nameChartLineType
enumeration to specify the chart line type, related issue #1706Border
field in theChart
data type to set the chart area borderType
field in theChartLine
type to set the line typeNameSpaceSpreadSheetXR10
,ContentTypeSlicer
,ContentTypeSlicerCache
, andSourceRelationshipSlicer
ExtURIPivotCacheDefinition
SetRowHeight
functionSetRowHeight
function will return an error if given an invalid row height valueAddChart
function support set the data labels position for the chart, related issue #1704AddChart
function support set solid color or transparent fill for chart area, plot area, and maker, add a new fieldFill
inChart
,ChartPlotArea
, andChartMarker
data type, related issue #1786AddChart
function support set chart axis font family, size and strike style, related issue #1809DataLabelPosition
in theChartSeries
data type, support to sets the position of the chart series data labelBubbleSize
in theChart
data type, support set the bubble size in all data series for the bubble chart or 3D bubble chartChartDataLabelPositionType
data typeGetPictureCells
andGetPictures
function support get embedded cell images created by Kingsoft WPS™ Office, related issue #664SetConditionalFormat
function support set conditional formatting with multiple cell ranges, related issue #1783GetBaseColor
function support get the preferred hex color code, related issue #1794Options
settings of theOpenReader
, related issue #1815Improve the Compatibility
Bug Fixes
AutoFilter
by adding nil pointer guard for local sheet ID, resolve issue #1655r
attribute, resolve issue #1723GetCellRichText
returns error on getting inline rich text cellsGetConditionalFormats
panic on get conditional format without above average rules, resolve issue #1745SetConditionalFormat
function creates incorrect multiple conditional formats rules priority, resolve issue #1770GetConditionalFormats
function doesn't return gradient data bar rule, resolve issue #1769GetStyle
orGetConditionalStyle
function to returns incorrectDecimalPlaces
field value, resolve issue #1777CalcCellValue
function does not return raw value when enableRawCellValue
, resolve issue #1803Performance
Miscellaneous
Thank you
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
v2.8.0
Compare Source
We are pleased to announce the release of version 2.8.0. Featured are a handful of new areas of functionality and numerous bug fixes.
A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.
Release Notes
The most notable changes in this release are:
Breaking Change
ErrTableNameLength
toErrNameLength
PaneOptions
toSelection
Runs
field toParagraph
in the exportedComment
data typeLang
field in theStyle
data typeChartTitle
data type, and using theRichTextRun
data type instead of itDecimalPlaces
to pointer of integerAddShape
function signature:func (f *File) AddShape(sheet, cell string, opts *Shape) error
tofunc (f *File) AddShape(sheet string, opts *Shape) error
Notable Features
ErrExistsTableName
andErrorFormControlValue
ShortDatePattern
,LongDatePattern
,LongTimePattern
andCultureInfo
in theOptions
data type, related issue #1199CultureName
enumeration for country codeGetTables
andDeleteTable
support to get and remove tables, related issues #674 and #1454GetStyle
support to get style definitions, related issues #314, #1520 and #1521GetPanes
support to get sheet panes and view selectionAddFormControl
,GetFormControls
andDeleteFormControl
support to form controls, related issues #301 and #1169AddChart
function support set primary titles, related issue #1553AddChart
function support creating chart with a secondary series axis, related issue #518AddChart
function support formatting and setting rich text titles for the chart, related issue #1588AddShape
function, an error will be returned if no shape type is specifiedGetPictures
function support read one cell anchor pictures, related issue #1585NewConditionalStyle
function support to create a conditional format with number format and protection, related issue #1610Improve the Compatibility
Bug Fixes
Performance
Miscellaneous
xlsxTabColor
data type, using thexlsxColor
data type instead ofxlsxTabColor
Thank you
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
v2.7.1
Compare Source
We are pleased to announce the release of version 2.7.1. Featured are a handful of new areas of functionality and numerous bug fixes.
A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.
Release Notes
The most notable changes in this release are:
Breaking Change
Color
field in theChartLine
data typeShapeParagraph
withRichTextRun
Color
field from the typeShape
, and uses theFill
instead of itAutoFilterListOptions
TableOptions
toTable
AddChart
function require usingChartType
enumeration value to specify the chart typefunc (f *File) AutoFilter(sheet, rangeRef string, opts *AutoFilterOptions) error
tofunc (f *File) AutoFilter(sheet, rangeRef string, opts []AutoFilterOptions) error
func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *GraphicOptions) error
tofunc (f *File) AddPictureFromBytes(sheet, cell string, pic *Picture) error
func (f *File) GetPicture(sheet, cell string) (string, []byte, error)
tofunc (f *File) GetPictures(sheet, cell string) ([]Picture, error)
func (f *File) AddVBAProject(bin string) error
tofunc (f *File) AddVBAProject(file []byte) error
func (f *File) GetComments() (map[string][]Comment, error)
tofunc (f *File) GetComments(sheet string) ([]Comment, error)
func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error
tofunc (f *File) AddTable(sheet string, table *Table) error
func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error
tofunc (sw *StreamWriter) AddTable(table *Table) error
Notable Features
SetSheetDimension
andGetSheetDimension
for workbook dimension supports, related issue #1463NewStyle
function support to create of 17 kinds of fill variants stylesAddPicture
function allowing insert BMP format imagesGetPictures
function support to get multiple images in a cellSetConditionalFormat
function support to creating a conditional format with a "stop if true" or "icon sets" ruleSetConditionalFormat
function support to set border color and create solid color for the color data bar, related issue #1462AddChart
function support to set the format for the chart data series solid fill, related issue #1474AddChart
function support to set the bubble size in a data seriesAddChart
function support to specifies the values in second plot for the bar/pie of pie chartAddChart
function support to set number format for chart data labels and axis, related issue #1499AddTable
function support to specify if show header row of the table when create the tableAddTable
function support to validate table name, and added a new error constantErrTableNameLength
, related issue #1468AutoFilter
function support to add multiple filter columns when create auto filterCalcCellValue
function support to specify if applying number format style for the cell calculation resultCalcCellValue
function support double-byte chars for formula functions: LEFT, LEN, LENB, MID, MIDB, RIGHT and RIGHTB, related issue #1476CalcCellValue
function now returns formula error string in the result, and using the error message in returns error, related issue #1490GetCellHyperLink
function support get cell hyperlink for merged cellsChartType
for represents chart type enumerationImprove the Compatibility
Bug Fixes
Performance
Miscellaneous
Thank you
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
v2.7.0
Compare Source
We are pleased to announce the release of version 2.7.0. Featured are a handful of new areas of functionality and numerous bug fixes.
A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.
Release Notes
The most notable changes in this release are:
Breaking Change
ioutil
GetCellStyle
function no longer return master cell style of the merge cell rangePivotTableOption
toPivotTableOptions
FormatHeaderFooter
toHeaderFooterOptions
FormatSheetProtection
toSheetProtectionOptions
SparklineOption
toSparklineOptions
ErrExistsWorksheet
toErrExistsSheet
AutoPageBreaks
,BaseColWidth
,BlackAndWhite
,CodeName
,CustomHeight
,Date1904
,DefaultColWidth
,DefaultGridColor
,DefaultRowHeight
,EnableFormatConditionsCalculation
,FilterPrivacy
,FirstPageNumber
,FitToHeight
,FitToPage
,FitToWidth
,OutlineSummaryBelow
,PageLayoutOption
,PageLayoutOptionPtr
,PageLayoutOrientation
,PageLayoutPaperSize
,PageLayoutScale
,PageMarginBottom
,PageMarginFooter
,PageMarginHeader
,PageMarginLeft
,PageMarginRight
,PageMarginsOptions
,PageMarginsOptionsPtr
,PageMarginTop
,Published
,RightToLeft
,SheetFormatPrOptions
,SheetFormatPrOptionsPtr
,SheetPrOption
,SheetPrOptionPtr
,SheetViewOption
,SheetViewOptionPtr
,ShowFormulas
,ShowGridLines
,ShowRowColHeaders
,ShowRuler
,ShowZeros
,TabColorIndexed
,TabColorRGB
,TabColorTheme
,TabColorTint
,ThickBottom
,ThickTop
,TopLeftCell
,View
,WorkbookPrOption
,WorkbookPrOptionPtr
,ZeroHeight
andZoomScale
OrientationPortrait
andOrientationLandscape
func (f *File) SetPageLayout(sheet string, opts ...PageLayoutOption) error
tofunc (f *File) SetPageLayout(sheet string, opts *PageLayoutOptions) error
func (f *File) GetPageLayout(sheet string, opts ...PageLayoutOptionPtr) error
tofunc (f *File) GetPageLayout(sheet string) (PageLayoutOptions, error)
func (f *File) SetPageMargins(sheet string, opts ...PageMarginsOptions) error
tofunc (f *File) SetPageMargins(sheet string, opts *PageLayoutMarginsOptions) error
func (f *File) GetPageMargins(sheet string, opts ...PageMarginsOptionsPtr) error
tofunc (f *File) GetPageMargins(sheet string) (PageLayoutMarginsOptions, error)
func (f *File) GetSheetIndex(sheet string) int
tofunc (f *File) GetSheetIndex(sheet string) (int, error)
func (f *File) SetSheetName(source, target string)
tofunc (f *File) SetSheetName(source, target string) error
func (f *File) GetSheetVisible(sheet string) bool
tofunc (f *File) GetSheetVisible(sheet string) (bool, error)
func (f *File) DeleteSheet(sheet string)
tofunc (f *File) DeleteSheet(sheet string) error
func (f *File) NewSheet(sheet string) int
tofunc (f *File) NewSheet(sheet string) (int, error)
func (f *File) NewConditionalStyle(style string) (int, error)
tofunc (f *File) NewConditionalStyle(style *Style) (int, error)
func (f *File) NewStyle(style interface{}) (int, error)
tofunc (f *File) NewStyle(style *Style) (int, error)
func (f *File) AddChart(sheet, cell, opts string, combo ...string) error
tofunc (f *File) AddChart(sheet, cell string, chart *ChartOptions, combo ...*ChartOptions) error
func (f *File) AddChartSheet(sheet, opts string, combo ...string) error
tofunc (f *File) AddChartSheet(sheet string, chart *ChartOptions, combo ...*ChartOptions) error
func (f *File) AddShape(sheet, cell, opts string) error
tofunc (f *File) AddShape(sheet, cell string, opts *Shape) error
func (f *File) AddPicture(sheet, cell, picture, format string) error
tofunc (f *File) AddPicture(sheet, cell, picture string, opts *GraphicOptions) error
func (f *File) AddPictureFromBytes(sheet, cell, opts, name, extension string, file []byte) error
tofunc (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *GraphicOptions) error
func (f *File) AddTable(sheet, hCell, vCell, opts string) error
tofunc (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error
func (sw *StreamWriter) AddTable(hCell, vCell, opts string) error
tofunc (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error
func (f *File) AutoFilter(sheet, hCell, vCell, opts string) error
tofunc (f *File) AutoFilter(sheet, rangeRef string, opts *AutoFilterOptions) error
func (f *File) SetPanes(sheet, panes string) error
tofunc (f *File) SetPanes(sheet string, panes *Panes) error
func (f *File) SetConditionalFormat(sheet, reference, opts string) error
tofunc (f *File) SetConditionalFormat(sheet, rangeRef string, opts []ConditionalFormatOptions) error
SetSheetProps
instead ofSetSheetPrOptions
andSetSheetFormatPr
GetSheetProps
instead ofGetSheetPrOptions
andGetSheetFormatPr
SetSheetView
instead ofSetSheetViewOptions
GetSheetView
instead ofGetSheetViewOptions
SetWorkbookProps
instead ofSetWorkbookPrOptions
GetWorkbookProps
instead ofGetWorkbookPrOptions
InsertRows
instead ofInsertRow
for support inserting multiple rows at onceInsertCols
instead ofInsertCol
for support inserting multiple columns at onceCellTypeFormula
,CellTypeInlineString
,CellTypeSharedString
and removeCellTypeString
inCellType
enumerationAddComment
function, support create rich-text in comments, related issue #1204GetComments
,GetDefaultFont
andSetDefaultFont
functionsNotable Features
GetDataValidations
andGetConditionalFormats
for get data validations and conditional formats, related issue #827ProtectWorkbook
andUnprotectWorkbook
for workbook protection supportsSetSheetCol
for set worksheet column cells, related issue #1247GetColStyle
for get column styles, related issue #1293SetSheetBackgroundFromBytes
for set background picture by given image data, related issue #1405IndexedColorMapping
AutoFilterListOptions
,AutoFilterOptions
,Chart
,ChartAxis
,ChartDimension
,ChartLegend
,ChartLine
,ChartMarker
,ChartPlotArea
,ChartSeries
,ChartTitle
,ConditionalFormatOptions
,PaneOptions
,Panes
,GraphicOptions
,Shape
,ShapeColor
,ShapeLine
,ShapeParagraph
andTableOptions
Save
,Write
andWriteTo
function now accept saving options, related issue #744AddChart
function support specify if smooth line of the line chart, related issue #1290AddChart
function support set custom line color in the charts, related issue #1345AddChart
function support custom chart axis font style, related issue #320AddChart
function support create 3D line chartSetColWidth
,GetColWidth
,SetColVisible
,GetColVisible
,SetColStyle
andGetColStyle
now support concurrency safeRowOpts
for each cell, related issue #1354ErrUnprotectWorkbook
,ErrUnprotectWorkbookPassword
,ErrStreamSetPanes
,ErrSheetNameBlank
,ErrSheetNameInvalid
,ErrSheetNameLength
andErrSheetNameSingleQuote
has been addedHeaderFooterOptions
,PageLayoutMarginsOptions
,PageLayoutOptions
,SheetPropsOptions
, andViewOptions
Close
function now support cleanup stream writer temporary filesAddPicture
function now allowing insert SVG format imagesImprove the Compatibility
Bug Fixes
OR
functionPerformance
SetRow
function, reduces memory usage over and speedup about 19%Miscellaneous
Thank you
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR is behind base branch, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR was generated by Mend Renovate. View the repository job log.