Versions in this module Expand all Collapse all v1 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 v1.0.0 Jun 16, 2016
Go to main page