go生成excel

package main

import (
    "fmt"

    "github.com/tealeg/xlsx"
)

type Try struct {
    I string
    J string
    K string
}

func main() {
    var file *xlsx.File
    var sheet *xlsx.Sheet
    var row *xlsx.Row
    var err error
    file = xlsx.NewFile()
    sheet, err = file.AddSheet("Sheet1")
    if err != nil {
        fmt.Println(err.Error())
    }

    //添加表
    A := Try{
        I: "第一列",
        J: "第二列",
        K: "第三列",
    }
    row = sheet.AddRow()
    row.WriteStruct(&A, 3)

    B := Try{
        I: "1",
        J: "2",
        K: "3",
    }
    row = sheet.AddRow()
    row.WriteStruct(&B, 3)

    C := Try{
        I: "11",
        J: "22",
        K: "33",
    }
    row = sheet.AddRow()
    row.WriteStruct(&C, 3)

    err = file.Save("MyXLSXFile.xlsx")
    if err != nil {
        fmt.Println(err.Error())
    }
}

 

posted @ 2020-02-23 15:00  ybf&yyj  阅读(814)  评论(1编辑  收藏  举报