golang匯出Excel表格

設定樣式：

package mainimport (    "github.com/tealeg/xlsx"    "fmt")func main() {    var file *xlsx.File    var sheet *xlsx.Sheet    var row *xlsx.Row    var cell *xlsx.Cell    var err error    style := xlsx.NewStyle()    fill := *xlsx.NewFill("solid", "00FF0000", "FF000000")    font := *xlsx.NewFont(20, "Verdana")    border := *xlsx.NewBorder("thin", "thin", "thin", "thin")    style.Fill = fill    style.Font = font    style.Border = border    style.ApplyFill = true    style.ApplyFont = true    style.ApplyBorder = true    file = xlsx.NewFile()    sheet,_ = file.AddSheet("SheetName")    row = sheet.AddRow()    cell = row.AddCell()    cell.Value = "100000"    cell.SetStyle(style)    cell = row.AddCell()    cell.Value = "test"    err = file.Save("test.xlsx")    if err != nil {        fmt.Printf(err.Error())    }}

 

發送到瀏覽器： https://blog.csdn.net/niechaoya/article/details/46470715

 

想法： 先把資料群組織成一個二維數組 [ [ua ua ua  ub ub ub  uc uc  uc ]    []    []     ]   用swith