Versions in this module Expand all Collapse all v0 v0.0.1 Aug 30, 2019 Changes in this version + const Area + const Area3D + const Area3DPercentStacked + const Area3DStacked + const AreaPercentStacked + const AreaStacked + const Bar + const Bar3DClustered + const Bar3DPercentStacked + const Bar3DStacked + const BarPercentStacked + const BarStacked + const Col + const Col3D + const Col3DClustered + const Col3DPercentStacked + const Col3DStacked + const ColPercentStacked + const ColStacked + const DataValidationOperatorBetween + const DataValidationOperatorEqual + const DataValidationOperatorGreaterThan + const DataValidationOperatorGreaterThanOrEqual + const DataValidationOperatorLessThan + const DataValidationOperatorLessThanOrEqual + const DataValidationOperatorNotBetween + const DataValidationOperatorNotEqual + const DataValidationTypeCustom + const DataValidationTypeDate + const DataValidationTypeDecimal + const DataValidationTypeTextLeng + const DataValidationTypeTime + const DataValidationTypeWhole + const Doughnut + const EMU + const Line + const NameSpaceDrawingML + const NameSpaceDrawingMLChart + const NameSpaceDrawingMLSpreadSheet + const NameSpaceSpreadSheet + const NameSpaceXML + const Pie + const Pie3D + const Radar + const STCellFormulaTypeArray + const STCellFormulaTypeDataTable + const STCellFormulaTypeNormal + const STCellFormulaTypeShared + const Scatter + const SourceRelationship + const SourceRelationshipChart + const SourceRelationshipChart20070802 + const SourceRelationshipChart2014 + const SourceRelationshipChart201506 + const SourceRelationshipComments + const SourceRelationshipCompatibility + const SourceRelationshipDrawingML + const SourceRelationshipDrawingVML + const SourceRelationshipHyperLink + const SourceRelationshipImage + const SourceRelationshipTable + const SourceRelationshipWorkSheet + const StrictNameSpaceSpreadSheet + const StrictSourceRelationship + const StrictSourceRelationshipChart + const StrictSourceRelationshipComments + const StrictSourceRelationshipImage + const XMLHeader + var HSLModel = color.ModelFunc(hslModel) + var XMLHeaderByte = []byte(XMLHeader) + func HSLToRGB(h, s, l float64) (r, g, b uint8) + func RGBToHSL(r, g, b uint8) (h, s, l float64) + func ReadZipReader(r *zip.Reader) (map[string][]byte, int, error) + func ThemeColor(baseColor string, tint float64) string + func TitleToNumber(s string) int + func ToAlphaString(value int) string + type AutoPageBreaks bool + type CodeName string + type Comment struct + Author string + AuthorID int + Ref string + Text string + type DataValidation struct + AllowBlank bool + Error *string + ErrorStyle *string + ErrorTitle *string + Formula1 string + Formula2 string + Operator string + Prompt *string + PromptTitle *string + ShowDropDown bool + ShowErrorMessage bool + ShowInputMessage bool + Sqref string + Type string + func NewDataValidation(allowBlank bool) *DataValidation + func (dd *DataValidation) SetDropList(keys []string) error + func (dd *DataValidation) SetError(style DataValidationErrorStyle, title, msg string) + func (dd *DataValidation) SetInput(title, msg string) + func (dd *DataValidation) SetRange(f1, f2 int, t DataValidationType, o DataValidationOperator) error + func (dd *DataValidation) SetSqref(sqref string) + func (dd *DataValidation) SetSqrefDropList(sqref string, isCurrentSheet bool) error + type DataValidationErrorStyle int + const DataValidationErrorStyleInformation + const DataValidationErrorStyleStop + const DataValidationErrorStyleWarning + type DataValidationOperator int + type DataValidationType int + type DefaultGridColor bool + type EnableFormatConditionsCalculation bool + type ErrSheetNotExist struct + SheetName string + func (err ErrSheetNotExist) Error() string + type File struct + ContentTypes *xlsxTypes + Path string + SharedStrings *xlsxSST + Sheet map[string]*xlsxWorksheet + SheetCount int + Styles *xlsxStyleSheet + Theme *xlsxTheme + WorkBook *xlsxWorkbook + WorkBookRels *xlsxWorkbookRels + XLSX map[string][]byte + func NewFile() *File + func OpenFile(filename string) (*File, error) + func OpenReader(r io.Reader) (*File, error) + func (f *File) AddChart(sheet, cell, format string) error + func (f *File) AddComment(sheet, cell, format string) error + func (f *File) AddDataValidation(sheet string, dv *DataValidation) + func (f *File) AddPicture(sheet, cell, picture, format string) error + func (f *File) AddPictureFromBytes(sheet, cell, format, name, extension string, file []byte) error + func (f *File) AddShape(sheet, cell, format string) error + func (f *File) AddTable(sheet, hcell, vcell, format string) error + func (f *File) AutoFilter(sheet, hcell, vcell, format string) error + func (f *File) CopySheet(from, to int) error + func (f *File) DeleteSheet(name string) + func (f *File) DuplicateRow(sheet string, row int) + func (f *File) GetActiveSheetIndex() int + func (f *File) GetCellFormula(sheet, axis string) string + func (f *File) GetCellHyperLink(sheet, axis string) (bool, string) + func (f *File) GetCellStyle(sheet, axis string) int + func (f *File) GetCellValue(sheet, axis string) string + func (f *File) GetColOutlineLevel(sheet, column string) uint8 + func (f *File) GetColVisible(sheet, column string) bool + func (f *File) GetColWidth(sheet, column string) float64 + func (f *File) GetComments() (comments map[string][]Comment) + func (f *File) GetMergeCells(sheet string) []MergeCell + func (f *File) GetPicture(sheet, cell string) (string, []byte) + func (f *File) GetRowHeight(sheet string, row int) float64 + func (f *File) GetRowOutlineLevel(sheet string, rowIndex int) uint8 + func (f *File) GetRowVisible(sheet string, rowIndex int) bool + func (f *File) GetRows(sheet string) [][]string + func (f *File) GetSheetIndex(name string) int + func (f *File) GetSheetMap() map[int]string + func (f *File) GetSheetName(index int) string + func (f *File) GetSheetPrOptions(name string, opts ...SheetPrOptionPtr) error + func (f *File) GetSheetViewOptions(name string, viewIndex int, opts ...SheetViewOptionPtr) error + func (f *File) GetSheetVisible(name string) bool + func (f *File) InsertCol(sheet, column string) + func (f *File) InsertRow(sheet string, row int) + func (f *File) MergeCell(sheet, hcell, vcell string) + func (f *File) NewConditionalStyle(style string) (int, error) + func (f *File) NewSheet(name string) int + func (f *File) NewStyle(style string) (int, error) + func (f *File) ProtectSheet(sheet string, settings *FormatSheetProtection) + func (f *File) RemoveCol(sheet, column string) + func (f *File) RemoveRow(sheet string, row int) + func (f *File) Rows(sheet string) (*Rows, error) + func (f *File) Save() error + func (f *File) SaveAs(name string) error + func (f *File) SearchSheet(sheet, value string, reg ...bool) []string + func (f *File) SetActiveSheet(index int) + func (f *File) SetCellBool(sheet, axis string, value bool) + func (f *File) SetCellDefault(sheet, axis, value string) + func (f *File) SetCellFormula(sheet, axis, formula string) + func (f *File) SetCellHyperLink(sheet, axis, link, linkType string) + func (f *File) SetCellInt(sheet, axis string, value int) + func (f *File) SetCellStr(sheet, axis, value string) + func (f *File) SetCellStyle(sheet, hcell, vcell string, styleID int) + func (f *File) SetCellValue(sheet, axis string, value interface{}) + func (f *File) SetColOutlineLevel(sheet, column string, level uint8) + func (f *File) SetColVisible(sheet, column string, visible bool) + func (f *File) SetColWidth(sheet, startcol, endcol string, width float64) + func (f *File) SetConditionalFormat(sheet, area, formatSet string) error + func (f *File) SetPanes(sheet, panes string) + func (f *File) SetRowHeight(sheet string, row int, height float64) + func (f *File) SetRowOutlineLevel(sheet string, rowIndex int, level uint8) + func (f *File) SetRowVisible(sheet string, rowIndex int, visible bool) + func (f *File) SetSheetBackground(sheet, picture string) error + func (f *File) SetSheetName(oldName, newName string) + func (f *File) SetSheetPrOptions(name string, opts ...SheetPrOption) error + func (f *File) SetSheetRow(sheet, axis string, slice interface{}) + func (f *File) SetSheetViewOptions(name string, viewIndex int, opts ...SheetViewOption) error + func (f *File) SetSheetVisible(name string, visible bool) + func (f *File) UnprotectSheet(sheet string) + func (f *File) UpdateLinkedValue() + func (f *File) Write(w io.Writer) error + func (f *File) WriteTo(w io.Writer) (int64, error) + func (f *File) WriteToBuffer() (*bytes.Buffer, error) + type FitToPage bool + type FormatSheetProtection struct + AutoFilter bool + DeleteColumns bool + DeleteRows bool + EditObjects bool + EditScenarios bool + FormatCells bool + FormatColumns bool + FormatRows bool + InsertColumns bool + InsertHyperlinks bool + InsertRows bool + Password string + PivotTables bool + SelectLockedCells bool + SelectUnlockedCells bool + Sort bool + type HSL struct + H float64 + L float64 + S float64 + func (c HSL) RGBA() (uint32, uint32, uint32, uint32) + type MergeCell []string + func (m *MergeCell) GetCellValue() string + func (m *MergeCell) GetEndAxis() string + func (m *MergeCell) GetStartAxis() string + type OutlineSummaryBelow bool + type Published bool + type RightToLeft bool + type Rows struct + func (rows *Rows) Columns() []string + func (rows *Rows) Error() error + func (rows *Rows) Next() bool + type SheetPrOption interface + type SheetPrOptionPtr interface + type SheetViewOption interface + type SheetViewOptionPtr interface + type ShowFormulas bool + type ShowGridLines bool + type ShowRowColHeaders bool + type TopLeftCell string + type ZoomScale float64