导出用的360的excelize,支持插入图表和图片
Gin框架没有提供方法供浏览器下载,所以这里我们用流
import (
"github.com/360EntSecGroup-Skylar/excelize"
"github.com/gin-gonic/gin"
)
// 导出
func Export(c *gin.Context) {
xlsx := excelize.NewFile()
xlsx.SetCellValue("Sheet1", "A2", "asdas")
//_ = xlsx.SaveAs("./aaa.xlsx")
c.Header("Content-Type", "application/octet-stream")
c.Header("Content-Disposition", "attachment; filename="+"Workbook.xlsx")
c.Header("Content-Transfer-Encoding", "binary")
_ = xlsx.Write(c.Writer)
}