设置富文本格式

  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.     if err := f.SetRowHeight("Sheet1", 1, 35); err != nil {
  12.         fmt.Println(err)
  13.         return
  14.     }
  15.     if err := f.SetColWidth("Sheet1", "A", "A", 44); err != nil {
  16.         fmt.Println(err)
  17.         return
  18.     }
  19.     if err := f.SetCellRichText("Sheet1", "A1", []excelize.RichTextRun{
  20.         {
  21.             Text: "bold",
  22.             Font: &excelize.Font{
  23.                 Bold:   true,
  24.                 Color:  "2354e8",
  25.                 Family: "Times New Roman",
  26.             },
  27.         },
  28.         {
  29.             Text: " and ",
  30.             Font: &excelize.Font{
  31.                 Family: "Times New Roman",
  32.             },
  33.         },
  34.         {
  35.             Text: "italic",
  36.             Font: &excelize.Font{
  37.                 Bold:   true,
  38.                 Color:  "e83723",
  39.                 Italic: true,
  40.                 Family: "Times New Roman",
  41.             },
  42.         },
  43.         {
  44.             Text: "text with color and font-family,",
  45.             Font: &excelize.Font{
  46.                 Bold:   true,
  47.                 Color:  "2354e8",
  48.                 Family: "Times New Roman",
  49.             },
  50.         },
  51.         {
  52.             Text: "\r\nlarge text with ",
  53.             Font: &excelize.Font{
  54.                 Size:  14,
  55.                 Color: "ad23e8",
  56.             },
  57.         },
  58.         {
  59.             Text: "strike",
  60.             Font: &excelize.Font{
  61.                 Color:  "e89923",
  62.                 Strike: true,
  63.             },
  64.         },
  65.         {
  66.             Text: " and ",
  67.             Font: &excelize.Font{
  68.                 Size:  14,
  69.                 Color: "ad23e8",
  70.             },
  71.         },
  72.         {
  73.             Text: "underline.",
  74.             Font: &excelize.Font{
  75.                 Color:     "23e833",
  76.                 Underline: "single",
  77.             },
  78.         },
  79.     }); err != nil {
  80.         fmt.Println(err)
  81.         return
  82.     }
  83.     style, err := f.NewStyle(&excelize.Style{
  84.         Alignment: &excelize.Alignment{
  85.             WrapText: true,
  86.         },
  87.     })
  88.     if err != nil {
  89.         fmt.Println(err)
  90.         return
  91.     }
  92.     if err := f.SetCellStyle("Sheet1", "A1", "A1", style); err != nil {
  93.         fmt.Println(err)
  94.         return
  95.     }
  96.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  97.         fmt.Println(err)
  98.     }
  99. }