Excelize 2.7.1 Launched – Highly effective open-source library for spreadsheet (Excel) doc – Releases

Probably the most notable modifications on this launch are:

• Take away the Colour area within the ChartLine knowledge sort
• Substitute the info sort ShapeParagraph with RichTextRun
• Take away the Colour area from the sort Form, and makes use of the Fill as a substitute of it
• Take away the exported sort AutoFilterListOptions
• Rename the exported sort TableOptions to Desk
• The AddChart operate require utilizing ChartType enumeration worth to specify the chart sort
• Change 7 features signature:
  • Change the func (f *File) AutoFilter(sheet, rangeRef string, opts *AutoFilterOptions) error to func (f *File) AutoFilter(sheet, rangeRef string, opts []AutoFilterOptions) error
  • Change the func (f *File) AddPictureFromBytes(sheet, cell, title, extension string, file []byte, opts *GraphicOptions) error to func (f *File) AddPictureFromBytes(sheet, cell string, pic *Image) error
  • Change the func (f *File) GetPicture(sheet, cell string) (string, []byte, error) to func (f *File) GetPictures(sheet, cell string) ([]Image, error)
  • Change the func (f *File) AddVBAProject(bin string) error to func (f *File) AddVBAProject(file []byte) error
  • Change the func (f *File) GetComments() (map[string][]Remark, error) to func (f *File) GetComments(sheet string) ([]Remark, error)
  • Change the func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error to func (f *File) AddTable(sheet string, desk *Desk) error
  • Change the func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error to func (sw *StreamWriter) AddTable(desk *Desk) error

• Add new features SetSheetDimension and GetSheetDimension for workbook dimension helps, associated challenge #1463
• The NewStyle operate help to create of 17 sorts of fill variants kinds
• Improve max cell kinds restrict to 65430
• The AddPicture operate permitting insert BMP format pictures
• The GetPictures operate help to get a number of pictures in a cell
• The SetConditionalFormat operate help to making a conditional format with a “cease if true” or “icon units” rule
• The SetConditionalFormat operate help to set border coloration and create strong coloration for the colour knowledge bar, associated challenge #1462
• The AddChart operate help to set the format for the chart knowledge collection strong fill, associated challenge #1474
• The AddChart operate help to set the bubble measurement in a knowledge collection
• The AddChart operate help to specifies the values in second plot for the bar/pie of pie chart
• The AddChart operate help to set quantity format for chart knowledge labels and axis, associated challenge #1499
• The AddTable operate help to specify if present header row of the desk when create the desk
• The AddTable operate help to validate desk title, and added a brand new error fixed ErrTableNameLength, associated challenge #1468
• The AutoFilter operate help so as to add a number of filter columns when create auto filter
• The CalcCellValue operate help to specify if making use of quantity format fashion for the cell calculation outcome
• The CalcCellValue operate help double-byte chars for system features: LEFT, LEN, LENB, MID, MIDB, RIGHT and RIGHTB, associated challenge #1476
• The CalcCellValue operate now returns system error string within the outcome, and utilizing the error message in returns error, associated challenge #1490
• Case-insensitive for the picture file extension title, associated challenge #1503
• The stream author might be skip set cell worth when received nil worth, associated challenge #756
• The GetCellHyperLink operate help get cell hyperlink for merged cells
• Add new exported knowledge sort ChartType for represents chart sort enumeration

• Add help for workbook operate teams
• Add help for strict theme namespace, associated challenge #1447
• Repair panic attributable to the workbook relationship half not exist
• Enhance compatibility with SST index which accommodates clean characters, associated challenge #1508

• Repair decimal quantity format spherical challenge in some circumstances
• Repair incorrect cell sort when modifying string cell with the time quantity, resolve challenge #1464
• Repair cell resolver brought about incorrect calculation outcome, resolve challenge #1469
• Repair conditional format knowledge bar min/max worth doesn’t work, resolve challenge #1492
• Helps 0 row top and column width, resolve challenge #1461

• Enhance efficiency for apply quantity format with month title, associated challenge #1455
• Pace up for checking merged cells, associated challenge #1448

Thanks for all of the contributors to Excelize. Beneath is an inventory of contributors which have code contributions on this model:

• liron-l (Liron Levin)
• nathj07 (Nathan Davies)
• Josh-Weston (Josh Weston)
• jaby
• FlowingSPDG (Shugo Kawamura)
• barismar (Baris Mar Aziz)
• doingNobb (张涛)
• rpoetrap (Rizki Putra)
• huangshaokun
• CHANTXU64 (ChantXu64)
• playGitboy