Bot releases are visible (Hide)
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.
The most notable changes in this release are:
golang.org/x/net
HeaderFooterOptions
structure fields AlignWithMargins
and ScaleWithDoc
as a pointer, resolve issue #1645
ShapeColor
SetCellUint
, related issue #1681
GetPictureCells
for get all picture cells, related issue #1218
GetConditionalStyle
for get the conditional format style definition, related issue #1690
GetHeaderFooter
for get the worksheet header and footerAddSlicer
for adding table and pivot table slicersGetPivotTables
for get pivot tablesDeletePivotTable
for delete pivot tableName
field in the PivotTableOptions
to support specify pivot table nameChartLineType
enumeration to specify the chart line type, related issue #1706
Border
field in the Chart
data type to set the chart area borderType
field in the ChartLine
type to set the line typeNameSpaceSpreadSheetXR10
, ContentTypeSlicer
, ContentTypeSlicerCache
, and SourceRelationshipSlicer
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 #1704
AddChart
function support set solid color or transparent fill for chart area, plot area, and maker, add a new field Fill
in Chart
, ChartPlotArea
, and ChartMarker
data type, related issue #1786
AddChart
function support set chart axis font family, size and strike style, related issue #1809
DataLabelPosition
in the ChartSeries
data type, support to sets the position of the chart series data labelBubbleSize
in the Chart
data type, support set the bubble size in all data series for the bubble chart or 3D bubble chartChartDataLabelPositionType
data typeGetPictureCells
and GetPictures
function support get embedded cell images created by Kingsoft WPS™ Office, related issue #664
SetConditionalFormat
function support set conditional formatting with multiple cell ranges, related issue #1783
GetBaseColor
function support get the preferred hex color code, related issue #1794
Options
settings of the OpenReader
, related issue #1815
AutoFilter
by adding nil pointer guard for local sheet ID, resolve issue #1655
r
attribute, resolve issue #1723
GetCellRichText
returns error on getting inline rich text cellsGetConditionalFormats
panic on get conditional format without above average rules, resolve issue #1745
SetConditionalFormat
function creates incorrect multiple conditional formats rules priority, resolve issue #1770
GetConditionalFormats
function doesn't return gradient data bar rule, resolve issue #1769
GetStyle
or GetConditionalStyle
function to returns incorrect DecimalPlaces
field value, resolve issue #1777
CalcCellValue
function does not return raw value when enable RawCellValue
, resolve issue #1803
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
Published by xuri about 1 year ago
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.
The most notable changes in this release are:
ErrTableNameLength
to ErrNameLength
PaneOptions
to Selection
Runs
field to Paragraph
in the exported Comment
data typeLang
field in the Style
data typeChartTitle
data type, and using the RichTextRun
data type instead of itDecimalPlaces
to pointer of integerAddShape
function signature: func (f *File) AddShape(sheet, cell string, opts *Shape) error
to func (f *File) AddShape(sheet string, opts *Shape) error
ErrExistsTableName
and ErrorFormControlValue
ShortDatePattern
, LongDatePattern
, LongTimePattern
and CultureInfo
in the Options
data type, related issue #1199CultureName
enumeration for country codeGetTables
and DeleteTable
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
and DeleteFormControl
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 #1610xlsxTabColor
data type, using the xlsxColor
data type instead of xlsxTabColor
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
Published by xuri over 1 year ago
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.
The most notable changes in this release are:
Color
field in the ChartLine
data typeShapeParagraph
with RichTextRun
Color
field from the type Shape
, and uses the Fill
instead of itAutoFilterListOptions
TableOptions
to Table
AddChart
function require using ChartType
enumeration value to specify the chart typefunc (f *File) AutoFilter(sheet, rangeRef string, opts *AutoFilterOptions) error
to func (f *File) AutoFilter(sheet, rangeRef string, opts []AutoFilterOptions) error
func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *GraphicOptions) error
to func (f *File) AddPictureFromBytes(sheet, cell string, pic *Picture) error
func (f *File) GetPicture(sheet, cell string) (string, []byte, error)
to func (f *File) GetPictures(sheet, cell string) ([]Picture, error)
func (f *File) AddVBAProject(bin string) error
to func (f *File) AddVBAProject(file []byte) error
func (f *File) GetComments() (map[string][]Comment, error)
to func (f *File) GetComments(sheet string) ([]Comment, error)
func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error
to func (f *File) AddTable(sheet string, table *Table) error
func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error
to func (sw *StreamWriter) AddTable(table *Table) error
SetSheetDimension
and GetSheetDimension
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 constant ErrTableNameLength
, 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 enumerationThanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
Published by xuri almost 2 years ago
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.
The most notable changes in this release are:
ioutil
GetCellStyle
function no longer return master cell style of the merge cell rangePivotTableOption
to PivotTableOptions
FormatHeaderFooter
to HeaderFooterOptions
FormatSheetProtection
to SheetProtectionOptions
SparklineOption
to SparklineOptions
ErrExistsWorksheet
to ErrExistsSheet
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
and ZoomScale
OrientationPortrait
and OrientationLandscape
func (f *File) SetPageLayout(sheet string, opts ...PageLayoutOption) error
to func (f *File) SetPageLayout(sheet string, opts *PageLayoutOptions) error
func (f *File) GetPageLayout(sheet string, opts ...PageLayoutOptionPtr) error
to func (f *File) GetPageLayout(sheet string) (PageLayoutOptions, error)
func (f *File) SetPageMargins(sheet string, opts ...PageMarginsOptions) error
to func (f *File) SetPageMargins(sheet string, opts *PageLayoutMarginsOptions) error
func (f *File) GetPageMargins(sheet string, opts ...PageMarginsOptionsPtr) error
to func (f *File) GetPageMargins(sheet string) (PageLayoutMarginsOptions, error)
func (f *File) GetSheetIndex(sheet string) int
to func (f *File) GetSheetIndex(sheet string) (int, error)
func (f *File) SetSheetName(source, target string)
to func (f *File) SetSheetName(source, target string) error
func (f *File) GetSheetVisible(sheet string)
to func (f *File) GetSheetVisible(sheet string) (bool, error)
func (f *File) DeleteSheet(sheet string)
to func (f *File) DeleteSheet(sheet string) error
func (f *File) NewSheet(sheet string) int
to func (f *File) NewSheet(sheet string) (int, error)
func (f *File) NewConditionalStyle(style string) (int, error)
to func (f *File) NewConditionalStyle(style *Style) (int, error)
func (f *File) NewStyle(style interface{}) (int, error)
to func (f *File) NewStyle(style *Style) (int, error)
func (f *File) AddChart(sheet, cell, opts string, combo ...string) error
to func (f *File) AddChart(sheet, cell string, chart *ChartOptions, combo ...*ChartOptions) error
func (f *File) AddChartSheet(sheet, opts string, combo ...string) error
to func (f *File) AddChartSheet(sheet string, chart *ChartOptions, combo ...*ChartOptions) error
func (f *File) AddShape(sheet, cell, opts string) error
to func (f *File) AddShape(sheet, cell string, opts *Shape) error
func (f *File) AddPicture(sheet, cell, picture, format string) error
to func (f *File) AddPicture(sheet, cell, picture string, opts *GraphicOptions) error
func (f *File) AddPictureFromBytes(sheet, cell, opts, name, extension string, file []byte) error
to func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *GraphicOptions) error
func (f *File) AddTable(sheet, hCell, vCell, opts string) error
to func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error
func (sw *StreamWriter) AddTable(hCell, vCell, opts string) error
to func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error
func (f *File) AutoFilter(sheet, hCell, vCell, opts string) error
to func (f *File) AutoFilter(sheet, rangeRef string, opts *AutoFilterOptions) error
func (f *File) SetPanes(sheet, panes string) error
to func (f *File) SetPanes(sheet string, panes *Panes) error
func (f *File) SetConditionalFormat(sheet, reference, opts string) error
to func (f *File) SetConditionalFormat(sheet, rangeRef string, opts []ConditionalFormatOptions) error
SetSheetProps
instead of SetSheetPrOptions
and SetSheetFormatPr
GetSheetProps
instead of GetSheetPrOptions
and GetSheetFormatPr
SetSheetView
instead of SetSheetViewOptions
GetSheetView
instead of GetSheetViewOptions
SetWorkbookProps
instead of SetWorkbookPrOptions
GetWorkbookProps
instead of GetWorkbookPrOptions
InsertRows
instead of InsertRow
for support inserting multiple rows at onceInsertCols
instead of InsertCol
for support inserting multiple columns at onceCellTypeFormula
, CellTypeInlineString
, CellTypeSharedString
and remove CellTypeString
in CellType
enumerationAddComment
function, support create rich-text in comments, related issue #1204
GetComments
, GetDefaultFont
and SetDefaultFont
functionsGetDataValidations
and GetConditionalFormats
for get data validations and conditional formats, related issue #827
ProtectWorkbook
and UnprotectWorkbook
for workbook protection supportsSetSheetCol
for set worksheet column cells, related issue #1247
GetColStyle
for get column styles, related issue #1293
SetSheetBackgroundFromBytes
for set background picture by given image data, related issue #1405
IndexedColorMapping
AutoFilterListOptions
, AutoFilterOptions
, Chart
, ChartAxis
, ChartDimension
, ChartLegend
, ChartLine
, ChartMarker
, ChartPlotArea
, ChartSeries
, ChartTitle
, ConditionalFormatOptions
, PaneOptions
, Panes
, GraphicOptions
, Shape
, ShapeColor
, ShapeLine
, ShapeParagraph
and TableOptions
Save
, Write
and WriteTo
function now accept saving options, related issue #744
AddChart
function support specify if smooth line of the line chart, related issue #1290
AddChart
function support set custom line color in the charts, related issue #1345
AddChart
function support custom chart axis font style, related issue #320
AddChart
function support create 3D line chartSetColWidth
, GetColWidth
, SetColVisible
, GetColVisible
, SetColStyle
and GetColStyle
now support concurrency safeRowOpts
for each cell, related issue #1354
ErrUnprotectWorkbook
, ErrUnprotectWorkbookPassword
, ErrStreamSetPanes
, ErrSheetNameBlank
, ErrSheetNameInvalid
, ErrSheetNameLength
and ErrSheetNameSingleQuote
has been addedHeaderFooterOptions
, PageLayoutMarginsOptions
, PageLayoutOptions
, SheetPropsOptions
, and ViewOptions
Close
function now support cleanup stream writer temporary filesAddPicture
function now allowing insert SVG format imagesOR
functionSetRow
function, reduces memory usage over and speedup about 19%Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
Published by xuri about 2 years ago
We are pleased to announce the release of version 2.6.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.
The most notable changes in this release are:
TabColor
to TabColorRGB
TotalColumns
to MaxColumns
ErrMaxFileNameLength
to ErrMaxFilePathLength
ErrWorkbookExt
to ErrWorkbookFileFormat
ErrEncrypt
DeleteComment
support to delete comment, related issue #849
AddShape
function now support assigning a macro to the shapeAddPicture
function now allowing insert EMF, WMF, EMZ and WMZ format images, related issue #1225
ErrWorkbookPassword
for the error message on receiving the incorrect workbook passwordMinFontSize
, MinColumns
and MaxCellStyles
RichTextRun
support set superscript and subscript by vertAlign
attributeDeleteDataValidation
function support deleting all data validations in the worksheet, related issue #1254
MaxCalcIterations
for specifies the maximum iterations for iterative calculationColorMappingType
for color transformation types enumerationGetRowOpts
for rows iterator, to support get rows properties, related issue #1296
AddComment
function, resolve issue #1310
Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:
Published by xuri over 2 years ago
We are pleased to announce the release of version 2.6.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.
The most notable changes in this release are:
NameSpaceDublinCoreMetadataIntiative
to NameSpaceDublinCoreMetadataInitiative
for typo fixErrUnsupportEncryptMechanism
to ErrUnsupportedEncryptMechanism
ErrDataValidationFormulaLenth
to ErrDataValidationFormulaLength
ErrDefinedNameduplicate
to ErrDefinedNameDuplicate
XMLHeaderByte
isCurrentSheet
and error returns of the function SetSqrefDropList
TotalRows
of row iteratorProtectSheet
now support protect sheet with specify algorithm: XOR, MD4, MD5, SHA1, SHA256, SHA384, and SHA512UnprotectSheet
now support specified the second optional password parameter to remove sheet protection with password verificationSetWorkbookPrOptions
and GetWorkbookPrOptions
to support setting and getting the FilterPrivacy
and CodeName
properties of the workbook, resolve limitations when adding VBA project to the workbook, related issue #1148AddChart
function, resolve issue #1172ErrPasswordLengthInvalid
, ErrUnsupportedHashAlgorithm
, ErrUnsupportedNumberFormat
, ErrWorkbookExt
so users can act differently on the different type of errorsSetCellDefault
support non-numeric value, resolve issue #1139Published by xuri almost 3 years ago
We are pleased to announce the release of version 2.5.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.
The most notable changes in this release are:
ReadZipReader
as an implementation of the File
, extract spreadsheet with given options, and support extract in memory or touching the filesystemXMLHeader
, we can using encoding/xml
package's xml.Header
instead of itErrToExcelTime
SetRowStyle
support for set style for the rows, related issue #990GetCellType
support for get the cell's data type, related issue #417 and #520SetAppProps
and GetAppProps
support to set and get document application properites, related issue #1095GetCellValue
, GetRows
, GetCols
, Rows
and Cols
support to specify read cell with raw value, related issue #621IF
formula, related issue #987SetCellFormula
now support set the shared formulaUpdateLinkedValue
will skip macro sheet, related issue #1014AddPicture
created duplicate image in some cases, caused by incorrect internal relationships ID calculation, related issue #1017AddShape
support set line width of add the shape, related issue #262UnzipXMLSizeLimit
have been added, support to specifies the memory limit on unzipping worksheet and shared string table in bytesr="0"
attributeLOOKUP
doesn't handle array form correctly, resolve issue #994LOOKUP
can only find exact match, resolve issue #997NewStyle
returned incorrect style ID in some casePublished by xuri about 3 years ago
We are pleased to announce the release of version 2.4.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.
The most notable changes in this release are:
Change Go Modules import path to github.com/xuri/excelize/v2
AddPivotTable
support reference source data range by defined name, relate issue #856
AddPicture
and GetPicture
concurrency insert or get the picture from the worksheetRows
and Cols
concurrency iterate rows and columnsSetSheetRow
concurrency set cells for a row in the worksheetSetCellStyle
concurrency set cell styleNewStyle
concurrency create the styleFile.XLSX
to File.Pkg
NewSheet
, GetSheetIndex
, DeleteSheet
, resolve issue #873
SetCellRichText
GetComments
in some case, resolve issue #825
showOutlineSymbols
, summaryBelow
and summaryRight
attributes are false
GetRows
, resolve issue #842
GetRowHeight
actually get the height of the next rowLocalSheetID
in the defined name should be equal to SheetIndex
instead of SheetID
PivotTableRange
on creating a pivot tablePublished by xuri over 3 years ago
We are pleased to announce the release of version 2.4.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.
The most notable changes in this release are:
Upgrade requirements Go language version is 1.15 or later.
GetCellRichText
support to get the rich text of cell by given worksheetSetPageLayout
and GetPageLayout
SetSheetPrOptions
and GetSheetPrOptions
SetCellHyperlink
now support to set hyperlink display & tooltips text, related issue #790ShowError
option when adding the pivot tableSetCellValue
with nil
, resolve issue #756omitempty
tag on style pattern fill colornewFills
and parseToken
UpdateLinkedValue
which returns an error when has chart sheet or dialog sheetGetColWidth
in some caselocalSheetId
attribute to use sheetIndex
Published by xuri almost 4 years ago
We are pleased to announce the release of version 2.3.2. 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.
The most notable changes in this release are:
AddPivotTable
now support none-column and multi-data fields, relate issue #710GetCellValue
support custom date-time number format, relate issue #703CalcCellValue
now support new formula function AND
, CLEAN
, TRIM
, LOWER
, PROPER
, UPPER
and OR
, relate issue #701 and #747AddChart
now support to set marker type and custom line width, relate issue #549 and #657NewSheet
in some cases, resolve issue #714AddPicture
autofit failure with multi merged cells, resolve issue #748workSheetWriter
, relate issue #722AddPicture
performance, relate issue #706Published by xuri about 4 years ago
We are pleased to announce the release of version 2.3.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.
The most notable changes in this release are:
RemoveRow
slice bounds out of range cause panic in some case, resolve #686Published by xuri about 4 years ago
We are pleased to announce the release of version 2.3.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.
The most notable changes in this release are:
SetSheetFormatPr
and GetSheetFormatPr
, support to set and get worksheet formatting properties, relate issue #635GetCols
and Cols
, support columns iteratorAddChart
support specified logarithmic scale on Y-axis, relate issue #661AddPicture
support insert image autofit cellCalcCellValue
update, formula calculation engine working in progress: 12 new functions has been added, COUNTA
, ISBLANK
, ISERR
, ISERROR
, ISEVEN
, ISNA
, ISNONTEXT
, ISODD
, ISNUMBER
, MEDIAN
, NA
, SUMIF
row
element without r
attribute in the worksheetPublished by xuri over 4 years ago
We are pleased to announce the release of version 2.2.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.
The most notable changes in this release are:
GetSheetName
, GetSheetIndex
, GetActiveSheetIndex
and SetActiveSheet
, relate issue #485GetSheetList
to get the worksheet, chart sheet, and dialog sheet name list of the workbookAddChartSheet
support create chart sheet, relate issue #451UnsetConditionalFormat
, support for remove conditional format, relate issue #571DeleteDataValidation
, support delete data validation, relate issue #348SetCellRichText
, support set rich text, relate issue #172InsertPageBreak
and RemovePageBreak
, support for insert and remove page break, relate issue #492AddPivotTable
API changed, support for setting date field subtotal and names of the pivot table, relate issue #582AddPivotTable
support to set the filter for the pivot table, relate issue #598AddPivotTable
allow empty filter, data, and rows in the pivot tableExcelDateToTime
function to convert excel date to timeStyle
structs to allow create the style for cells by given JSON or structure pointer, relate issue #470greaterThanOrEqual
and lessThanOrEqual
operators did not work when setting the conditional format for cell by SetConditionalFormat
, resolve issue #608StreamWriter
, resolve issue #576DuplicateRowTo
function doesn't duplicate merged cells, resolve issue #586GetComments
, resolve issue #345GetCellValue
in some case, resolve issue #602r
attribute in a row element, fix returned empty value when GetCellValue
in some casegetRowHeight
Published by xuri over 4 years ago
We are pleased to announce the release of version 2.1.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.
The most notable changes in this release are:
DeleteDefinedName
, support to delete the defined names of the workbook or worksheetSetPageMargins
and GetPageMargins
, support to for getting setting page marginsDeleteChart
and DeletePicture
, support to delete chart and images from the worksheetAddChart
now support to create the pie of pie chart, the bar of pie chart and combo chartAddChart
now support to set minor grid lines for the chart, relate issue #501AddChart
now support to set line width of the line chart, relate issue #505AddChart
now support to set a major unit and tick label skip for the chart, relate issue #538SetColVisible
now support to set column visible by column rangeAddPivotTable
allow empty columns in the pivot table, relate issue #511MergeCell
function support overlapped merge cells, resolve issue #533NewStreamWriter
and Flush
to generate the new worksheet with huge amounts of data. Compared to non-streaming writing, reduced memory usage by 90.2%, time cost by 53%GetRows
function read data as streaming. Reduced memory usage by 78.9%, relate issues #146 and #382Published by xuri about 5 years ago
We are pleased to announce the release of version 2.0.2. 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 change log.
The most notable changes in this release are:
Upgrade requirements Go language version is 1.10 or later.
AddPivotTable()
has been addedAddSparkline()
has been addedGroupSheets()
and UngroupSheets()
support group and ungroup sheetsAddVBAProject()
to support add vbaProject.bin file which contains functions and/or macrosSetPageLayout()
now support to support to set fit to width and height, relate issue #432SetSheetViewOptions()
support to set whether to "show a zero in cells that have zero value" nowSetCellFormula()
, support set the type of the formula and the ref attributeRemoveRow()
out of range in some case by recalculate offset for merged cells adjuster, resolve issue #437Save()
method in the iteration, resolve issue #443workbook.xml.rels
to fix read file failed in some case, resolve issue #442GetSheetName
doesn't work in some case by check the sheets list based on index instead, resolve issue #457SetSheetPrOptions()
in some case, resolve issue #483SetSheetRow()
workBookRelsWriter
, drawingRelsWriter
into relsWriter
;drawingRelsReader
, workbookRelsReader
, workSheetRelsReader
into relsReader
addDrawingRelationships
, addSheetRelationships
into addRels
Published by xuri over 5 years ago
We are pleased to announce the release of version 2.0.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 change log.
The most notable changes in this release are:
SetHeaderFooter()
init set header and footer support, relate issue #394SetColStyle()
support to set style by columns, relate issue #397SetDefaultFont()
and GetDefaultFont()
support to change the default font, relate issue #390SetDocProps()
and GetDocProps()
, support to set and get doc properties, relate issue #415AddChart()
now support to create new 26 types of chart: cone, pyramid and cylinder series chart for column and bar, surface 3D, wireframe Surface 3D, contour and wireframe contour,bubble and a 3D bubble chart, unsupported chart type add error promptSetDefinedName()
and GetDefinedName()
support to set and get defined namesAddPicture()
now support to add TIF and TIFF format imagesPublished by xuri over 5 years ago
We are pleased to announce the release of version 2.0.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 change log.
The most notable changes in this release are:
The following table lists the changes to the functions for v2.0.0 compared to the v1.4.1:
Function | Add error return |
Row Number Change* | Delete | New Addition |
---|---|---|---|---|
ToALphaString | × | × | √ | × |
TitleToNumber | × | × | √ | × |
SplitCellName | × | × | × | √ |
JoinCellName | × | × | × | √ |
ColumnNameToNumber | × | × | × | √ |
ColumnNumberToName | × | × | × | √ |
CellNameToCoordinates | × | × | × | √ |
CoordinatesToCellName | × | × | × | √ |
SetCellFloat | × | × | × | √ |
SetCellStyle | √ | × | × | × |
InsertCol | √ | × | × | × |
RemoveCol | √ | × | × | × |
RemoveRow | √ | √ | × | × |
InsertRow | √ | √ | × | × |
DuplicateRow | √ | × | × | × |
DuplicateRowTo | √ | × | × | × |
SetRowHeight | √ | × | × | × |
GetRowHeight | √ | × | × | × |
GetCellValue | √ | × | × | × |
GetCellFormula | √ | × | × | × |
GetCellHyperLink | √ | × | × | × |
SetCellHyperLink | √ | × | × | × |
SetCellInt | √ | × | × | × |
SetCellBool | √ | × | × | × |
SetCellStr | √ | × | × | × |
SetCellDefault | √ | × | × | × |
GetCellStyle | √ | × | × | × |
SetCellValue | √ | × | × | × |
MergeCell | √ | × | × | × |
SetSheetRow | √ | × | × | × |
SetRowVisible | √ | √ | × | × |
GetRowVisible | √ | √ | × | × |
SetRowOutlineLevel | √ | √ | × | × |
GetRowOutlineLevel | √ | √ | × | × |
GetRows | √ | × | × | × |
Columns | √ | × | × | × |
SearchSheet | √ | × | × | × |
GetPicture | √ | × | × | × |
GetColVisible | √ | × | × | × |
SetColVisible | √ | × | × | × |
GetColOutlineLevel | √ | × | × | × |
SetColOutlineLevel | √ | × | × | × |
SetColWidth | √ | × | × | × |
GetColWidth | √ | × | × | × |
GetMergeCells | √ | × | × | × |
ProtectSheet | √ | × | × | × |
UnprotectSheet | √ | × | × | × |
UpdateLinkedValue | √ | × | × | × |
SetSheetVisible | √ | × | × | × |
adjustHelper | √ | × | × | × |
adjustMergeCells | √ | × | × | × |
adjustAutoFilter | √ | × | × | × |
prepareCell | √ | × | × | × |
setDefaultTimeStyle | √ | × | × | × |
timeToExcelTime | √ | × | × | × |
addDrawingChart | √ | × | × | × |
addDrawingVML | √ | × | × | × |
addDrawingPicture | √ | × | × | × |
getTotalRowsCols | √ | × | × | × |
checkRow | √ | × | × | × |
addDrawingShape | √ | × | × | × |
addTable | √ | × | × | × |
workSheetReader | √ | × | × | × |
copySheet | √ | × | × | × |
* From version 2.0.0 all row manipulation methods use Excel row numbering starting with 1
instead of zero-based numbering which takes place in some methods in earlier versions, related issue #349.
DuplicateRowTo()
has been added for duplicate row to specified row positionSetPageLayout()
now support to set page orientation, related issue #318SetPageLayout()
now support to set page size255
, related issue #339GetComment()
returns incorrect mapping between worksheets and comments in some case, related issue #345Published by xuri almost 6 years ago
We are pleased to announce the release of version 1.4.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 change log.
The most notable changes in this release are:
WriteTo()
has been added, it implements io.WriterTo to write the fileSearchSheet()
has been added to get coordinates by given worksheet name, cell value, and regular expression. Relate issue #277ProtectSheet()
and UnprotectSheet()
has been added to prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, relate issue #273GetMergeCells()
has been added, support to get all merged cells from a worksheet currentlygo module
AddChart()
now support to create 2D / 3D area, stacked area, 100% stacked area charts, relate issue #311sharedStringsReader()
, resolve issue #276GetRows()
return value avoid empty rows in the tail of the worksheet, resolve issue #195GetSheetMap()
failed in some case, resolve issue #297Published by xuri about 6 years ago
We are pleased to announce the release of 1.4.0.
The most notable changes in this release are:
AddChart()
, AddComment()
, AddPicture()
, AddShape()
, AddTable()
and SetConditionalFormat()
GetComments()
has been added for support retrieves all comments and returns a map of worksheet name to the worksheet commentsRGBToHSL()
and HSLToRGB()
has been added for support convert RGBA, HSL colorNewDataValidation()
and series functions DataValidation.SetDropList()
, DataValidation.SetError()
, DataValidation.SetInput()
, DataValidation.SetRange()
, DataValidation.SetSqref()
and DataValidation.SetSqrefDropList()
has been added for suppport data validationAddPictureFromBytes()
has been added, relate issue #259GetCellFormula()
now supports shared formula types, relate issue #227NewSheet()
cause file issue, related issue #249deepcopy
function that was using encoding/gob serialization and deserializationPublished by xuri over 6 years ago
We are pleased to announce the release of v1.1.0.
The most notable changes in this release are:
CopySheet()