This library needs Go version 1.15 or later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data.
Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. (f) SetSheetViewOptions(name, viewIndex, opts)Įxcelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX / XLSM / XLTM / XLTX files. (f) SetRowStyle(sheet, start, end, styleID) (f) SetRowOutlineLevel(sheet, row, level) (f) SetConditionalFormat(sheet, area, formatSet) (f) SetColWidth(sheet, startcol, endcol, width) (f) SetColVisible(sheet, columns, visible) (f) SetColOutlineLevel(sheet, col, level) (f) SetCellStyle(sheet, hcell, vcell, styleID) (f) SetCellHyperLink(sheet, axis, link, linkType, opts) (f) SetCellFormula(sheet, axis, formula, opts) (f) SetCellFloat(sheet, axis, value, prec, bitSize) (f) GetSheetViewOptions(name, viewIndex, opts) (f) AutoFilter(sheet, hcell, vcell, format) (f) AddTable(sheet, hcell, vcell, format) (f) AddPictureFromBytes(sheet, cell, format, name, extension, file) (f) AddPicture(sheet, cell, picture, format) (dd) SetSqrefDropList(sqref, isCurrentSheet) ExcelDateToTime(excelDate, use1904Format)
