excel

Documentation

Index

• Variables
• type Excel
  • func (obj *Excel) ExcelToSQL(filename string, sheetname string, tablename string, fields []string, ...) ([]string, error)
  • func (obj *Excel) SliceToExcelBuff(s [][]interface{}) (buf *bytes.Buffer)
  • func (obj *Excel) SliceToExcelFile(s [][]interface{}, path string, filename string) (err error)
  • func (obj *Excel) SliceToGinResp(s [][]interface{}, filename string, context *gin.Context)
  • func (obj *Excel) StructSliceToGinResp(slice interface{}, filename string, context *gin.Context)
  • func (obj *Excel) StructToSlice(slice interface{}, addFieldName bool) [][]interface{}

Variables

var DExcel = &Excel{}

Types

type Excel

type Excel struct{}

func (*Excel) ExcelToSQL

func (obj *Excel) ExcelToSQL(filename string, sheetname string, tablename string, fields []string, is_column_mode bool) ([]string, error)

ExcelToSQL Excel转成SQL语句

func (*Excel) SliceToExcelBuff

func (obj *Excel) SliceToExcelBuff(s [][]interface{}) (buf *bytes.Buffer)

SliceToExcelBuff 将切片转换为Excel格式，并返回bytes.Buffer，可以保存为文件或写入http响应体

func (*Excel) SliceToExcelFile

func (obj *Excel) SliceToExcelFile(s [][]interface{}, path string, filename string) (err error)

SliceToExcelFile 将切片写入Excel文件

func (*Excel) SliceToGinResp

func (obj *Excel) SliceToGinResp(s [][]interface{}, filename string, context *gin.Context)

SliceToGinResp 将切片写入Excel文件，写入http响应体，实现Excel文件下载

func (*Excel) StructSliceToGinResp

func (obj *Excel) StructSliceToGinResp(slice interface{}, filename string, context *gin.Context)

StructSliceToGinResp 将结构体切片写入Excel文件，写入http响应体，实现Excel文件下载

func (*Excel) StructToSlice

func (obj *Excel) StructToSlice(slice interface{}, addFieldName bool) [][]interface{}

StructToSlice 将任意结构体切片转换为二维切片[][]interface{}，addFieldName是否添加字段名