圆环图

例如，创建如下效果的圆环图：

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

  1. package main
  3. import (
  4.     "fmt"
  6.     "github.com/360EntSecGroup-Skylar/excelize/v2"
  7. )
  9. func main() {
  10.     categories := map[string]string{"A1": "Apple", "B1": "Orange", "C1": "Pear"}
  11.     values := map[string]int{"A2": 2, "B2": 3, "C2": 3}
  12.     f := excelize.NewFile()
  13.     for k, v := range categories {
  14.         f.SetCellValue("Sheet1", k, v)
  15.     }
  16.     for k, v := range values {
  17.         f.SetCellValue("Sheet1", k, v)
  18.     }
  19.     if err := f.AddChart("Sheet1", "E1", `{
  20.         "type": "doughnut",
  21.         "series": [
  22.         {
  23.             "name": "Sheet1!$A$2",
  24.             "categories": "Sheet1!$A$1:$C$1",
  25.             "values": "Sheet1!$A$2:$C$2"
  26.         }],
  27.         "format":
  28.         {
  29.             "x_scale": 1.0,
  30.             "y_scale": 1.0,
  31.             "x_offset": 15,
  32.             "y_offset": 10,
  33.             "print_obj": true,
  34.             "lock_aspect_ratio": false,
  35.             "locked": false
  36.         },
  37.         "legend":
  38.         {
  39.             "position": "right",
  40.             "show_legend_key": false
  41.         },
  42.         "title":
  43.         {
  44.             "name": "Fruit Doughnut Chart"
  45.         },
  46.         "plotarea":
  47.         {
  48.             "show_bubble_size": false,
  49.             "show_cat_name": false,
  50.             "show_leader_lines": false,
  51.             "show_percent": true,
  52.             "show_series_name": false,
  53.             "show_val": false
  54.         },
  55.         "show_blanks_as": "zero"
  56.     }`); err != nil {
  57.         fmt.Println(err)
  58.     }
  59.     // 保存工作簿
  60.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  61.         fmt.Println(err)
  62.     }
  63. }