日历

使用 Go 语言在 Excel 文档中创建日历：

使用 Go 语言在 Excel 文档中创建日历

  1. package main
  3. import (
  4.     "fmt"
  5.     "strconv"
  7.     "github.com/360EntSecGroup-skylar/excelize"
  8. )
  10. func main() {
  11.     // 创建工作簿
  12.     f := excelize.NewFile()
  13.     var (
  14.         monthStyle, titleStyle, dataStyle, blankStyle,
  15.         grayBlankStyle, grayDataStyle, noteStyle, noteLineStyle int
  16.         err   error
  17.         addr  string
  18.         sheet = "Sheet1"
  19.         // 定义单元格的值
  20.         data = map[int][]interface{}{
  21.             1: {"五月 2020"},
  22.             3: {"日", "一", "二", "三",
  23.                 "四", "五", "六"},
  24.             4:  {26, 27, 28, 29, 30, 1, 2},
  25.             6:  {3, 4, 5, 6, 7, 8, 9},
  26.             8:  {10, 11, 12, 13, 14, 15, 16},
  27.             10: {17, 18, 19, 20, 21, 22, 23},
  28.             12: {24, 25, 26, 27, 28, 29, 30},
  29.             14: {31, 1, 2, 3, 4, 5, 6},
  30.             18: {"笔记"},
  31.         }
  32.         // 自定义行高
  33.         height = map[int]float64{
  34.             1: 45, 3: 22, 5: 44, 7: 44, 9: 44, 11: 44, 13: 44, 15: 44,
  35.             18: 24, 19: 24, 20: 24, 21: 24, 22: 24, 23: 24, 24: 24,
  36.         }
  37.         top    = excelize.Border{Type: "top", Style: 1, Color: "DADEE0"}
  38.         left   = excelize.Border{Type: "left", Style: 1, Color: "DADEE0"}
  39.         right  = excelize.Border{Type: "right", Style: 1, Color: "DADEE0"}
  40.         bottom = excelize.Border{Type: "bottom", Style: 1, Color: "DADEE0"}
  41.         fill   = excelize.Fill{Type: "pattern", Color: []string{"EFEFEF"}, Pattern: 1}
  42.     )
  43.     // 按行赋值
  44.     for r, row := range data {
  45.         if addr, err = excelize.JoinCellName("B", r); err != nil {
  46.             fmt.Println(err)
  47.             return
  48.         }
  49.         if err = f.SetSheetRow(sheet, addr, &row); err != nil {
  50.             fmt.Println(err)
  51.             return
  52.         }
  53.     }
  54.     // 设置自定义行高
  55.     for r, ht := range height {
  56.         if err = f.SetRowHeight(sheet, r, ht); err != nil {
  57.             fmt.Println(err)
  58.             return
  59.         }
  60.     }
  61.     // 设置列宽
  62.     if err = f.SetColWidth(sheet, "B", "H", 16.5); err != nil {
  63.         fmt.Println(err)
  64.         return
  65.     }
  66.     // 合并月份单元格
  67.     if err = f.MergeCell(sheet, "B1", "D1"); err != nil {
  68.         fmt.Println(err)
  69.         return
  70.     }
  71.     // 设置月份单元格样式
  72.     if monthStyle, err = f.NewStyle(&excelize.Style{
  73.         Font: &excelize.Font{Color: "1f7f3b", Bold: true, Size: 22, Family: "Arial"},
  74.     }); err != nil {
  75.         fmt.Println(err)
  76.         return
  77.     }
  78.     // 设置月份单元格字体
  79.     if err = f.SetCellStyle(sheet, "B1", "D1", monthStyle); err != nil {
  80.         fmt.Println(err)
  81.         return
  82.     }
  83.     // 创建周一至周日标题行样式
  84.     if titleStyle, err = f.NewStyle(&excelize.Style{
  85.         Font:      &excelize.Font{Color: "1f7f3b", Bold: true, Family: "Arial"},
  86.         Fill:      excelize.Fill{Type: "pattern", Color: []string{"E6F4EA"}, Pattern: 1},
  87.         Alignment: &excelize.Alignment{Vertical: "center", Horizontal: "center"},
  88.         Border:    []excelize.Border{{Type: "top", Style: 2, Color: "1f7f3b"}},
  89.     }); err != nil {
  90.         fmt.Println(err)
  91.         return
  92.     }
  93.     // 设置周一至周日标题行样式
  94.     if err = f.SetCellStyle(sheet, "B3", "H3", titleStyle); err != nil {
  95.         fmt.Println(err)
  96.         return
  97.     }
  98.     // 创建日期单元格样式
  99.     if dataStyle, err = f.NewStyle(&excelize.Style{
  100.         Border: []excelize.Border{top, left, right},
  101.     }); err != nil {
  102.         fmt.Println(err)
  103.         return
  104.     }
  105.     // 设置日期单元格样式
  106.     for _, r := range []int{4, 6, 8, 10, 12, 14} {
  107.         if err = f.SetCellStyle(sheet, "B"+strconv.Itoa(r),
  108.             "H"+strconv.Itoa(r), dataStyle); err != nil {
  109.             fmt.Println(err)
  110.             return
  111.         }
  112.     }
  113.     // 创建空白单元格样式
  114.     if blankStyle, err = f.NewStyle(&excelize.Style{
  115.         Border: []excelize.Border{left, right, bottom},
  116.     }); err != nil {
  117.         fmt.Println(err)
  118.         return
  119.     }
  120.     // 设置空白单元格样式
  121.     for _, r := range []int{5, 7, 9, 11, 13, 15} {
  122.         if err = f.SetCellStyle(sheet, "B"+strconv.Itoa(r),
  123.             "H"+strconv.Itoa(r), blankStyle); err != nil {
  124.             fmt.Println(err)
  125.             return
  126.         }
  127.     }
  128.     // 创建上个月和下个月日期中的空白单元格样式
  129.     if grayBlankStyle, err = f.NewStyle(&excelize.Style{
  130.         Border: []excelize.Border{left, right, bottom},
  131.         Fill:   fill}); err != nil {
  132.         fmt.Println(err)
  133.         return
  134.     }
  135.     // 设置上个月和下个月日期中的空白单元格样式
  136.     if err = f.SetCellStyle(sheet, "B5", "F5", grayBlankStyle); err != nil {
  137.         fmt.Println(err)
  138.         return
  139.     }
  140.     if err = f.SetCellStyle(sheet, "C15", "H15", grayBlankStyle); err != nil {
  141.         fmt.Println(err)
  142.         return
  143.     }
  144.     // 创建上个月和下个月日期的单元格样式
  145.     if grayDataStyle, err = f.NewStyle(&excelize.Style{
  146.         Border: []excelize.Border{left, right, top},
  147.         Font:   &excelize.Font{Color: "777777"}, Fill: fill}); err != nil {
  148.         fmt.Println(err)
  149.         return
  150.     }
  151.     // 设置上个月和下个月日期的单元格样式
  152.     if err = f.SetCellStyle(sheet, "B4", "F4", grayDataStyle); err != nil {
  153.         fmt.Println(err)
  154.         return
  155.     }
  156.     if err = f.SetCellStyle(sheet, "C14", "H14", grayDataStyle); err != nil {
  157.         fmt.Println(err)
  158.         return
  159.     }
  160.     // 创建笔记单元格样式
  161.     if noteStyle, err = f.NewStyle(&excelize.Style{
  162.         Font: &excelize.Font{Color: "1f7f3b", Bold: true, Size: 14, Family: "Arial"},
  163.     }); err != nil {
  164.         fmt.Println(err)
  165.         return
  166.     }
  167.     // 设置笔记单元格样式
  168.     if err = f.SetCellStyle(sheet, "B18", "B18", noteStyle); err != nil {
  169.         fmt.Println(err)
  170.         return
  171.     }
  172.     // 创建笔记区域横线样式
  173.     if noteLineStyle, err = f.NewStyle(&excelize.Style{
  174.         Border: []excelize.Border{{Type: "bottom", Style: 4, Color: "DDDDDD"}},
  175.     }); err != nil {
  176.         fmt.Println(err)
  177.         return
  178.     }
  179.     // 设置笔记区域横线样式
  180.     for r := 19; r < 25; r++ {
  181.         if err = f.SetCellStyle(sheet, "B"+strconv.Itoa(r),
  182.             "H"+strconv.Itoa(r), noteLineStyle); err != nil {
  183.             fmt.Println(err)
  184.             return
  185.         }
  186.     }
  187.     // 隐藏工作表网格线
  188.     if err = f.SetSheetViewOptions(sheet, 0,
  189.         excelize.ShowGridLines(false)); err != nil {
  190.         fmt.Println(err)
  191.         return
  192.     }
  193.     // 重命名工作表
  194.     f.SetSheetName(sheet, "五月 20")
  195.     // 保存工作簿
  196.     if err = f.SaveAs("日历.xlsx"); err != nil {
  197.         fmt.Println(err)
  198.     }
  199. }