设置富文本格式

  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: " superscript",
  67.             Font: &excelize.Font{
  68.                 Color:     "dbc21f",
  69.                 VertAlign: "superscript",
  70.             },
  71.         },
  72.         {
  73.             Text: " and ",
  74.             Font: &excelize.Font{
  75.                 Size:      14,
  76.                 Color:     "ad23e8",
  77.                 VertAlign: "baseline",
  78.             },
  79.         },
  80.         {
  81.             Text: "underline",
  82.             Font: &excelize.Font{
  83.                 Color:     "23e833",
  84.                 Underline: "single",
  85.             },
  86.         },
  87.         {
  88.             Text: " subscript.",
  89.             Font: &excelize.Font{
  90.                 Color:     "017505",
  91.                 VertAlign: "subscript",
  92.             },
  93.         },
  94.     }); err != nil {
  95.         fmt.Println(err)
  96.         return
  97.     }
  98.     style, err := f.NewStyle(&excelize.Style{
  99.         Alignment: &excelize.Alignment{
  100.             WrapText: true,
  101.         },
  102.     })
  103.     if err != nil {
  104.         fmt.Println(err)
  105.         return
  106.     }
  107.     if err := f.SetCellStyle("Sheet1", "A1", "A1", style); err != nil {
  108.         fmt.Println(err)
  109.         return
  110.     }
  111.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  112.         fmt.Println(err)
  113.     }
  114. }