How To Insert Checkbox

[Airell98]

Hello everyone, I'd like to know if there's a way for me to insert a checkbox into the spreadsheet. I'm currently using version 2 of the excelize package.

Thank you in advance.

[xuri]

Excelize support add form controls by AddFormControl function from v2.8.0. Please reference the documentation for more details. For example:

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)
        }
    }()
    if err := f.AddFormControl("Sheet1", excelize.FormControl{
        Cell: "A2",
        Type: excelize.FormControlCheckBox,
        Text: "Checkbox 1",
    }); err != nil {
        fmt.Println(err)
        return
    }
    if err := f.AddFormControl("Sheet1", excelize.FormControl{
        Cell:    "A4",
        Type:    excelize.FormControlCheckBox,
        Text:    "Checkbox 2",
        Checked: true,
    }); err != nil {
        fmt.Println(err)
        return
    }
    if err := f.SaveAs("Book1.xlsx"); err != nil {
        fmt.Println(err)
    }
}