package main

import (
	"fmt"
	"github.com/xuri/excelize/v2"
)

func main() {
	f := excelize.NewFile()
	defer func() {
		if err := f.Close(); err != nil {
			fmt.Println(err)
		}
	}()
	data := [][]interface{}{
		{"MonYear", "Aug-23", "Sep-23", "Oct-23", "Nov-23", "Dec-23", "Jan-24", "Feb-24", "Mar-24", "Apr-24", "May-24", "Jun-24"},
		{"a", 14, 14, 14, 12, 14, 14, 13, 13, 12, 13, 4},
		{"b", 3, 2, 4, 3, 2, 3, 2, 3, 2, 1, 0},
		{"c", 44198, 44366, 44683, 44857, 44762, 44949, 45005, 45157, 45483, 45574, 45435},
	}
	for idx, col := range data {
		cell, err := excelize.CoordinatesToCellName(idx+1, 1)
		if err != nil {
			fmt.Println(err)
			return
		}
		f.SetSheetCol("Sheet1", cell, &col)
	}
	disable := false
	if err := f.AddChart("Sheet1", "F1", &excelize.Chart{
		Type:       excelize.Col,
		Dimension:  excelize.ChartDimension{Width: 1080, Height: 576},
		XAxis:      excelize.ChartAxis{Font: excelize.Font{Color: "000000"}},
		YAxis:      excelize.ChartAxis{Font: excelize.Font{Color: "000000"}, MajorGridLines: true},
		VaryColors: &disable,
		PlotArea:   excelize.ChartPlotArea{ShowVal: true, NumFmt: excelize.ChartNumFmt{CustomNumFmt: "#\"\""}},
		Series: []excelize.ChartSeries{
			{
				Name:              "Sheet1!$B$1",
				Categories:        "Sheet1!$A$2:$A$12",
				Values:            "Sheet1!$B$2:$B$12",
				Fill:              excelize.Fill{Type: "pattern", Color: []string{"1F77B4"}, Pattern: 1},
				DataLabelPosition: excelize.ChartDataLabelsPositionInsideEnd,
			},
			{
				Name:              "Sheet1!$C$1",
				Categories:        "Sheet1!$A$2:$A$12",
				Values:            "Sheet1!$C$2:$C$12",
				Fill:              excelize.Fill{Type: "pattern", Color: []string{"FF7F0E"}, Pattern: 1},
				DataLabelPosition: excelize.ChartDataLabelsPositionInsideEnd,
			},
		},
		Title: []excelize.RichTextRun{
			{
				Text: "Combo column and line chart",
			},
		},
	},
		&excelize.Chart{
			Type:       excelize.Line,
			Dimension:  excelize.ChartDimension{Width: 1080, Height: 576},
			YAxis:      excelize.ChartAxis{Secondary: true, None: true},
			VaryColors: &disable,
			PlotArea:   excelize.ChartPlotArea{ShowVal: true, NumFmt: excelize.ChartNumFmt{CustomNumFmt: "#\"\""}},
			Series: []excelize.ChartSeries{
				{
					Name:              "Sheet1!$D$1",
					Categories:        "Sheet1!$A$2:$A$12",
					Values:            "Sheet1!$D$2:$D$12",
					Fill:              excelize.Fill{Type: "pattern", Color: []string{"2CA02C"}, Pattern: 1},
					DataLabelPosition: excelize.ChartDataLabelsPositionAbove,
					Marker:            excelize.ChartMarker{Symbol: "none"},
				},
			},
		}); err != nil {
		fmt.Println(err)
		return
	}
	// Save spreadsheet by the given path.
	if err := f.SaveAs("Book1.xlsx"); err != nil {
		fmt.Println(err)
	}
}