散点图

例如，创建如下效果的散点图：

使用 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.         {nil, "Apple", "Orange", "Pear"},
  18.         {"Small", 2, 3, 3},
  19.         {"Normal", 5, 2, 4},
  20.         {"Large", 6, 7, 8},
  21.     } {
  22.         cell, err := excelize.CoordinatesToCellName(1, idx+1)
  23.         if err != nil {
  24.             fmt.Println(err)
  25.             return
  26.         }
  27.         if err := f.SetSheetRow("Sheet1", cell, &row); err != nil {
  28.             fmt.Println(err)
  29.             return
  30.         }
  31.     }
  32.     if err := f.AddChart("Sheet1", "E1", &excelize.Chart{
  33.         Type: excelize.Scatter,
  34.         Series: []excelize.ChartSeries{
  35.             {
  36.                 Name:       "Sheet1!$A$2",
  37.                 Categories: "Sheet1!$B$1:$D$1",
  38.                 Values:     "Sheet1!$B$2:$D$2",
  39.             },
  40.             {
  41.                 Name:       "Sheet1!$A$3",
  42.                 Categories: "Sheet1!$B$1:$D$1",
  43.                 Values:     "Sheet1!$B$3:$D$3",
  44.             },
  45.             {
  46.                 Name:       "Sheet1!$A$4",
  47.                 Categories: "Sheet1!$B$1:$D$1",
  48.                 Values:     "Sheet1!$B$4:$D$4",
  49.             },
  50.         },
  51.         Format: excelize.GraphicOptions{
  52.             OffsetX: 15,
  53.             OffsetY: 10,
  54.         },
  55.         Legend: excelize.ChartLegend{
  56.             Position: "left",
  57.         },
  58.         Title: []excelize.RichTextRun{
  59.             {
  60.                 Text: "Fruit Scatter Chart",
  61.             },
  62.         },
  63.         PlotArea: excelize.ChartPlotArea{
  64.             ShowCatName:     false,
  65.             ShowLeaderLines: false,
  66.             ShowPercent:     true,
  67.             ShowSerName:     true,
  68.             ShowVal:         true,
  69.         },
  70.         ShowBlanksAs: "zero",
  71.     }); err != nil {
  72.         fmt.Println(err)
  73.         return
  74.     }
  75.     // 保存工作簿
  76.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  77.         fmt.Println(err)
  78.     }
  79. }