设置富文本格式

  1. func (f *File) SetCellRichText(sheet, cell string, runs []RichTextRun) error

根据给定的工作表、单元格坐标和富文本格式为指定单元格设置富文本。

例如，在名为 Sheet1 的工作表 A1 单元格设置富文本格式：

设置富文本格式

  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.     if err := f.SetRowHeight("Sheet1", 1, 35); err != nil {
  17.         fmt.Println(err)
  18.         return
  19.     }
  20.     if err := f.SetColWidth("Sheet1", "A", "A", 44); err != nil {
  21.         fmt.Println(err)
  22.         return
  23.     }
  24.     if err := f.SetCellRichText("Sheet1", "A1", []excelize.RichTextRun{
  25.         {
  26.             Text: "bold",
  27.             Font: &excelize.Font{
  28.                 Bold:   true,
  29.                 Color:  "2354E8",
  30.                 Family: "Times New Roman",
  31.             },
  32.         },
  33.         {
  34.             Text: " and ",
  35.             Font: &excelize.Font{
  36.                 Family: "Times New Roman",
  37.             },
  38.         },
  39.         {
  40.             Text: "italic ",
  41.             Font: &excelize.Font{
  42.                 Bold:   true,
  43.                 Color:  "E83723",
  44.                 Italic: true,
  45.                 Family: "Times New Roman",
  46.             },
  47.         },
  48.         {
  49.             Text: "text with color and font-family,",
  50.             Font: &excelize.Font{
  51.                 Bold:   true,
  52.                 Color:  "2354E8",
  53.                 Family: "Times New Roman",
  54.             },
  55.         },
  56.         {
  57.             Text: "\r\nlarge text with ",
  58.             Font: &excelize.Font{
  59.                 Size:  14,
  60.                 Color: "AD23E8",
  61.             },
  62.         },
  63.         {
  64.             Text: "strike",
  65.             Font: &excelize.Font{
  66.                 Color:  "E89923",
  67.                 Strike: true,
  68.             },
  69.         },
  70.         {
  71.             Text: " superscript",
  72.             Font: &excelize.Font{
  73.                 Color:     "DBC21F",
  74.                 VertAlign: "superscript",
  75.             },
  76.         },
  77.         {
  78.             Text: " and ",
  79.             Font: &excelize.Font{
  80.                 Size:      14,
  81.                 Color:     "AD23E8",
  82.                 VertAlign: "baseline",
  83.             },
  84.         },
  85.         {
  86.             Text: "underline",
  87.             Font: &excelize.Font{
  88.                 Color:     "23E833",
  89.                 Underline: "single",
  90.             },
  91.         },
  92.         {
  93.             Text: " subscript.",
  94.             Font: &excelize.Font{
  95.                 Color:     "017505",
  96.                 VertAlign: "subscript",
  97.             },
  98.         },
  99.     }); err != nil {
  100.         fmt.Println(err)
  101.         return
  102.     }
  103.     style, err := f.NewStyle(&excelize.Style{
  104.         Alignment: &excelize.Alignment{
  105.             WrapText: true,
  106.         },
  107.     })
  108.     if err != nil {
  109.         fmt.Println(err)
  110.         return
  111.     }
  112.     if err := f.SetCellStyle("Sheet1", "A1", "A1", style); err != nil {
  113.         fmt.Println(err)
  114.         return
  115.     }
  116.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  117.         fmt.Println(err)
  118.     }
  119. }