officefileapi-120604-spreadsheet-document-api-examples-formatting-how-to-apply-rich-formatting-to-cell-text.md
Use the RichTextString object’s members to format text values within spreadsheet cells. Rich text consists of one or more text regions (or text runs ), each with its own set of font characteristics. The RichTextString.Runs property provides access to a text run collection. A RichTextRun object defines an individual run within a collection.
Use the following members to apply rich formatting to the cell’s text.
|
Member
|
Description
| | --- | --- | |
|
Adds a new text run with the specified font settings to the rich text string.
| |
|
Allows you to format specific characters within the cell’s text.
| |
|
Allows you to specify font attributes for specific characters within the cell’s text.
| |
|
Gets or sets the full text displayed in a cell.
| |
|
Assigns rich formatted text to a cell.
|
Example I
Example II
|
|
Checks whether a cell contains rich formatted text.
| |
|
Retrieves rich text from a cell.
| |
|
Allows you to iterate through a collection of the existing text runs.
| |
|
Gets the current run’s text.
| |
|
Gets font attributes applied to the current run.
|
The following example shows how to apply rich formatting to a cell that already contains a text value.
// Set a cell value.
worksheet["B2"].Value = "Rich text formatting";
// Obtain the RichTextString object containing the cell text.
RichTextString richText = worksheet["B2"].GetRichText();
// Format the first word as bold.
richText.Characters(0, 4).Font.Bold = true;
// Assign the rich formatted text to the cell B2.
worksheet["B2"].SetRichText(richText);
' Set a cell value.
worksheet("B2").Value = "Rich text formatting"
' Obtain the RichTextString object containing the cell text.
Dim richText As RichTextString = worksheet("B2").GetRichText()
' Format the first word as bold.
richText.Characters(0, 4).Font.Bold = True
' Assign the rich formatted text to the cell B2.
worksheet("B2").SetRichText(richText)
|
|
Gets or sets the full text contained in a cell.
You can also use the cell’s CellRange.Value property to obtain the resulting text string as plain text.
| |
|
Returns the rich text length.
|