Excel 导出
Github 地址
https://github.com/360EntSecGroup-Skylar/excelize
Demo
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)
}