饼图

例如，创建如下效果的饼图：

使用 Go 语言在 Excel 文档中创建饼图

  1. package main
  3. import (
  4.     "fmt"
  6.     "github.com/xuri/excelize/v2"
  7. )
  9. func main() {
  10.     f := excelize.NewFile()
  11.     defer func() {
  12.         if err := f.Close(); err != nil {
  13.             fmt.Println(err)
  14.         }
  15.     }()
  16.     for idx, row := range [][]interface{}{
  17.         {"Apple", "Orange", "Pear"},
  18.         {2, 3, 3},
  19.     } {
  20.         cell, err := excelize.CoordinatesToCellName(1, idx+1)
  21.         if err != nil {
  22.             fmt.Println(err)
  23.             return
  24.         }
  25.         if err := f.SetSheetRow("Sheet1", cell, &row); err != nil {
  26.             fmt.Println(err)
  27.             return
  28.         }
  29.     }
  30.     if err := f.AddChart("Sheet1", "E1", &excelize.Chart{
  31.         Type: excelize.Pie,
  32.         Series: []excelize.ChartSeries{
  33.             {
  34.                 Name:       "数量",
  35.                 Categories: "Sheet1!$A$1:$C$1",
  36.                 Values:     "Sheet1!$A$2:$C$2",
  37.             },
  38.         },
  39.         Format: excelize.GraphicOptions{
  40.             OffsetX: 15,
  41.             OffsetY: 10,
  42.         },
  43.         Title: []excelize.RichTextRun{
  44.             {
  45.                 Text: "饼图",
  46.             },
  47.         },
  48.         PlotArea: excelize.ChartPlotArea{
  49.             ShowPercent: true,
  50.         },
  51.     }); err != nil {
  52.         fmt.Println(err)
  53.         return
  54.     }
  55.     // 保存工作簿
  56.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  57.         fmt.Println(err)
  58.     }
  59. }