excelize

package module

Go to main page

Versions in this module

v1

v1.4.0

Sep 13, 2018

Changes in this version

+ 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 STCellFormulaTypeArray

+ const STCellFormulaTypeDataTable

+ const STCellFormulaTypeNormal

+ const STCellFormulaTypeShared

+ var HSLModel = color.ModelFunc(hslModel)

+ func HSLToRGB(h, s, l float64) (r, g, b uint8)

+ func RGBToHSL(r, g, b uint8) (h, s, l float64)

+ func ThemeColor(baseColor string, tint float64) 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 File

+ Theme *xlsxTheme

+ func (f *File) AddDataValidation(sheet string, dv *DataValidation)

+ func (f *File) AddPictureFromBytes(sheet, cell, format, name, extension string, file []byte) error

+ func (f *File) GetComments() (comments map[string][]Comment)

+ func (f *File) WriteTo(w io.Writer) (int64, error)

+ type HSL struct

+ H float64

+ L float64

+ S float64

+ func (c HSL) RGBA() (uint32, uint32, uint32, uint32)

v1.3.0

May 11, 2018

Changes in this version

+ const Bar3DClustered

+ const Bar3DPercentStacked

+ const Bar3DStacked

+ const BarPercentStacked

+ const Col

+ const Col3D

+ const Col3DClustered

+ const Col3DPercentStacked

+ const Col3DStacked

+ const ColPercentStacked

+ const ColStacked

+ var XMLHeaderByte = []byte(XMLHeader)

+ type ErrSheetNotExist struct

+ SheetName string

+ func (err ErrSheetNotExist) Error() string

type File

+ func (f *File) GetColOutlineLevel(sheet, column string) uint8

+ func (f *File) GetRowOutlineLevel(sheet string, rowIndex int) uint8

+ func (f *File) Rows(sheet string) (*Rows, error)

+ func (f *File) SetCellBool(sheet, axis string, value bool)

+ func (f *File) SetColOutlineLevel(sheet, column string, level uint8)

+ func (f *File) SetRowOutlineLevel(sheet string, rowIndex int, level uint8)

+ func (f *File) SetSheetRow(sheet, axis string, slice interface{})

+ type Rows struct

+ func (rows *Rows) Columns() []string

+ func (rows *Rows) Error() error

+ func (rows *Rows) Next() bool

+ type ZoomScale float64

v1.2.0

Dec 1, 2017

Changes in this version

+ const BarStacked

+ type AutoPageBreaks bool

+ type CodeName string

+ type DefaultGridColor bool

+ type EnableFormatConditionsCalculation bool

type File

+ func (f *File) GetSheetPrOptions(name string, opts ...SheetPrOptionPtr) error

+ func (f *File) GetSheetViewOptions(name string, viewIndex int, opts ...SheetViewOptionPtr) error

+ func (f *File) SetSheetPrOptions(name string, opts ...SheetPrOption) error

+ func (f *File) SetSheetViewOptions(name string, viewIndex int, opts ...SheetViewOption) error

+ type FitToPage bool

+ type Published bool

+ type RightToLeft bool

+ type SheetPrOption interface

+ type SheetPrOptionPtr interface

+ type SheetViewOption interface

+ type SheetViewOptionPtr interface

+ type ShowFormulas bool

+ type ShowGridLines bool

+ type ShowRowColHeaders bool

v1.1.0

Aug 19, 2017

Changes in this version

+ const Bar

+ const Bar3D

+ const Doughnut

+ const EMU

+ const Line

+ const NameSpaceDrawingML

+ const NameSpaceDrawingMLChart

+ const NameSpaceDrawingMLSpreadSheet

+ const NameSpaceSpreadSheet

+ const NameSpaceXML

+ const Pie

+ const Pie3D

+ const Radar

+ 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 XMLHeader

+ func ReadZipReader(r *zip.Reader) (map[string]string, int, error)

+ func TitleToNumber(s string) int

+ func ToAlphaString(value int) string

+ type File struct

+ ContentTypes *xlsxTypes

+ Path string

+ SharedStrings *xlsxSST

+ Sheet map[string]*xlsxWorksheet

+ SheetCount int

+ Styles *xlsxStyleSheet

+ WorkBook *xlsxWorkbook

+ WorkBookRels *xlsxWorkbookRels

+ XLSX map[string]string

+