go execl 包

介绍

Git： https://github.com/xuri/excelize

office site： https://xuri.me/excelize/zh-hans/

安装

$ go get github.com/xuri/excelize

$ go get github.com/xuri/excelize/v2

更新

go get -u github.com/xuri/excelize/v2

使用

package main

import (
    "fmt"

    "github.com/xuri/excelize/v2"
)

func main() {
    f := excelize.NewFile()
    // Create a new sheet.
    index := f.NewSheet("Sheet2")
    // Set value of a cell.
    f.SetCellValue("Sheet2", "A2", "Hello world.")
    f.SetCellValue("Sheet1", "B2", 100)
    // Set active sheet of the workbook.
    f.SetActiveSheet(index)
    // Save spreadsheet by the given path.
    if err := f.SaveAs("Book1.xlsx"); err != nil {
        fmt.Println(err)
    }
}

文档

• https://xuri.me/excelize/zh-hans/cell.html#SetCellStyle