1. package main
    3. import (
    4.     "fmt"
    5.     "strings"
    7.     "github.com/xuri/excelize/v2"
    8. )
    10. func main() {
    11.     f, err := excelize.OpenFile("Book1.xlsx")
    12.     if err != nil {
    13.         fmt.Println(err)
    14.         return
    16.     if err = f.Close(); err != nil {
    17.         fmt.Println(err)
    18.     }
    19. }
    21. func getCellBgColor(f *excelize.File, sheet, axix string) string {
    22.     styleID, err := f.GetCellStyle(sheet, axix)
    23.     if err != nil {
    24.         return err.Error()
    25.     }
    26.     fillID := *f.Styles.CellXfs.Xf[styleID].FillID
    27.     fgColor := f.Styles.Fills.Fill[fillID].PatternFill.FgColor
    28.     if fgColor != nil {
    29.         if fgColor.Theme != nil {
    31.                 dklt := map[int]string{
    32.                     0: children[1].SysClr.LastClr,
    33.                     1: children[0].SysClr.LastClr,
    34.                     2: *children[3].SrgbClr.Val,
    35.                     3: *children[2].SrgbClr.Val,
    36.                 }
    37.                 return strings.TrimPrefix(
    38.                     excelize.ThemeColor(dklt[*fgColor.Theme], fgColor.Tint), "FF")
    39.             }
    40.             srgbClr := *children[*fgColor.Theme].SrgbClr.Val
    41.             return strings.TrimPrefix(excelize.ThemeColor(srgbClr, fgColor.Tint), "FF")
    42.         }
    43.         return strings.TrimPrefix(fgColor.RGB, "FF")
    44.     }