goxlsx

README

go xlxs

基于这个库封装
go get github.com/xuri/excelize/v2

• 目前只支持写一个sheet

Documentation

Index

• type CsvRead
  • func NewCsvReader(csvFile string, comma rune) (*CsvRead, error)
  • func (c *CsvRead) ReadGBKAll() ([][]string, error)
  • func (c *CsvRead) ReadGBKLine(lineDataFunc func(record []string) error) error
  • func (c *CsvRead) ReadUTF16All() ([][]string, error)
  • func (c *CsvRead) ReadUTF16Line(lineDataFunc func(record []string)) error
  • func (c *CsvRead) ReadUTF8All() ([][]string, error)
  • func (c *CsvRead) ReadUTF8Line(lineDataFunc func(record []string)) error
• type XlsxRead
  • func NewReader(xlsxFile string) (*XlsxRead, error)
  • func (r *XlsxRead) Close() error
  • func (r *XlsxRead) GetRows(sheetName string) error
• type XlsxWrite
  • func NewWriter() *XlsxWrite
  • func (x *XlsxWrite) AppendData(data []interface{}) *XlsxWrite
  • func (x *XlsxWrite) AppendRows(data [][]interface{}) *XlsxWrite
  • func (x *XlsxWrite) Output(w http.ResponseWriter, filename string) (err error)
  • func (x *XlsxWrite) OutputForGin(ctx *gin.Context, filename string) (err error)
  • func (x *XlsxWrite) Save2File(filename string) (err error)
  • func (x *XlsxWrite) SetSheetName(sheetName string) *XlsxWrite
  • func (x *XlsxWrite) SetTitles(titles []string) *XlsxWrite

Types

type CsvRead

type CsvRead struct {
	FilePath string
	Comma    rune //csv 列分割符 0 表示默认
}

func NewCsvReader

func NewCsvReader(csvFile string, comma rune) (*CsvRead, error)

comma 默认传 ','

func (*CsvRead) ReadGBKAll

func (c *CsvRead) ReadGBKAll() ([][]string, error)

func (*CsvRead) ReadGBKLine

func (c *CsvRead) ReadGBKLine(lineDataFunc func(record []string) error) error

func (*CsvRead) ReadUTF16All

func (c *CsvRead) ReadUTF16All() ([][]string, error)

func (*CsvRead) ReadUTF16Line

func (c *CsvRead) ReadUTF16Line(lineDataFunc func(record []string)) error

func (*CsvRead) ReadUTF8All

func (c *CsvRead) ReadUTF8All() ([][]string, error)

func (*CsvRead) ReadUTF8Line

func (c *CsvRead) ReadUTF8Line(lineDataFunc func(record []string)) error

type XlsxRead

type XlsxRead struct {
	XlsxFile *excelize.File
}

需要扩展按行读取文件

func NewReader

func NewReader(xlsxFile string) (*XlsxRead, error)

func (*XlsxRead) Close

func (r *XlsxRead) Close() error

func (*XlsxRead) GetRows

func (r *XlsxRead) GetRows(sheetName string) error

type XlsxWrite

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

扩展需要append to file 功能

func NewWriter

func NewWriter() *XlsxWrite

func (*XlsxWrite) AppendData

func (x *XlsxWrite) AppendData(data []interface{}) *XlsxWrite

func (*XlsxWrite) AppendRows

func (x *XlsxWrite) AppendRows(data [][]interface{}) *XlsxWrite

func (*XlsxWrite) Output

func (x *XlsxWrite) Output(w http.ResponseWriter, filename string) (err error)

func (*XlsxWrite) OutputForGin

func (x *XlsxWrite) OutputForGin(ctx *gin.Context, filename string) (err error)

func (*XlsxWrite) Save2File

func (x *XlsxWrite) Save2File(filename string) (err error)

func (*XlsxWrite) SetSheetName

func (x *XlsxWrite) SetSheetName(sheetName string) *XlsxWrite

func (*XlsxWrite) SetTitles

func (x *XlsxWrite) SetTitles(titles []string) *XlsxWrite