折线图

例如，创建如下效果的折线图：

使用 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.Line,
  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.                 Line: excelize.ChartLine{
  40.                     Smooth: true,
  41.                 },
  42.             },
  43.             {
  44.                 Name:       "Sheet1!$A$3",
  45.                 Categories: "Sheet1!$B$1:$D$1",
  46.                 Values:     "Sheet1!$B$3:$D$3",
  47.                 Line: excelize.ChartLine{
  48.                     Smooth: true,
  49.                 },
  50.             },
  51.             {
  52.                 Name:       "Sheet1!$A$4",
  53.                 Categories: "Sheet1!$B$1:$D$1",
  54.                 Values:     "Sheet1!$B$4:$D$4",
  55.                 Line: excelize.ChartLine{
  56.                     Smooth: true,
  57.                 },
  58.             },
  59.         },
  60.         Format: excelize.GraphicOptions{
  61.             OffsetX: 15,
  62.             OffsetY: 10,
  63.         },
  64.         Legend: excelize.ChartLegend{
  65.             Position: "top",
  66.         },
  67.         Title: []excelize.RichTextRun{
  68.             {
  69.                 Text: "Fruit Line Chart",
  70.             },
  71.         },
  72.         PlotArea: excelize.ChartPlotArea{
  73.             ShowCatName:     false,
  74.             ShowLeaderLines: false,
  75.             ShowPercent:     true,
  76.             ShowSerName:     true,
  77.             ShowVal:         true,
  78.         },
  79.         ShowBlanksAs: "zero",
  80.     }); err != nil {
  81.         fmt.Println(err)
  82.         return
  83.     }
  84.     // 保存工作簿
  85.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  86.         fmt.Println(err)
  87.     }
  88. }