goxlsx

README

go xlxs

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

• 目前只支持写一个sheet

Documentation

Index

• Variables
• type CsvReader
  • func NewCsvReader(csvFile string, comma rune) (*CsvReader, error)
  • func (c *CsvReader) ReadAll(encoding encoding.Encoding) ([][]string, error)
  • func (c *CsvReader) ReadAllJson(encoding encoding.Encoding) ([]map[string]string, error)
  • func (c *CsvReader) ReadGBKAll() ([][]string, error)
  • func (c *CsvReader) ReadGBKLine(lineDataFunc func(record []string) error) error
  • func (c *CsvReader) ReadLine(encoding encoding.Encoding, lineDataFunc func(record []string) error) error
  • func (c *CsvReader) ReadLineJson(encoding encoding.Encoding, lineDataFunc func(record map[string]string) error) error
  • func (c *CsvReader) ReadUTF16All() ([][]string, error)
  • func (c *CsvReader) ReadUTF16Line(lineDataFunc func(record []string) error) error
  • func (c *CsvReader) ReadUTF8All() ([][]string, error)
  • func (c *CsvReader) ReadUTF8Line(lineDataFunc func(record []string) error) 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

Variables

var (
	UTF8  = simplifiedchinese.GBK
	UTF16 = unicode.UTF16(unicode.LittleEndian, unicode.ExpectBOM)
	GBK   = simplifiedchinese.GBK
)

常用文件编码

Types

type CsvReader

type CsvReader struct {
	FilePath string
	Comma    rune //csv 列分割符 0 表示默认
	// contains filtered or unexported fields
}

func NewCsvReader

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

comma 默认传 ','

func (*CsvReader) ReadAll

func (c *CsvReader) ReadAll(encoding encoding.Encoding) ([][]string, error)

func (*CsvReader) ReadAllJson

func (c *CsvReader) ReadAllJson(encoding encoding.Encoding) ([]map[string]string, error)

第一行作为字段名称，后续行数据转换为json数据一次性返回所有数据

func (*CsvReader) ReadGBKAll

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

func (*CsvReader) ReadGBKLine

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

func (*CsvReader) ReadLine

func (c *CsvReader) ReadLine(encoding encoding.Encoding, lineDataFunc func(record []string) error) error

func (*CsvReader) ReadLineJson

func (c *CsvReader) ReadLineJson(encoding encoding.Encoding, lineDataFunc func(record map[string]string) error) error

第一行作为字段名称，后续行数据转换为json数据,一行回调一个json数据

func (*CsvReader) ReadUTF16All

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

func (*CsvReader) ReadUTF16Line

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

func (*CsvReader) ReadUTF8All

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

func (*CsvReader) ReadUTF8Line

func (c *CsvReader) ReadUTF8Line(lineDataFunc func(record []string) error) 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