> ### 導出 Excel 表格 * [github.com/360EntSecGroup-Skylar/excelize](http://github.com/360EntSecGroup-Skylar/excelize) * 庫操作文檔 :[https://xuri.me/excelize/zh-hans/sheet.html#SetColWidth](https://xuri.me/excelize/zh-hans/sheet.html#SetColWidth) ~~~ package main import ( "fmt" "github.com/360EntSecGroup-Skylar/excelize" "github.com/gin-gonic/gin" ) var ( letter = []string{"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"} ) func Download(c *gin.Context, fileName string, sheetName string, tableHeader []string, data [][]interface{}) error { xlsx := excelize.NewFile() xlsx.SetColWidth("Sheet1", "A", "O", 200/float64(len(tableHeader))) //一格一格的寫入, 數據一多, 等待的時間太長了, 后面改成CSV了 for k, v := range tableHeader { xlsx.SetCellValue(sheetName, fmt.Sprintf("%s%d", letter[k], 1), v) } for k, v := range data { for x, y := range v { xlsx.SetCellValue(sheetName, fmt.Sprintf("%s%d", letter[x], k+2), y) } } c.Header("Pragma", "public") c.Header("Expires", "0") c.Header("Cache-Control", "must-revalidate, post-check=0, pre-check=0") c.Header("Content-Type", "application/octet-stream") c.Header("Content-Disposition", fmt.Sprintf("attachment; filename="+"%s", fileName)) c.Header("Content-Transfer-Encoding", "binary") if err := xlsx.Write(c.Writer); err != nil { fmt.Println(err.Error()) return err } return nil } ~~~