Golang excel导出

package excel

import (
	"github.com/gin-gonic/gin"
	"github.com/360EntSecGroup-Skylar/excelize"
)

func Download(ctx *gin.Context) {
	xlsx := excelize.NewFile()
	xlsx.SetCellValue("Sheet1", "A2", "我要下载一个excel文件")
	xlsx.SetCellValue("Sheet1", "B1", "b1")
	xlsx.SetCellValue("Sheet1", "A1", "有没有看到我帅气的脸庞")

	//保存文件方式
	//_ = xlsx.SaveAs("./aaa.xlsx")

	ctx.Header("Content-Type", "application/octet-stream")
	ctx.Header("Content-Disposition", "attachment; filename="+"Workbook.xlsx")
	ctx.Header("Content-Transfer-Encoding", "binary")

	//回写到web 流媒体 形成下载
	_ = xlsx.Write(ctx.Writer)
}