excelUtil

Documentation

Index

• func Create(sheetName string, data interface{}, columns []types.ColumnInfo) (*xlsx.File, string, error)
• func CreateSheet(file *xlsx.File, sheetName string, data interface{}, ...) (*xlsx.Sheet, error)
• func Export(filename string, c *gin.Context, file *xlsx.File)
• func ExportSheet(c *gin.Context, sheetName string, data interface{}, columns []types.ColumnInfo)
• func GetColumnFromSheet(sheet *xlsx.Sheet) ([]types.ColumnInfo, error)
• func GetDataFromSheet(sheet *xlsx.Sheet, startRowNum int, columns []types.ColumnInfo) ([]map[string]interface{}, error)
• type ColumnInfo

Functions

func Create

func Create(sheetName string, data interface{}, columns []types.ColumnInfo) (*xlsx.File, string, error)

func CreateSheet

func CreateSheet(file *xlsx.File, sheetName string, data interface{}, columns []types.ColumnInfo) (*xlsx.Sheet, error)

func Export

func Export(filename string, c *gin.Context, file *xlsx.File)

func ExportSheet

func ExportSheet(c *gin.Context, sheetName string, data interface{}, columns []types.ColumnInfo)

func GetColumnFromSheet

func GetColumnFromSheet(sheet *xlsx.Sheet) ([]types.ColumnInfo, error)

func GetDataFromSheet

func GetDataFromSheet(sheet *xlsx.Sheet, startRowNum int, columns []types.ColumnInfo) ([]map[string]interface{}, error)

Types

type ColumnInfo

type ColumnInfo struct {
	Field   string `json:"field"`
	Name    string `json:"name"`
	IsEdit  bool   `json:"is_edit" json:"isEdit"`
	Type    string `json:"type"`
	Require bool   `json:"require"`
}