Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

xlsx

package module

Go to main page

Versions in this module

v1

v1.0.4

Nov 2, 2019

Changes in this version

+ type SheetMode byte

v1.0.3

Jul 31, 2019

v1.0.2

Jul 18, 2019

v1.0.1

Jul 18, 2019

v1.0.0

Jul 17, 2019

Changes in this version

+ const SheetModeIgnoreDimension

+ const SheetModeMultiPhase

+ const SheetModeStream

+ type Cell struct

+ func (c *Cell) Bool() (bool, error)

+ func (c *Cell) Clear()

+ func (c *Cell) Comment() string

+ func (c *Cell) Date() (time.Time, error)

+ func (c *Cell) Float() (float64, error)

+ func (c *Cell) HasFormula() bool

+ func (c *Cell) Hyperlink() *hyperlink.Info

+ func (c *Cell) Int() (int, error)

+ func (c *Cell) RemoveComment()

+ func (c *Cell) RemoveHyperlink()

+ func (c *Cell) Reset()

+ func (c *Cell) SetBool(value bool)

+ func (c *Cell) SetComment(comment interface{}) error

+ func (c *Cell) SetDate(value time.Time)

+ func (c *Cell) SetDateTime(value time.Time)

+ func (c *Cell) SetDeltaTime(value time.Time)

+ func (c *Cell) SetFloat(value float64)

+ func (c *Cell) SetGeneral(value string)

+ func (c *Cell) SetHyperlink(link interface{}) error

+ func (c *Cell) SetInlineText(parts ...interface{}) error

+ func (c *Cell) SetInt(value int)

+ func (c *Cell) SetStyles(s interface{})

+ func (c *Cell) SetText(parts ...interface{}) error

+ func (c *Cell) SetTime(value time.Time)

+ func (c *Cell) SetUint(value uint)

+ func (c *Cell) SetValue(value interface{})

+ func (c *Cell) SetValueWithFormat(value interface{}, formatCode string)

+ func (c *Cell) SetValueWithHyperlink(value interface{}, link interface{}) error

+ func (c *Cell) String() string

+ func (c *Cell) Styles() styles.DirectStyleID

+ func (c *Cell) Type() types.CellType

+ func (c *Cell) Uint() (uint, error)

+ func (c *Cell) Value() string

+ type Col struct

+ func (c *Col) Cell(rowIndex int) *Cell

+ func (c *Col) CopyTo(cIdx int, withOptions bool)

+ func (c *Col) SetOptions(o *options.Info)

+ func (c *Col) SetStyles(styleID styles.DirectStyleID)

+ func (c *Col) Styles() styles.DirectStyleID

+ type ColIterator interface

+ HasNext func() bool

+ Next func() (idx int, col *Col)

+ type Range struct

+ func (r *Range) Bounds() types.Bounds

+ func (r *Range) Cells() RangeIterator

+ func (r *Range) Clear()

+ func (r *Range) CopyTo(cIdx, rIdx int)

+ func (r *Range) CopyToRef(ref types.Ref)

+ func (r *Range) Merge() error

+ func (r *Range) RemoveHyperlink()

+ func (r *Range) Reset()

+ func (r *Range) SetHyperlink(link interface{}) error

+ func (r *Range) SetStyles(styleID styles.DirectStyleID)

+ func (r *Range) Split()

+ func (r *Range) Values() []string

+ func (r *Range) Walk(cb func(idx, cIdx, rIdx int, c *Cell))

+ type RangeIterator interface

+ HasNext func() bool

+ Next func() (cIdx int, rIdx int, cell *Cell)

+ type Row struct

+ func (r *Row) Cell(colIndex int) *Cell

+ func (r *Row) CopyTo(rIdx int, withOptions bool)

+ func (r *Row) SetOptions(o *options.Info)

+ func (r *Row) SetStyles(styleID styles.DirectStyleID)

+ func (r *Row) Styles() styles.DirectStyleID

+ type RowIterator interface

+ HasNext func() bool

+ Next func() (idx int, row *Row)

+ type Sheet interface

+ AddConditional func(conditional *conditional.Info, refs ...types.Ref) error

+ AddFilter func(colIndex int, settings ...interface{}) error

+ AutoFilter func(ref types.Ref, settings ...interface{})

+ Cell func(colIndex, rowIndex int) *Cell

+ CellByRef func(cellRef types.CellRef) *Cell

+ Close func()

+ Col func(index int) *Col

+ Cols func() ColIterator

+ DeleteCol func(index int)

+ DeleteConditional func(refs ...types.Ref)

+ DeleteFilter func(colIndex int)

+ DeleteRow func(index int)

+ Dimension func() (cols int, rows int)

+ InsertCol func(index int) *Col

+ InsertRow func(index int) *Row

+ MergeCols func(fromIndex, toIndex int) error

+ MergeRows func(fromIndex, toIndex int) error

+ Name func() string

+ Range func(fromCol, fromRow, toCol, toRow int) *Range

+ RangeByRef func(ref types.Ref) *Range

+ Row func(index int) *Row

+ Rows func() RowIterator

+ SetActive func()

+ SetDimension func(cols, rows int)

+ SetName func(name string)

+ SetOptions func(o *options.Info)

+ SplitCols func(fromIndex, toIndex int)

+ SplitRows func(fromIndex, toIndex int)

+ type SheetIterator interface

+ HasNext func() bool

+ Next func() (idx int, sheet Sheet)

+ type Spreadsheet struct

+ func New() *Spreadsheet

+ func Open(f interface{}) (*Spreadsheet, error)

+ func (xl *Spreadsheet) AddSheet(name string, options ...sheetMode) Sheet

+ func (xl *Spreadsheet) AddStyles(style *styles.Info) styles.DirectStyleID

+ func (xl *Spreadsheet) DeleteSheet(i int)

+ func (xl *Spreadsheet) IsValid() error

+ func (xl *Spreadsheet) ResolveStyles(styleID styles.DirectStyleID) *styles.Info

+ func (xl *Spreadsheet) Sheet(i int, options ...sheetMode) Sheet

+ func (xl *Spreadsheet) SheetByName(name string, options ...sheetMode) Sheet

+ func (xl *Spreadsheet) SheetNames() []string

+ func (xl *Spreadsheet) Sheets() SheetIterator