二维面积图

例如，创建如下效果的二维面积图：

使用 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{"A2": "Small", "A3": "Normal", "A4": "Large", "B1": "Apple", "C1": "Orange", "D1": "Pear"}
  11.     values := map[string]int{"B2": 7, "C2": 7, "D2": 8, "B3": 5, "C3": 4, "D3": 4, "B4": 2, "C4": 3, "D4": 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": "area",
  21.         "series": [
  22.         {
  23.             "name": "Sheet1!$A$2",
  24.             "categories": "Sheet1!$B$1:$D$1",
  25.             "values": "Sheet1!$B$2:$D$2"
  26.         },
  27.         {
  28.             "name": "Sheet1!$A$3",
  29.             "categories": "Sheet1!$B$1:$D$1",
  30.             "values": "Sheet1!$B$3:$D$3"
  31.         },
  32.         {
  33.             "name": "Sheet1!$A$4",
  34.             "categories": "Sheet1!$B$1:$D$1",
  35.             "values": "Sheet1!$B$4:$D$4"
  36.         }],
  37.         "format":
  38.         {
  39.             "x_scale": 1.0,
  40.             "y_scale": 1.0,
  41.             "x_offset": 15,
  42.             "y_offset": 10,
  43.             "print_obj": true,
  44.             "lock_aspect_ratio": false,
  45.             "locked": false
  46.         },
  47.         "legend":
  48.         {
  49.             "position": "bottom",
  50.             "show_legend_key": false
  51.         },
  52.         "title":
  53.         {
  54.             "name": "Fruit 2D Area Chart"
  55.         },
  56.         "plotarea":
  57.         {
  58.             "show_bubble_size": true,
  59.             "show_cat_name": false,
  60.             "show_leader_lines": false,
  61.             "show_percent": true,
  62.             "show_series_name": true,
  63.             "show_val": true
  64.         },
  65.         "show_blanks_as": "zero"
  66.     }`); err != nil {
  67.         fmt.Println(err)
  68.     }
  69.     // 保存工作簿
  70.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  71.         fmt.Println(err)
  72.     }
  73. }