Rich formatted text in a cell.
A cell in a worksheet may contain rich formatted text specified by the RichTextString object. Such rich text represents a cell text divided into one or more text regions (so-called text runs), each with its own set of font characteristics. An individual text run is defined by the RichTextRun object and is stored in the RichTextString.Runs collection.
To apply rich formatting to the cell text, do one of the following:
Pass the RichTextString instance to the Range.SetRichText method to assign the specified rich text to a cell.
For more information on how to apply different fonts to specific regions of the cell text, refer to the How to: Apply Rich Formatting to Cell Text example.
// Create a RichTextString instance. RichTextString richText = new RichTextString(); // Specify the cell text. richText.Text = "Rich text formatting"; // Change font characteristics of the first word. richText.Characters(0, 4).SetFont(new RichTextRunFont("Calibri", 12, System.Drawing.Color.Red)); // Assign the rich formatted text to the cell B2. worksheet["B2"].SetRichText(richText);