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{
    38.                 Italic: true,
    39.                 Family: "Times New Roman",
    40.             },
    41.         },
    42.         {
    43.             Text: "text with color and font-family,",
    44.             Font: &excelize.Font{
    45.                 Bold:   true,
    46.                 Color:  "2354e8",
    47.                 Family: "Times New Roman",
    48.             },
    49.         },
    50.         {
    51.             Text: "\r\nlarge text with ",
    52.             Font: &excelize.Font{
    53.                 Size:  14,
    54.                 Color: "ad23e8",
    55.             },
    56.         },
    57.         {
    58.             Text: "strike",
    59.             Font: &excelize.Font{
    60.                 Color:  "e89923",
    61.                 Strike: true,
    62.             },
    63.         },
    64.         {
    65.             Text: " superscript",
    66.             Font: &excelize.Font{
    67.                 Color:     "dbc21f",
    68.                 VertAlign: "superscript",
    69.             },
    70.         },
    71.         {
    72.             Text: " and ",
    73.             Font: &excelize.Font{
    75.                 VertAlign: "baseline",
    76.             },
    77.         },
    78.         {
    79.             Text: "underline",
    80.             Font: &excelize.Font{
    81.                 Color:     "23e833",
    82.                 Underline: "single",
    83.             },
    84.         },
    85.         {
    86.             Text: " subscript.",
    87.             Font: &excelize.Font{
    88.                 Color:     "017505",
    89.                 VertAlign: "subscript",
    90.             },
    91.         },
    92.     }); err != nil {
    93.         fmt.Println(err)
    94.         return
    95.     }
    96.     style, err := f.NewStyle(&excelize.Style{
    97.         Alignment: &excelize.Alignment{
    98.             WrapText: true,
    99.         },
    100.     })
    101.     if err != nil {
    102.         fmt.Println(err)
    103.         return
    104.     }
    105.     if err := f.SetCellStyle("Sheet1", "A1", "A1", style); err != nil {
    106.         fmt.Println(err)
    107.         return
    108.     }
    109.     if err := f.SaveAs("Book1.xlsx"); err != nil {
    110.         fmt.Println(err)