数据透视表

    1. package main
    3. import (
    4.     "fmt"
    5.     "math/rand"
    7.     "github.com/360EntSecGroup-Skylar/excelize"
    8. )
    10. func main() {
    11.     f := excelize.NewFile()
    12.     month := []string{"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"}
    13.     year := []int{2017, 2018, 2019}
    14.     types := []string{"Meat", "Dairy", "Beverages", "Produce"}
    15.     region := []string{"East", "West", "North", "South"}
    16.     f.SetSheetRow("Sheet1", "A1", &[]string{"Month", "Year", "Type", "Sales", "Region"})
    17.     for i := 0; i < 30; i++ {
    18.         f.SetCellValue("Sheet1", fmt.Sprintf("A%d", i+2), month[rand.Intn(12)])
    19.         f.SetCellValue("Sheet1", fmt.Sprintf("B%d", i+2), year[rand.Intn(3)])
    20.         f.SetCellValue("Sheet1", fmt.Sprintf("C%d", i+2), types[rand.Intn(4)])
    21.         f.SetCellValue("Sheet1", fmt.Sprintf("D%d", i+2), rand.Intn(5000))
    22.         f.SetCellValue("Sheet1", fmt.Sprintf("E%d", i+2), region[rand.Intn(4)])
    23.     }
    24.         DataRange:       "Sheet1!$A$1:$E$31",
    25.         PivotTableRange: "Sheet1!$G$2:$M$34",
    26.         Rows:            []string{"Month", "Year"},
    27.         Columns:         []string{"Type"},
    28.         Data:            []string{"Sales"},
    29.     })
    30.     if err != nil {
    31.         fmt.Println(err)
    32.     }
    33.     err = f.SaveAs("Book1.xlsx")
    34.     if err != nil {
    35.         fmt.Println(err)
    36. }