Versions in this module Expand all Collapse all v1 v1.3.4 Feb 15, 2020 v1.3.3 Dec 18, 2019 v1.3.2 Aug 8, 2019 v1.3.1 Mar 5, 2019 v1.3.0 Mar 14, 2018 Changes in this version + const ColWidth + const MJD_0 + const MJD_JD2000 + const TEMPLATE_DOCPROPS_APP + const TEMPLATE_DOCPROPS_CORE + const TEMPLATE_XL_THEME_THEME + const TEMPLATE__RELS_DOT_RELS + var HSLModel = color.ModelFunc(hslModel) + func FileToSlice(path string) ([][][]string, error) + func HSLToRGB(h, s, l float64) (r, g, b uint8) + func MakeDefaultContentTypes() (types xlsxTypes) + func RGBToHSL(r, g, b uint8) (h, s, l float64) + func SetDefaultFont(size int, name string) + func TimeFromExcelTime(excelTime float64, date1904 bool) time.Time + type Alignment struct + Horizontal string + Vertical string + type Border struct + Bottom string + BottomColor string + Left string + LeftColor string + Right string + RightColor string + Top string + TopColor string + func DefaultBorder() *Border + func NewBorder(left, right, top, bottom string) *Border + type Cell struct + HMerge int + Hidden bool + NumFmt string + Row *Row + VMerge int + Value string + func NewCell(r *Row) *Cell + func (c *Cell) Bool() bool + func (c *Cell) Float() (float64, error) + func (c *Cell) FormattedValue() string + func (c *Cell) Formula() string + func (c *Cell) GetNumberFormat() string + func (c *Cell) GetStyle() *Style + func (c *Cell) Int() (int, error) + func (c *Cell) Int64() (int64, error) + func (c *Cell) Merge(hcells, vcells int) + func (c *Cell) SafeFormattedValue() (string, error) + func (c *Cell) SetBool(b bool) + func (c *Cell) SetDate(t time.Time) + func (c *Cell) SetDateTime(t time.Time) + func (c *Cell) SetDateTimeWithFormat(n float64, format string) + func (c *Cell) SetFloat(n float64) + func (c *Cell) SetFloatWithFormat(n float64, format string) + func (c *Cell) SetFormula(formula string) + func (c *Cell) SetInt(n int) + func (c *Cell) SetInt64(n int64) + func (c *Cell) SetString(s string) + func (c *Cell) SetStyle(style *Style) + func (c *Cell) SetValue(n interface{}) + func (c *Cell) String() string + func (c *Cell) Type() CellType + type CellInterface interface + FormattedValue func() string + String func() string + type CellType int + const CellTypeBool + const CellTypeDate + const CellTypeError + const CellTypeFormula + const CellTypeGeneral + const CellTypeInline + const CellTypeNumeric + const CellTypeString + type Col struct + Collapsed bool + Hidden bool + Max int + Min int + Width float64 + func (c *Col) GetStyle() *Style + func (c *Col) SetStyle(style *Style) + func (c *Col) SetType(cellType CellType) + type File struct + Date1904 bool + Sheet map[string]*Sheet + Sheets []*Sheet + func NewFile() (file *File) + func OpenBinary(bs []byte) (file *File, err error) + func OpenFile(filename string) (file *File, err error) + func OpenReaderAt(r io.ReaderAt, size int64) (file *File, err error) + func ReadZip(f *zip.ReadCloser) (*File, error) + func ReadZipReader(r *zip.Reader) (*File, error) + func (f *File) AddSheet(sheetName string) (sheet *Sheet, err error) + func (f *File) MarshallParts() (map[string]string, error) + func (f *File) Save(path string) (err error) + func (f *File) Write(writer io.Writer) (err error) + func (file *File) ToSlice() (output [][][]string, err error) + type Fill struct + BgColor string + FgColor string + PatternType string + func DefaultFill() *Fill + func NewFill(patternType, fgColor, bgColor string) *Fill + type Font struct + Bold bool + Charset int + Color string + Family int + Italic bool + Name string + Size int + Underline bool + func DefaultFont() *Font + func NewFont(size int, name string) *Font + type HSL struct + H float64 + L float64 + S float64 + func (c HSL) RGBA() (uint32, uint32, uint32, uint32) + type Pane struct + ActivePane string + State string + TopLeftCell string + XSplit float64 + YSplit float64 + type RefTable struct + func MakeSharedStringRefTable(source *xlsxSST) *RefTable + func NewSharedStringRefTable() *RefTable + func (rt *RefTable) AddString(str string) int + func (rt *RefTable) Length() int + func (rt *RefTable) ResolveSharedString(index int) string + type Row struct + Cells []*Cell + Height float64 + Hidden bool + Sheet *Sheet + func (r *Row) AddCell() *Cell + func (r *Row) SetHeightCM(ht float64) + func (r *Row) WriteSlice(e interface{}, cols int) int + func (r *Row) WriteStruct(e interface{}, cols int) int + type Sheet struct + Cols []*Col + File *File + Hidden bool + MaxCol int + MaxRow int + Name string + Rows []*Row + Selected bool + SheetFormat SheetFormat + SheetViews []SheetView + func (s *Sheet) AddRow() *Row + func (s *Sheet) Col(idx int) *Col + func (s *Sheet) SetColWidth(startcol, endcol int, width float64) error + func (sh *Sheet) Cell(row, col int) *Cell + type SheetFormat struct + DefaultColWidth float64 + DefaultRowHeight float64 + type SheetView struct + Pane *Pane + type Style struct + Alignment Alignment + ApplyAlignment bool + ApplyBorder bool + ApplyFill bool + ApplyFont bool + Border Border + Fill Fill + Font Font + func NewStyle() *Style + type WorkBookRels map[string]string + func (w *WorkBookRels) MakeXLSXWorkbookRels() xlsxWorkbookRels + type XLSXReaderError struct + Err string + func (e *XLSXReaderError) Error() string