excel

Documentation

Index

• type Aide
  • func NewAide() *Aide
  • func (aide *Aide) CreateSheet(sheetName string) (sheet *xlsx.Sheet, err error)
  • func (aide *Aide) GetSheet(sheetName string) (sheet *xlsx.Sheet, err error)
  • func (aide *Aide) NewFile()
  • func (aide *Aide) OpenFile(filePath string) (err error)
  • func (aide *Aide) Save(filePath string) (err error)
  • func (aide *Aide) WriteRow(sheet *xlsx.Sheet, data interface{})
  • func (aide *Aide) WriteRows(sheet *xlsx.Sheet, data interface{})

Types

type Aide

type Aide struct {
	// contains filtered or unexported fields
}

Aide provides excel api wrapper.

func NewAide

func NewAide() *Aide

NewAide new an instance.

func (*Aide) CreateSheet

func (aide *Aide) CreateSheet(sheetName string) (sheet *xlsx.Sheet, err error)

CreateSheet create a new sheet.

func (*Aide) GetSheet

func (aide *Aide) GetSheet(sheetName string) (sheet *xlsx.Sheet, err error)

GetSheet get an existing sheet.

func (*Aide) NewFile

func (aide *Aide) NewFile()

NewFile create a new file.

func (*Aide) OpenFile

func (aide *Aide) OpenFile(filePath string) (err error)

OpenFile open an existing file.

func (*Aide) Save

func (aide *Aide) Save(filePath string) (err error)

Save save as a file.

func (*Aide) WriteRow

func (aide *Aide) WriteRow(sheet *xlsx.Sheet, data interface{})

WriteRow write data into a row.

func (*Aide) WriteRows

func (aide *Aide) WriteRows(sheet *xlsx.Sheet, data interface{})

WriteRows write data into rows.