golang导出数据为excel文件

golang 实现导出数据为excel文件，并在浏览器可下载

话不多说直接上代码：

func (c *Questions) ExportExcel() {
	c.Title = "问答库列表数据导出"

	//表格列标题
	titles := []string{
		"问题编号", "问题类型", "问题来源", "问题详情", "答案", "更新时间",
	}
	// 从数据库获取数据
	list := make([]models.QuestionExport, 0)
	err := models.DB.Model(models.QuestionLibrary{}).Scan(&list).Error
	if err != nil {
		c.RspErrorQuery(err, "query error")
		return
	}
	dataTmp := make([][]interface{}, len(list))

	for i := 0; i < len(list); i++ {
		dataTmp[i] = make([]interface{}, len(titles))
		dataTmp[i][0] = list[i].Number
		dataTmp[i][1] = list[i].Type
		dataTmp[i][2] = list[i].Source
		dataTmp[i][3] = list[i].QuestionText
		dataTmp[i][4] = list[i].AnswerText
		dataTmp[i][5] = list[i].UpdatedAt.Time.Format("2006/01/02 15:04:05")
	}
	err = c.ExportToExcel(titles, dataTmp)
	if err != nil {
		c.RspUnknownError(err, "导出失败")
		return
	}
}

// ExportToExcel 导出excel文件 .
// 参数说明： titles 表格列名; dataTmp 表格内容数据
func (c *Backend) ExportToExcel(titles []string, dataTmp [][]interface{}) (err error) {
	f := xlsx.NewFile()
	// 新建工作簿
	sheet, _ := f.AddSheet("Sheet1")
	row := sheet.AddRow()

	var cell *xlsx.Cell
	//列标题赋值
	for _, v := range titles {
		cell = row.AddCell()
		cell.Value = v
	}

	for _, v := range dataTmp {
		//行内容 v
		row = sheet.AddRow()
		for _, vv := range v {
			cell = row.AddCell()
			cell.Value = vv.(string)
		}
	}
	//保存为文件

	_filename := strconv.FormatInt(time.Now().UnixNano(), 10) + ".xlsx"

	c.Ctx.Output.Header("Content-Type", "application/octet-stream")
	c.Ctx.Output.Header("Content-Disposition", "attachment; filename="+_filename)
	c.Ctx.Output.Header("Content-Transfer-Encoding", "binary")

	//回写到web 流媒体 形成下载
	err = f.Write(c.Ctx.ResponseWriter)
	if err != nil {
		c.RspUnknownError(err)
		return
	}
	return err
}